syspolicy_policy_category_subscriptions (Transact-SQL)syspolicy_policy_category_subscriptions (Transact-SQL)

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions)

SQL ServerSQL Server 实例中每个基于策略的管理订阅在表中各占一行。Displays one row for each Policy-Based Management subscription in the instance of SQL ServerSQL Server. 每一行说明了一个目标和策略类别对。Each row describes a target and policy category pair. 下表介绍了 syspolicy_policy_group_subscriptions 视图中的列。The following table describes the columns in the syspolicy_policy_group_subscriptions view.

列名称Column name 数据类型Data type 说明Description
policy_category_subscription_idpolicy_category_subscription_id intint 此记录的标识符。Identifier of this record.
target_typetarget_type sysnamesysname 作为此订阅目标的数据库对象的类型。Type of database object that is the target of this subscription.
target_objecttarget_object sysnamesysname 目标对象的名称。Name of the target object.
policy_category_idpolicy_category_id intint 应用于目标的策略类别的 ID。ID of the policy category that is applied to the target.

备注Remarks

此视图显示订阅了策略类别的目标。This view shows the targets that are subscribed to policy categories.

权限Permissions

要求具有 msdb 数据库中 PolicyAdministratorRole 角色的成员身份。Requires membership in the PolicyAdministratorRole role in the msdb database.

另请参阅See Also

使用基于策略的管理来管理服务器 Administer Servers by Using Policy-Based Management
基于策略的管理视图 (Transact-SQL)Policy-Based Management Views (Transact-SQL)