DROP SENSITIVE RULE

Purpose

This statement is used to drop a sensitive data protection rule.

Privilege requirements

To execute the DROP SENSITIVE RULE statement, the current user must have the DROP SENSITIVE RULE privilege. For more information about the privileges of OceanBase Database, see Privilege classification in MySQL mode.

Syntax

DROP SENSITIVE RULE <rule_name>;

Parameters

The following table describes the parameters.

| Parameter | Data type | Default value | Description | |--|--|--|--| | rule_name | String | | The name of the sensitive data protection rule, which must be unique within the tenant. |

Limitations:

• Only one rule can be dropped at a time.

Examples

Here is an example:

-- Drop the sensitive data protection rule named r1.
DROP SENSITIVE RULE r1;

• CREATE SENSITIVE RULE
• ALTER SENSITIVE RULE