Updated on 2022-06-11 GMT+08:00

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

1
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.

1
DROP REDACTION POLICY mask_emp ON emp;