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
Author
Message
Posted Thursday, January 5, 2012 12:12 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 8:22 AM
Points: 656, Visits: 939
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..


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


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, July 25, 2014 10:31 AM
Points: 198, Visits: 1,127
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.

http://msdn.microsoft.com/en-us/library/ms188283.aspx
Post #1231085
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse