Difference between revisions of "PostgreSQL Privileges"
Jump to navigation
Jump to search
↑ https://www.postgresql.org/docs/15/ddl-schemas.html#DDL-SCHEMAS-PATTERNS
(12 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
+ | 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. | + | * 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
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;
Related[edit]
News[edit]
- Oct 2022 PostgreSQL 15, revokes the CREATE permission from all users except a database owner from the public (or default) schema [1]
See also[edit]
- PostgreSQL: Database roles,
CREATE USER
,CREATE ROLE
,\du, \du+
,create user, Alter user
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
- PostgreSQL Privileges, GRANT,
\list+, \du+
Advertising: