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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-11-24 : 00:21:28
|
| Dear All,i've created a middle level user for users. but while connecting to the server, it is not displaying the sql server agent. they need to work on jobs. so please let me know how can i add permissions for the users to work with sql server agent....ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-11-24 : 04:26:09
|
| The roles to give permissions to jobs are:SQLAgentUserRole,SQLAgentReaderRole,SQLAgentOperatorRole.Assign as required to user. |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-11-24 : 04:48:40
|
| can you please tell me where can i find these....ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-11-24 : 10:46:47
|
| database - msdb/ security / database roles / ORAdd user to msdb and add roles throughmsdb / Security / Users - and add roles. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-24 : 13:15:07
|
| What they need to do on jobs? |
|
|
|
|
|
|
permissions to sql server agent