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