Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

how to giver users access to viewing JOB Activity Monitor Expand / Collapse
Posted Tuesday, April 13, 2010 11:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 2, 2016 12:59 AM
Points: 6, Visits: 434
I want to give access to some users to view the job activity monitor. Now I know there is the new MSDB roles, SQLAgentUserRole, SQLAgentReaderRole etc in SQL Server 2005 but these don't fit the bill because typically the owner of all jobs is sa so I can't use SQLAgentUserRole and I don't want the user be able to do anything other than READ from the Job Activity Monitor so I can't use SQLAgentReaderRole - so how can I do it or can it even be done?
Post #902881
Posted Thursday, April 15, 2010 2:09 PM


Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
If owner of all the jobs is sa then sqlagentreader role suits your scenario.
Post #904369
Posted Tuesday, October 16, 2012 4:45 PM


Group: General Forum Members
Last Login: Thursday, March 17, 2016 1:13 PM
Points: 10, Visits: 120
This forum thread answered my question about giving access to usrs, but it didn't tell how to give that access to the users. To do this:

Open the instance in SSMS.
Open the "Security" folder and then the "Logins" folder.
Right-Click on the user name and choose properties. If the user is not listed then you will have to add a "New Login".
Click on the "User Mappings" option.
Check the box next to the msdb database under "Users mapped to this login".
Add the user login name under "User" and add the "Default Schema" (eg: dbo).
Check the box next to the appropriate role under "Database role membership for: msdb".

Click "OK" and the user will have that permission for the Job Activity Monitor.
Post #1373578
Posted Wednesday, October 17, 2012 6:39 AM


Group: General Forum Members
Last Login: Friday, January 29, 2016 12:11 PM
Points: 192, Visits: 929
Use the following to grant VIEW SERVER STATE to a user. With this permission, they can see Activity Monitor. Please research this permission to make sure it does not give other permissions that you do not wish the user to have.

USE master
GRANT VIEW SERVER STATE TO [<domain>\<username>]
Post #1373762
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse