Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-2.x)/ SQL Reference/ SQL Syntax/ DROP MASKING POLICY
Updated on 2025-02-27 GMT+08:00
View PDF
Share

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

Parent topic: SQL Syntax