Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aliyesami
Starting Member
30 Posts |
 Posted - 2008-10-29 : 16:10:42
|
| what minimum priviliges I need to grant to a person to be able to give him access to jobs only ? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-29 : 16:22:33
|
| You need to give permission in TargetServer role in MSDB database |
 |
|
|
aliyesami
Starting Member
30 Posts |
Posted - 2008-10-29 : 21:49:46
|
| thanks it worked but now i can only see the jobs and not modify them.. i get 'execution permission denied' . I want to grant full access to jobs and dts packages to a user and not anyother admin rights how can i do it ? |
|
|
|
aliyesami
Starting Member
30 Posts |
Posted - 2008-10-29 : 22:15:29
|
| I also have one more question , one of our dba's disabled the sqlagent in the database and we can't start it anymore ..how can I enable sqlagent again ? |
|
|
|
|
|
|
granting access to jobs