December 2, 2009 at 6:51 pm
Good day,
I have developers that I would like to give permissions to update sql agent jobs that he doesn't own. In BOL, it says the SQL Agent Operator role only allows the user to update jobs they own. It then goes on to say that only sysadmins can update jobs owned by other users. Is there a backdoor way to give users this permission? To me it seems like going from sqlagentoperatorrole to sysadmin role is quite drastic. Seems like there should be another sqlagent role to allow this.
Here is why I want to do this:
We have several data warehouse refresh agent jobs in our dev environment. We are trying to set them up as they will be in the production environment. The developer is working with the jobs. The jobs are owned by sa as they are in our production environment. It is very frustrating that we would have to change the owner just for this developer to update them.
I understand why they have implemented this for in a production environment. I don't want just anyone changing my jobs but it seems like they would be a way to have an exception to the rule.
Anyone have any suggestions on how I might accomplish this or is it just not possible?
Or have you done something creative to get around this limitation? I don't want to give the developer sysadmin privileges to just modify these jobs.
Thanks,
Aileen
December 3, 2009 at 8:46 am
Sorry. Looks like the only way you can modify jobs is to be sysadmin or own the job.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 3, 2009 at 5:39 pm
Thanks! i thought there's another way, just hope they include this feature in the next sql edition they develop 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply