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