Solved

Permissions to add SQL jobs

Posted on 2000-03-07
3
211 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.

733 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