Link to home
Start Free TrialLog in
Avatar of sdunkin
sdunkin

asked on

Permissions to add SQL jobs

We have a situation where we need to allow a developer to add jobs to SQLServer, but are unable to find the right combination of permissions to do so. We do not want to give them permissions to the server for some of the canned "Server Roles". This login may need access to add DTS packages as well.
Any ideas where to start?
Avatar of danchr
danchr

You might start by looking at the permissions of the user in the msdb database.  Specificaly check sp_addtask.  You might also need to disect that proceedure to figure out what tables the user needs what permisions on in the target database.
ASKER CERTIFIED SOLUTION
Avatar of crsankar
crsankar
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sdunkin

ASKER

Also had to give permission to sp_enum_sqlagent_subsystems (which is not assigned by default to public). Thanks for the start!!