Saturday, February 25, 2012

Maintenance Plans - Restrict users from deleting or editing

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,1) Try placing strict security on the msdb tables related to jobs/plans?
2) Not sure if you can do this but possibly triggers on same tables to check
login and rollback if appropriate.
TheSQLGuru
President
Indicium Resources, Inc.
"Uday" <Uday@.discussions.microsoft.com> wrote in message
news:60A6EF35-0306-428E-993B-04A76B9484B8@.microsoft.com...
> 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,
>

No comments:

Post a Comment