Removing a data redaction policy v18

The DROP_REDACTION_POLICY function removes a data redaction policy from a table.

Synopsis

DATA_REDACTION.DROP_REDACTION_POLICY('policy_name', 
                                     'table_name', 
                                     'schema_name')

Description

DROP_REDACTION_POLICY removes the specified data redaction policy from the table.

To use DROP_REDACTION_POLICY, you must own the table that the redaction policy applies to.

Parameters

• policy_name — Name of the data redaction policy to remove.

• table_name — Name of the table the data redaction policy applies to.

• schema_name — Schema name in which the table resides.

See also

CREATE REDACTION POLICY, ENABLE/DISABLE REDACTION POLICY