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?
Any ideas where to start?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Also had to give permission to sp_enum_sqlagent_subsystem s (which is not assigned by default to public). Thanks for the start!!