DROP REDACTION POLICY¶
Function¶
DROP REDACTION POLICY deletes a data redaction policy applied to a specified table.
Precautions¶
Only the table owner has the permission to delete a data redaction policy.
Syntax¶
DROP REDACTION POLICY [ IF EXISTS ] policy_name ON table_name;
Parameter Description¶
IF EXISTS
Sends a notice instead of throwing an error if the redaction policy to be deleted does not exist.
policy_name
Specifies the name of a redaction policy.
table_name
Specifies the name of the table to which the redaction policy is applied.
Examples¶
Delete a data masking policy.
DROP REDACTION POLICY mask_emp ON emp;