Difference between revisions of "PostgreSQL users"
Jump to navigation
Jump to search
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
* <code>[[show users;]]</code> | * <code>[[show users;]]</code> | ||
* <code>select * from [[pg_user]];</code> | * <code>select * from [[pg_user]];</code> | ||
* [[\du]] | * [[\du]] | ||
| − | |||
* <code>[[PostgreSQL: CREATE ROLE|create role]] USERNAME with login password 'PASSWORD';</code> | * <code>[[PostgreSQL: CREATE ROLE|create role]] USERNAME with login password 'PASSWORD';</code> | ||
| − | |||
[[GRANT]] [[pg_read_all_data]] TO xxx; | [[GRANT]] [[pg_read_all_data]] TO xxx; | ||
[[GRANT ROLE]] | [[GRANT ROLE]] | ||
| − | |||
== 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 == | ||
| − | * {{PostgreSQL}} | + | * {{PostgreSQL users}} |
[[Category:PostgreSQL]] | [[Category:PostgreSQL]] | ||
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:
