Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Displays one row for each Policy-Based Management policy category in the instance of SQL Server. Policy categories help you organize policies when you have many policies. The following table describes the columns in the syspolicy_policy_groups view.
Column name |
Data type |
Description |
|---|---|---|
policy_category_id |
int |
Identifier of the policy category. |
name |
sysname |
Name of the policy category. |
mandate_database_subscriptions |
bit |
Indicates whether the policy category applies to all databases in an instance without an explicit subscription (1) or the policy category must be applied to a database by using an explicit subscription (0). |
Remarks
Displays a list of Policy-Based Management policy groups.
Permissions
Requires membership in the PolicyAdministratorRole role in the msdb database.
See Also
Reference
Policy-Based Management Views (Transact-SQL)