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 |
|
asr
Starting Member
1 Post |
 Posted - 2008-07-24 : 09:17:17
|
| Can permission be set for a user(without sysadmin rights) to run an SQL Job? Can you please let me know how this can be done?the user needs to run the SQL job but DBA cannot give the user sys admin rights. So I want to know if there is any way to give access to run this job? Can this be done via Enterprise manager/command line? Sruti |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-24 : 09:56:30
|
| Yes DBA has to set proxy account for you |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-24 : 13:10:56
|
| Who is job owner? Non-sysadmin user can only run owned jobs. And it's nothing to do with proxy account. |
|
|
|
|
|
|
SQL Job Permission to a single user