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

Permissions to edit SQL 2008 R2 jobs Expand / Collapse
Posted Thursday, January 5, 2012 12:12 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, November 7, 2014 8:35 AM
Points: 662, Visits: 959
Need best way to grant permission to allow one of my Power users (a pseudo/DBA) to edit a SQL Server 2008 R2 job. This user does not retain sysadmin on the box nor should they.

This user also does not OWN the job (nor should they).. these 3 roles (SQLAgentUserRole, SQLAgentReaderRole, SQLAgentOperatorRole) are limited in that user can edit job ONLY if they own the job.

I tried creating a new credential (referencing an acct w/ sysadmin permissions), creating a new Proxy acct referncing the new credential and adding the NT Login as a Principal -- did not work. My power user still cannot edit the SQL job.

I think I'm missing something simple here..

Post #1231053
Posted Thursday, January 5, 2012 12:55 PM



Group: General Forum Members
Last Login: Tuesday, October 28, 2014 4:48 PM
Points: 199, Visits: 1,139
I think they need to own the job in addition to being a member of the applicable msdb role. I don't think there is any way around having them own it.
Post #1231085
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse