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
Parameter |
Description |
Value Range |
---|---|---|
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. |
An existing name of the masking policy. |
table_name |
Specifies the name of the table with the masking policy to be deleted. |
An existing name of the table to which the data masking policy is applied. |
Examples
Delete the masking policy mask_emp from table emp.
1
|
DROP REDACTION POLICY mask_emp ON emp; |
Helpful Links
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.