Difference between revisions of "PostgreSQL users"
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
* [[PostgreSQL predefined roles]]: <code>[[pg_read_all_data]]</code> | * [[PostgreSQL predefined roles]]: <code>[[pg_read_all_data]]</code> | ||
* [[PostgreSQL Privileges]] | * [[PostgreSQL Privileges]] | ||
| + | * [[PostgreSQL superuser]] | ||
== See also == | == See also == | ||
Revision as of 15:16, 20 September 2024
show users;select * from pg_user;- \du
create role USERNAME with login password 'PASSWORD';
GRANT pg_read_all_data TO xxx; GRANT ROLE
Related
See also
Advertising:
