vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/dev/dws_06_0199.html
Lu, Huayi e6fa411af0 DWS DEV 830.201 version 
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2024-05-16 07:24:04 +00:00

4.2 KiB
Raw Permalink Blame History

DROP REDACTION POLICY

Function

DROP REDACTION POLICY deletes a data masking 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 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

Parent topic: DDL Syntax