Difference between revisions of "PostgreSQL users"

From wikieduonline
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]]
  
* [[show users]]
+
== Related ==
 
+
* [[PostgreSQL predefined roles]]: <code>[[pg_read_all_data]]</code>
 
+
* [[PostgreSQL Privileges]]
* <code>[[PostgreSQL: CREATE ROLE|create role]] USERNAME with login password 'PASSWORD';</code>
+
* [[PostgreSQL superuser]]
 +
* <code>[[.pgpass]]</code>
  
* [[PostgreSQL predefined roles]]
+
== See also ==
 +
* {{PostgreSQL users}}
  
* {{PostgreSQL}}
+
[[Category:PostgreSQL]]

Latest revision as of 15:51, 20 September 2024

Advertising: