For SQL Server 2000 we have a user login mapped to msdb with database role membership of db_datareader and public checked. This seems to allow the developers to view the Management Activity monitor. For SQL Server 2005 the same mapping is in place but the developers cannot view the Management Activity monitor. Developers are NOT granted the sysadmin role, and should not have that role.
What permissions need to be set for SQL Server 2005 to allow users to view the Management Activity monitor They should not be allowed to take actions on the activities.
Permissions in SQL Server 2005 to allow users to view the Management Activity monitor?
ti_m
Hi,
Aside from executing this "GRANT VIEW SERVER STATE TO <<login name>>" is there any other views that need to look on. Basically, what are the other views that can be revoked after granting this server state. We would just like to ensure that the least grant were given to a particular user.
Federico Poggio
Where do you set this: To view the Activity Monitor the user needs VIEW SERVER STATE permission on a SQL Server 2005 server.
bieblsoft
The easiest way is to just open a connection (i.e. using sqlcmd or Management Studio) using your sysadmin credentials and issue the following statement:
GRANT VIEW SERVER STATE TO <<login name>>
This will grant <<login_name>> VIEW ANY STATE permission.
-Raul Garcia
SDE/T
SQL Server Engine
Marcos Bertoldi
The Active Monitor tool requires VIEW SERVER STATE permission; this permission is required to select from DMVs such as sys.sysprocesses.
-Raul Garcia
SDE/T
SQL Server Engine
Nkomo
Unfortunately I am not familiar with the different GUI tools available for SQL Express. I would recommend asking this question on the SQL Express forum (http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=385&SiteID=1) instead.
Thanks,
-Raul Garcia
SDE/T
SQL Server Engine
riga66
Thank you so much! This did the trick.
Barb
antxxxx
Does Management Studio Express support the Activity Monitor
I've enabled VIEW SERVER STATE for admin and still can't find the Activity Monitor in the GUI.
Thanks