Difference between revisions of "PostgreSQL Privileges"

From wikieduonline
Jump to navigation Jump to search
(Created page with " SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, CREATE, CONNECT, TEMPORARY, EXECUTE, USAGE, SET and ALTER SYSTEM")
 
 
(20 intermediate revisions by 4 users not shown)
Line 1: Line 1:
SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, CREATE, CONNECT, TEMPORARY, EXECUTE, USAGE, SET and ALTER SYSTEM
+
https://www.postgresql.org/docs/current/ddl-priv.html
 +
 
 +
* <code>[[SELECT]], INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, CREATE, CONNECT, TEMPORARY, [[EXECUTE]], USAGE, SET and ALTER SYSTEM</code>
 +
 
 +
* <code>[[GRANT UPDATE]] ON accounts TO joe;</code>
 +
 
 +
 +
== Related ==
 +
* [[Privileges]]
 +
* Ansible: <code>[[community.postgresql.postgresql_privs]]</code>
 +
* <code>[[\list+]]</code>
 +
* <code>[[\du+]]</code>
 +
* [[PostgreSQL users]]
 +
 
 +
== News ==
 +
* Oct 2022 [[PostgreSQL 15]], revokes the [[CREATE]] permission from all users except a database owner from the public (or default) schema <ref>https://www.postgresql.org/docs/15/ddl-schemas.html#DDL-SCHEMAS-PATTERNS</ref>
 +
 
 +
== See also ==
 +
* {{Role}}
 +
* {{GRANT}}
 +
* {{PostgreSQL Privileges}}
 +
 
 +
[[Category:SQL]]

Latest revision as of 15:39, 5 July 2023

Advertising: