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 an anonymization policy.
openGauss=# DROP MASKING POLICY IF EXISTS maskpol1;

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

Helpful Links

5.1.13.14.14-ALTER MASKING POLICY and 5.13.14.59-CREATE MASKING POLICY