DROP MASKING POLICY ​

Function ​

DROP MASKING POLICY deletes an anonymization policy.

Precautions ​

Only user poladmin, user sysadmin, or the initial user can perform this operation.

Syntax ​

DROP MASKING POLICY [IF EXISTS] policy_name;

Parameter Description ​

policy_name

Specifies the audit policy name, which must be unique.

Value range: a string. It must comply with the naming convention.

Examples ​

-- Delete a masking policy.
openGauss=# DROP MASKING POLICY IF EXISTS maskpol1;

-- Delete a group of masking policies.
openGauss=# DROP MASKING POLICY IF EXISTS maskpol1, maskpol2, maskpol3;

Helpful Links ​

ALTER MASKING POLICY and CREATE MASKING POLICY