Difference between revisions of "PostgreSQL users"
Jump to navigation
Jump to search
| (2 intermediate revisions by the same user not shown) | |||
| Line 9: | Line 9: | ||
== Related == | == Related == | ||
| − | * [[PostgreSQL predefined roles]] | + | * [[PostgreSQL predefined roles]]: <code>[[pg_read_all_data]]</code> |
* [[PostgreSQL Privileges]] | * [[PostgreSQL Privileges]] | ||
| + | * [[PostgreSQL superuser]] | ||
| + | * <code>[[.pgpass]]</code> | ||
== See also == | == See also == | ||
Latest revision as of 15:51, 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[edit]
See also[edit]
Advertising:
