Difference between revisions of "PostgreSQL Privileges"

From wikieduonline
Jump to navigation Jump to search
 
(12 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
https://www.postgresql.org/docs/current/ddl-priv.html
  
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>[[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>
 
* <code>[[GRANT UPDATE]] ON accounts TO joe;</code>
Line 9: Line 8:
 
== Related ==
 
== Related ==
 
* [[Privileges]]
 
* [[Privileges]]
* [[community.postgresql.postgresql privs]]
+
* 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 ==
 
== See also ==
 +
* {{Role}}
 
* {{GRANT}}
 
* {{GRANT}}
 +
* {{PostgreSQL Privileges}}
  
 
[[Category:SQL]]
 
[[Category:SQL]]

Latest revision as of 15:39, 5 July 2023

Advertising: