ALTER VIEW

Change an existing view.

Syntax

-- Set a Column-Masking Policy
ALTER VIEW [ IF EXISTS ] <view_name>
  MODIFY COLUMN <column_name>
  SET MASKING POLICY <function_name> ( <column_name> [, ... ] )

-- Unset a Column-Masking Policy
ALTER VIEW [ IF EXISTS ] <view_name>
  MODIFY COLUMN <column_name>
  UNSET MASKING POLICY <function_name>

-- Add or Remove a Row-Access Policy
ALTER VIEW [ IF EXISTS ] <view_name>
  { ADD | DROP } ROW ACCESS POLICY <function_name> ( <column_name> [, ... ] )

Parameters

{{< sql-section file="data/sql/views.json" data="alteringAView" >}}

{{< sql-section file="data/sql/row-column-policies.json" data="maskingExistingParameters" >}}

Examples

Set a column-masking policy on multiple columns

ALTER VIEW customers
    MODIFY COLUMN ssn_col
    SET MASKING POLICY protect_ssn (ssn_col, region)

Unset a column-masking policy

ALTER VIEW customers
    MODIFY COLUMN ssn_col
    UNSET MASKING POLICY protect_ssn

Add a row-access policy to a view

ALTER VIEW customers
  ADD ROW ACCESS POLICY state_policy ( state_col )

Remove row-access policy from a view

ALTER VIEW customers
  DROP ROW ACCESS POLICY protect_ssn (ssn_col)