Back to Clickhouse

ALTER MASKING POLICY

docs/en/sql-reference/statements/alter/masking-policy.md

26.4.1.1-new484 B
Original Source

import CloudOnlyBadge from '@theme/badges/CloudOnlyBadge';

<CloudOnlyBadge/>

ALTER MASKING POLICY

Modifies an existing masking policy.

Syntax:

sql
ALTER MASKING POLICY [IF EXISTS] policy_name ON [database.]table
    [UPDATE column1 = expression1 [, column2 = expression2 ...]]
    [WHERE condition]
    [TO {role1 [, role2 ...] | ALL | ALL EXCEPT role1 [, role2 ...]}]
    [PRIORITY priority_number]

All clauses are optional. Only the specified clauses will be updated.