I'm trying to run Adam Machanic's
sp_WhoIsActive in AWS RDS for SQL Server. When I run as the designated master account, say "TheAdmin", it works. When I run as another user, say "AlmostAdmin", whom I've made a
db_owner on the target DB, say "MyDB", it fails with permission errors like so:
Msg 297, Level 16, State 1, Line 49 The user does not have permission to perform this action. Msg 297, Level 16, State 1, Line 342 The user does not have permission to perform this action.
Note that, because you can't create any objects in the
master DB in RDS, I had to create
sp_WhoIsActive in the user DB
MyDB, as stated.
Anybody had any luck making this work in RDS? Thanks!
Other things I've tried:
VIEW SERVER STATEto "AlmostAdmin" and added him to server-roles
setupadminto mirror "TheAdmin".
- Added "AlmostAdmin" to all other elevated DB roles in
MyDB(yeah, I know, shouldn't make a difference, just grasping at straws).