Maintenance Plans - Restrict Users

[topub]

Hi,

Is it possible to restrict users that use Enterprise Manager from deleting maintenance plans? Could anyone please point me to a good URL that talks about this.


thanks a lot,
_ub

 

[mrdenny]

I'm fairly sure that you have to be sysadmin to drop a maintenance plan. As such you can't revoke sysadmin's rights to do anything.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com