Name
ALTER POLICY -- change the definition of a row level security policySynopsis
ALTER POLICY name ON table_name RENAME TO new_name ALTER POLICY name ON table_name [ TO { role_name | PUBLIC | CURRENT_USER | SESSION_USER } [, ...] ] [ USING ( using_expression ) ] [ WITH CHECK ( check_expression ) ]
Description
ALTER POLICY
changes the definition of an existing row-level security policy.
To use ALTER POLICY
, you must own the table that the policy applies to.
In the second form of ALTER POLICY
, the role list, using_expression
, and check_expression
are replaced independently if specified. When one of those clauses is omitted, the corresponding part of the policy is unchanged.
Parameters
name
-
The name of an existing policy to alter.
table_name
-
The name (optionally schema-qualified) of the table that the policy is on.
new_name
-
The new name for the policy.
role_name
-
The role(s) to which the policy applies. Multiple roles can be specified at one time. To apply the policy to all roles, use
PUBLIC
. using_expression
-
The
USING
expression for the policy. See CREATE POLICY for details. check_expression
-
The
WITH CHECK
expression for the policy. See CREATE POLICY for details.
Compatibility
ALTER POLICY
is a PostgreSQL extension.
Please login to continue.