Difference between revisions of "PostgreSQL users"
Jump to navigation
Jump to search
Line 9: | Line 9: | ||
== Related == | == Related == | ||
− | * [[PostgreSQL predefined roles]] | + | * [[PostgreSQL predefined roles]]: <code>[[pg_read_all_data]]</code> |
* [[PostgreSQL Privileges]] | * [[PostgreSQL Privileges]] | ||
Revision as of 15:07, 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: