ALTER ROW POLICY

Changes row policy.

Syntax:

  1. ALTER [ROW] POLICY [IF EXISTS] name1 [ON CLUSTER cluster_name1] ON [database1.]table1 [RENAME TO new_name1]
  2.         [, name2 [ON CLUSTER cluster_name2] ON [database2.]table2 [RENAME TO new_name2] ...]
  3.     [AS {PERMISSIVE | RESTRICTIVE}]
  4.     [FOR SELECT]
  5.     [USING {condition | NONE}][,...]
  6.     [TO {role [,...] | ALL | ALL EXCEPT role [,...]}]