Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs
49.6kGet Started

ALTER MASKING POLICY

View as MarkdownEdit this pageReport an issueSet up docs MCP
ClickHouse Cloud only

Modifies an existing masking policy.

Syntax:

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.

Part of: ALTER

Related: CREATE MASKING POLICY, ALTER, SHOW

Navigation