Difference between revisions of "PostgreSQL Privileges"
Jump to navigation
Jump to search
| Line 4: | Line 4: | ||
[[SELECT]], INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, CREATE, CONNECT, TEMPORARY, EXECUTE, USAGE, SET and ALTER SYSTEM | [[SELECT]], INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, CREATE, CONNECT, TEMPORARY, EXECUTE, USAGE, SET and ALTER SYSTEM | ||
| + | |||
| + | [[GRANT UPDATE]] ON accounts TO joe; | ||
| + | |||
| + | |||
[[Privileges]] | [[Privileges]] | ||
Revision as of 18:54, 14 December 2022
https://www.postgresql.org/docs/current/ddl-priv.html
SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, CREATE, CONNECT, TEMPORARY, EXECUTE, USAGE, SET and ALTER SYSTEM
GRANT UPDATE ON accounts TO joe;
Privileges
GRANT, \ddp, GRANT USAGE, GRANT ALL PRIVILEGES, GRANT SELECT, View GRANTs on Redshift, has_table_privilege, has_schema_privilege, HAS_DATABASE_PRIVILEGE, SCHEMA, Privileges, GRANT EXECUTE
Advertising:
