Difference between revisions of "PostgreSQL users"
Jump to navigation
Jump to search
(11 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | + | * <code>[[show users;]]</code> | |
− | + | * <code>select * from [[pg_user]];</code> | |
− | + | * [[\du]] | |
− | * [[show users;]] | ||
− | |||
* <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 ROLE]] | |
− | |||
− | |||
== Related == | == Related == | ||
− | * [[PostgreSQL predefined roles]] | + | * [[PostgreSQL predefined roles]]: <code>[[pg_read_all_data]]</code> |
+ | * [[PostgreSQL Privileges]] | ||
+ | * [[PostgreSQL superuser]] | ||
+ | * <code>[[.pgpass]]</code> | ||
== See also == | == See also == | ||
− | * {{PostgreSQL}} | + | * {{PostgreSQL users}} |
+ | |||
+ | [[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: