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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.