Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
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: Thursday, October 30, 2014 10:11 PM
Points: 6, Visits: 397
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?
Thanks
Post #902881
Posted Thursday, April 15, 2010 2:09 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

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
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, November 9, 2014 1:12 PM
Points: 7, Visits: 90
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
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, December 12, 2014 11:59 AM
Points: 191, Visits: 904
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
GO
GRANT VIEW SERVER STATE TO [<domain>\<username>]
Post #1373762
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse