Difference between revisions of "PostgreSQL Privileges"
Jump to navigation
Jump to search
↑ https://www.postgresql.org/docs/15/ddl-schemas.html#DDL-SCHEMAS-PATTERNS
| Line 11: | Line 11: | ||
* <code>[[\list+]]</code> | * <code>[[\list+]]</code> | ||
* <code>[[\du+]]</code> | * <code>[[\du+]]</code> | ||
| + | |||
| + | |||
| + | == 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 == | ||
Revision as of 12:51, 16 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;
Related
News
- Oct 2022 PostgreSQL 15, revokes the CREATE permission from all users except a database owner from the public (or default) schema [1]
See also
- 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:
