Difference between revisions of "PostgreSQL users"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
* <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; | ||
Revision as of 15:06, 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:
