-
Notifications
You must be signed in to change notification settings - Fork 9
Closed
Description
- CREATE POLICY
-
CREATE POLICY name ON table_name -
AS { PERMISSIVE | RESTRICTIVE } -
FOR { ALL | SELECT | INSERT | UPDATE | DELETE } -
TO { role_name | PUBLIC | CURRENT_ROLE | CURRENT_USER | SESSION_USER } [, ...] -
USING ( expr ) -
WITH CHECK ( expr )
-
- ALTER POLICY
-
ALTER POLICY name ON table_name -
RENAME TO new_name -
TO { role_name | PUBLIC | CURRENT_ROLE | CURRENT_USER | SESSION_USER } [, ...] -
USING ( expr ) -
WITH CHECK ( expr )
-
- DROP POLICY
-
DROP POLICY name ON table_name -
IF EXISTS -
CASCADE | RESTRICT
-
Metadata
Metadata
Assignees
Labels
No labels