Purpose
This statement is used to delete a sensitive data protection rule.
Privilege requirements
To execute the DROP SENSITIVE RULE statement, the current user must have the CREATE SENSITIVE RULE privilege. For more information about OceanBase Database privileges, see Privilege classification in MySQL-compatible mode.
Syntax
DROP SENSITIVE RULE <rule_name>;
Parameters
The following table describes the parameters.
| Parameter | Data type | Default value | Description | |--|--|--|--| | rule_name | VARCHAR | | The name of the sensitive data protection rule. This value must be unique within the tenant. |
The following table describes the parameters.
- The rule takes effect immediately after it is deleted.
Limitations:
- Only one rule can be deleted at a time.
Examples
Here is an example:
-- Delete the sensitive data protection rule named r1.
DROP SENSITIVE RULE r1;