Purpose
This statement is used to drop sensitive data protection rules.
Note
For OceanBase Database V4.3.5, this statement is supported starting from V4.3.5 BP3.
Privilege requirements
To execute the DROP SENSITIVE RULE statement, the current user must have the DROP SENSITIVE RULE privilege. For more information about OceanBase Database privileges, see Privilege types 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 | Character | | The name of the sensitive data protection rule, which is unique in the tenant. |
Limitations:
- You can drop only one rule at a time.
Examples
Here is an example:
-- Drop the sensitive data protection rule named r1.
DROP SENSITIVE RULE r1;