Permissions for SQL Server Agent & Activity Monitor

[katehol]

I am currently setting up various access groups for SQL Server Management Studio and am struggling to find the permission scripts that will allow me to give people access to the Activity Monitor (under the Management folder) and also to the SQL Server Agent (showing all of the scheduled josb etc). The problem is that as soon as I remove permissions to certain actions, the users can no longer see these folders on the left hand pane.

Any clues???

 

[mrdenny]

For the SQL Agent, make then a member of the SQLAgentUserRole. If you give them the VIEW SERVER STATE role then they can view the process information, which should be able to allow them to view the process monitor.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog