syspolicy_policy_category_subscriptions (Transact-SQL)
Applies to: SQL Server
Displays one row for each Policy-Based Management subscription in the instance of SQL Server. Each row describes a target and policy category pair. The following table describes the columns in the syspolicy_policy_group_subscriptions view.
Column name | Data type | Description |
---|---|---|
policy_category_subscription_id | int | Identifier of this record. |
target_type | sysname | Type of database object that is the target of this subscription. |
target_object | sysname | Name of the target object. |
policy_category_id | int | ID of the policy category that is applied to the target. |
Remarks
This view shows the targets that are subscribed to policy categories.
Permissions
Requires membership in the PolicyAdministratorRole role in the msdb database.
See Also
Administer Servers by Using Policy-Based Management
Policy-Based Management Views (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for