PostgreSQL Privileges
Jump to navigation
Jump to search
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: