• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1270
  • Last Modified:

SQL Server 2000 Job permissions

Hello everyone.

What I am trying to do is to create an account that will be able to see, modify, delete and run jobs without the account being system admin. Part of the issue is that I need some jobs to be owned by a sysadmin to run DTS packages, but that can be run by a non system admin. Unless I am forced to do so, I don't want to setup a proxy account for SQLserver agent.

I have looked at this for a while, and it looks like in the MSDB database there is a role called TarverServersRole that permits you to see all the jobs. The problem is that it has been denied a series of permissions, among them to run and modify jobs. I have tried to create a new msdb user role, with the same permissions that we given to TargetServersRole with none of the restrictions, but for some reason in enterprise manager I can't see any jobs. In query analyzer I can't run them using sp_start_job, I get an error message that the job does not exist.

I guess I could modify TargetServersRole, but its a role defined by default with msdb, and who knows what I will break if I modify all those permissions in it.

So my questions are :
- Why doesn't the new role I create with the permissions mimicked from TargetServersRole work? I can't see a difference between the 2.
- What permissions (master and msdb permissions) do I need to set for a user to be able to see/modify/delete/run jobs without being system admin?

Best wishes
André
0
acarrier
Asked:
acarrier
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
acarrier,
>  What permissions (master and msdb permissions) do I need to set for
> a user to be able to see/modify/delete/run jobs without being system admin?
only member of sysadmin can run the jobs
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now