SQLAgentReadonly role

Question

SQLAgentReadonly role

Ken Grissom-138180

SSChasing Mays

Points: 603
More actions
June 17, 2007 at 8:11 pm

#372233

Is there a way to grant view only rights to SQL server agent (2005) so that thu the GUI interface someone granted the right(s) could view the job scheudle but not change the job schedule (no adding or deleting), look at the job history but not delete job history, and view job steps but not add or change job steps?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 1

Give the user read only access to msdb database. Also there are few procedures that is oriented with jobs for those procedure check and remove execute permissions that update/modify job properties where as allowing to execute those that has read only properties.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

michaela SSCertifiable Points: 5649 More actions · Answer 2

Make the login user of msdb and grant SQLAgentReader permission.

Ken Grissom-138180 SSChasing Mays Points: 603 More actions · Answer 3

Thanks for the responses.

Both the SQLAgentReaderRole and the SQLAgentUserRole have rights to schedule local jobs. The SQLAgentReaderRole does not have right even to view jobs that are not owned by the person with the role.

Any other ideas?

michaela SSCertifiable Points: 5649 More actions · Answer 4

The SQLAgentReaderRole can view any jobp; can modify job properties only if the job is owned by the person with the role. I use this frequently and it works.