PostgreSQL 9.5
PostgreSQL 9.5
  • 请登录查看
字典 我要纠错

ALTER POLICY

ALTER POLICY

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