DROP MASKING POLICY

Introduced or updated: v1.2.45

ENTERPRISE EDITION FEATURE

MASKING POLICY requires Enterprise Edition. To inquire about upgrading, please contact Databend Support.

Deletes an existing masking policy from Databend. When you drop a masking policy, it is removed from Databend, and its associated masking rules are no longer in effect. Please note that, before dropping a masking policy, ensure that this policy is not associated with any columns.

Syntax

DROP MASKING POLICY [IF EXISTS] <policy_name>

Examples

CREATE MASKING POLICY email_mask AS (val STRING) RETURN STRING -> CASE WHEN current_role() IN ('MANAGERS') THEN VAL ELSE '*********'END comment = 'hide_email';

DROP MASKING POLICY email_mask;