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

1

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

1
2
3
4
5

-- 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