Wednesday, March 7, 2012

Maintenance Plans cannot be seen by other DBA's

I am not sure if this is the right area or not but here goes. I have a W2K3
SP4- SQL 2005 SP1 running in a clustered environm,ent. I received a call tha
t
the other DBA's cannot see any maintneace plans when they expand the
Management Folder. They do not have any server roles but are the dbo owners
of the 12 databases on the system. I am using Windows Authentication as ther
e
are no loegacy apps which require Mixed Mode Authentication.
I can see the plans as I have server role rights. I have been searching but
cannot find anything relatd as to the security required for them to see
Mainteneace Plans created for their databases.
What group would they have to be in to see the plans? They cannot be part of
any server roles.
Any info would be appreciated.
carlFrom Books Online.
http://msdn2.microsoft.com/en-us/library/ms187658.aspx
You must be a member of the sysadmin role to create and manage maintenance
plans, and to view them in Object Explorer. The SQL Server Agent node in
Object Explorer is only displayed for members of the sysadmin fixed server
role, SQLAgentReaderRole, SQLAgentUserRole, or SQLAgentOperatorRole fixed
database roles.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"carl" <carl@.discussions.microsoft.com> wrote in message
news:FF2A2C7E-B34A-40C4-B0F8-44239ADFE4E7@.microsoft.com...
>I am not sure if this is the right area or not but here goes. I have a W2K3
> SP4- SQL 2005 SP1 running in a clustered environm,ent. I received a call
> that
> the other DBA's cannot see any maintneace plans when they expand the
> Management Folder. They do not have any server roles but are the dbo
> owners
> of the 12 databases on the system. I am using Windows Authentication as
> there
> are no loegacy apps which require Mixed Mode Authentication.
> I can see the plans as I have server role rights. I have been searching
> but
> cannot find anything relatd as to the security required for them to see
> Mainteneace Plans created for their databases.
> What group would they have to be in to see the plans? They cannot be part
> of
> any server roles.
> Any info would be appreciated.
> carl

No comments:

Post a Comment