March 3, 2009 at 1:50 pm
How can i give activity monitor to my "bi group" users so they can see the silly command they run on the database and what effect it is having without giving sa rights.
Cheers
March 3, 2009 at 7:11 pm
From books online-->
To view the Activity Monitor the user needs VIEW SERVER STATE permission on a SQL Server 2005 server.
To view the Activity Monitor the user needs SELECT permission to the sysprocesses and syslocks tables in the master database on a SQL Server 2000 server. Permission to view these tables is granted by default to the PUBLIC database role.
Permission to KILL a process default to the members of the sysadmin and processadmin fixed database roles, and are not transferable.
http://msdn.microsoft.com/en-us/library/ms175518.aspx
MJ
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply