October 30, 2007 at 7:46 am
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
October 30, 2007 at 8:26 am
You can only see Maintainance Plans if you have sysadmin, if you create a test user and keep assigning it different Server Roles and keep re-connecting you can see what each role gives the user access to, you can only create and manage Maintainence Plans with sysadmin.
November 1, 2007 at 11:17 pm
He has to have permissions in the msdb database to view the jobs and the MPs.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
November 2, 2007 at 2:41 am
Even if you have owner rights on msdb you still can't view any maintainence plans or jobs, you need to have sysadmin.
November 2, 2007 at 3:40 am
You need to have sys_admin roles to perform any activity.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy