Difference between revisions of "PostgreSQL users"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
* <code>[[show users;]]</code> | * <code>[[show users;]]</code> | ||
* <code>select * from [[pg_user]];</code> | * <code>select * from [[pg_user]];</code> | ||
| Line 12: | Line 9: | ||
[[GRANT]] [[pg_read_all_data]] TO xxx; | [[GRANT]] [[pg_read_all_data]] TO xxx; | ||
[[GRANT ROLE]] | [[GRANT ROLE]] | ||
| − | |||
== Related == | == Related == | ||
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:
