ALTER POLICY
Synopsis
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.