To view the Activity Monitor the user needs VIEW SERVER STATE permission on a SQL Server 2005 server.
Permission to KILL a process default to the members of the sysadmin and processadmin fixed database roles, and are not transferable.
References: http://msdn.microsoft.com/en-us/library/ms175518(SQL.90,printer).aspx
Wednesday, November 25, 2009
How to give access to SQL 2005 Activity Monitor
Labels:
Management Studio,
SQL 2005,
SSMS,
User Rights
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment