Working with Policy-Based Management
You must be a member of the PolicyAdministratorRole role in the msdb database to configure Policy-Based Management settings. This role has complete control of all policies and can create policies and conditions, edit policies and conditions, and enable or disable policies.
When working with policies, keep the following in mind:
A system administrator or database owner can subscribe a database to a policy or policy group.
Ad hoc policy execution occurs in the security context of the user.
Members of the PolicyAdministratorRole role can create policies that they do not have permission to execute on an ad hoc basis.
Members of the PolicyAdministratorRole role can enable or disable policies.
Policies that are in the ...
Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
