table of contents
ALTER POLICY(7) | PostgreSQL 9.6.6 Documentation | ALTER POLICY(7) |
NAME¶
ALTER_POLICY - change the definition of a row level security 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
table_name
new_name
role_name
using_expression
check_expression
COMPATIBILITY¶
ALTER POLICY is a PostgreSQL extension.
SEE ALSO¶
CREATE POLICY (CREATE_POLICY(7)), DROP POLICY (DROP_POLICY(7))
2017 | PostgreSQL 9.6.6 |