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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2008-12-05 : 16:56:31
|
| Hi allHow can I grant access to user in sql 2k5 to the following:1. SHOW QUERY PLAN2. ACTIVITY MONITOR3. TO SEE RUNNING JOBS Thanks in advance |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-05 : 17:03:27
|
quote:
Originally posted by Peter99
Hi allHow can I grant access to user in sql 2k5 to the following:1. SHOW QUERY PLANGrant Showplan....(see booksonline)2. ACTIVITY MONITORGrant View Server state to user3. TO SEE RUNNING JOBSSee new MSDB...role.. for SQL Agent to see jobs. Thanks in advance
|
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2008-12-07 : 12:44:27
|
| Thanks Sodeep for your reply. Can u send links for these. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-07 : 12:49:42
|
| Please see booksonline. It has all details. |
|
|
|
|
|
|
Granting Access