| Author |
Topic |
|
YogeshDesai
Posting Yak Master
136 Posts |
 Posted - 2008-04-09 : 07:53:41
|
| Hi Guys,Need help to give the permissions to view jobs only.I have created a user, which has read_only rights on select database.As addition I want to give him the rights to only view the jobs in EMIs it possible ? if yes which rights i have to give him.Awaiting for repliesSQL IN Minds |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 09:36:24
|
| You can't do that in SQL server 2000. Maybe they can check jobs in sysjobshistory. |
 |
|
|
YogeshDesai
Posting Yak Master
136 Posts |
Posted - 2008-04-09 : 10:01:44
|
| Hi Sodeep I was thinking same just want to confirm... thanks for replySQL IN Minds |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 10:15:47
|
| In 2005 you can by using different job agent roles. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-09 : 22:18:07
|
| Yes in sql2k, add them to msdb..remoteserverrole db role. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 23:31:43
|
| Tried but didn't work. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 23:38:12
|
| I don't see Remote server role in SQL 2000 |
|
|
|
YogeshDesai
Posting Yak Master
136 Posts |
Posted - 2008-04-10 : 08:37:23
|
| I could not find any role like remoteserverSQL IN Minds |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-10 : 22:30:42
|
| Should be targetserverrole, my bad. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-10 : 22:41:10
|
| rmaio, what permission would you give in that role? Just curious. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-10 : 23:35:46
|
| That's buildin role. |
|
|
|
YogeshDesai
Posting Yak Master
136 Posts |
Posted - 2008-04-11 : 04:30:56
|
| There is no such role like targetserverrole where I can find this ?SQL IN Minds |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-11 : 11:28:26
|
| Yes , Check in MSDB You have to give TargetServerRole permission to execute sp_help_job, sp_help_jobstep, sp_help_jobschedule, and sp_help_jobhistory |
|
|
|
|
Permissions to view Jobs in EM