<classification_profile_name>!SET_CLASSIFY_VIEWS¶

指定是否在敏感数据分类期间对视图进行分类。

语法

<classification_profile_name>!SET_CLASSIFY_VIEWS( <boolean_value> )

实参

boolean_value

指定是否为 CLASSIFICATION_PROFILE 类的实例启用视图分类。

TRUE 启用视图分类。

FALSE 禁用视图分类。只有表会按敏感数据分类进行分类。

默认：FALSE

访问控制要求

A role used to execute this operation must have the following privileges at a minimum:

Instance role	Object	Notes
`classification_profile`!PRIVACY_USER	The classification profile instance.	The account role that calls this method must be granted this instance role on the classification profile. The role used to create the instance is automatically granted this instance role.

Operating on an object in a schema requires at least one privilege on the parent database and at least one privilege on the parent schema.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

使用说明

Calling this method does not return the object. Because of this, you can’t use method chaining to call another method on the return value of this method. Instead, call each method in a separate SQL statement.

示例

配置分类配置文件，以便将视图与表一起分类：

CALL my_classification_profile!SET_CLASSIFY_VIEWS(true);

为分类配置文件禁用视图分类：

CALL my_classification_profile!SET_CLASSIFY_VIEWS(false);