Post reply

Modify SQL jobs permission

  • September 29, 2016 at 11:05 am

    #313957

    I would like to grant some of developers to edit jobs that are not owned(created) by them.

    For example I sometimes create the job, but even I have granted them MSDB SQL operator role, they can only view the job, but cannot modify the job.

    It seems they can only modify jobs owned by themselves, but for modifying all jobs they will need sysadmin privilege.

    Is there any other options to give them permissions to modify all the jobs other than sysadmin?

    Thanks

    Xiaowei

  • September 29, 2016 at 12:00 pm

    #1904007

    Researched this a little and this: [http://borishristov.com/blog/modifying-not-owned-sql-agent-jobs-without-being-a-sysadmin/] looks like the only available option.

Viewing 2 posts - 1 through 1 (of 1 total)

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