Solved

Permissions to add SQL jobs

Posted on 2000-03-07
3
209 Views
Last Modified: 2010-08-05
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?
0
Comment
Question by:sdunkin
3 Comments
 
LVL 1

Expert Comment

by:danchr
ID: 2593849
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.
0
 
LVL 6

Accepted Solution

by:
crsankar earned 100 total points
ID: 2594486
As far as creating jobs using sp_add_job are concerned the execute permission is available for public, which means any login can create a job.
0
 

Author Comment

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

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question