DROP REDACTION POLICY

Function

DROP REDACTION POLICY deletes a data masking policy applied to a specified table.

Precautions

Only the table owner and users granted the gs_redaction_policy preset role have the permission to delete data masking policies.

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 the masking policy to be deleted.

• table_name

  Specifies the name of the table with the masking policy to be deleted.

Examples

Delete the masking policy mask_emp from table emp:

1

DROP REDACTION POLICY mask_emp ON emp;

Helpful Links

ALTER REDACTION POLICY, CREATE REDACTION POLICY