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 |
|
scelamko
Constraint Violating Yak Guru
309 Posts |
 Posted - 2007-10-30 : 09:49:38
|
| Guys,What are roles and access rights I need to assign my backup operator so that he can see Maintainence plans under Management node of SQL Server Management Studio. I do not want to assign any admin related privileges.Thanks |
|
|
scelamko
Constraint Violating Yak Guru
309 Posts |
Posted - 2007-10-30 : 09:51:00
|
| I am looking for read only access to maintainence plans, is this possible? |
 |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-10-30 : 10:29:31
|
I don't believe it's possible, in the BOL it states:"To create or manage maintenance plans, you must be a member of the sysadmin fixed server role. Note that Object Explorer only displays maintenance plans if the user is a member of the sysadmin fixed server role."
Future guru in the making. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-30 : 22:58:33
|
| You can still let them view maintenance plan jobs. |
|
|
|
|
|
|
Maintainence Plan access rights