DROP MASKING POLICY

Description

Drops a masking policy.

Precautions

Only users with the POLADMIN or SYSADMIN permission, or the initial user can perform this operation.

Syntax

1

DROP MASKING POLICY [ IF EXISTS ] policy_name;

Parameters

• policy_name

  Specifies the audit policy name, which must be unique.

  Value range: a string that complies with the Identifier Naming Conventions. The value is an existing policy name.

Examples

1
2
3
4
5

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

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

Helpful Links

ALTER MASKING POLICY and CREATE MASKING POLICY