Difference between revisions of "PostgreSQL: Database roles"

From wikieduonline
Jump to navigation Jump to search
 
(31 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
* https://www.postgresql.org/docs/current/database-roles.html
  
 
+
Create role:
 
* <code>[[create role]]</code>
 
* <code>[[create role]]</code>
 +
* <code>[[create user]]</code>
  
 +
* <code>[[PostgreSQL: CREATE USER|CREATE USER]] name WITH Role XXX</code>
  
 +
List [[users]] and roles:
 +
* <code>[[\du]]</code>
 +
* <code>[[\du+]]</code>
 
* <code>[[SELECT rolname FROM pg_roles;]]</code>
 
* <code>[[SELECT rolname FROM pg_roles;]]</code>
 +
* <code>[[SELECT * FROM pg_roles]];</code>
 +
 +
Assign roles:
 +
* <code>[[GRANT "your-defined role" TO "your username";]]</code>
  
 
== Related terms ==
 
== Related terms ==
* <code>[[\du]]</code>
+
* <code>[[CREATE ROLE]]</code>, <code>[[create user]]</code>
 
+
* [[Schema]]
 +
* <code>[[GRANT]]</code> privileges to [[roles]]
 +
* <code>[[Superuser]]</code>
 +
* <code>[[rds_superuser]]</code> role in [[AWS RDS]]
 +
* [[Ansible roles]]
 +
* [[ALTER USER myuser WITH SUPERUSER;]]
 +
* [[DROP ROLE]]
 +
* [[community.postgresql.postgresql_privs]]
 +
* <code>[[\list+]]</code>
  
 
== See also ==
 
== See also ==
* {{PostgreSQL}}
+
* {{Role}}
 +
* {{GRANT}}
 +
* {{PostgreSQL Privileges}}
  
 
[[Category:PostgreSQL]]
 
[[Category:PostgreSQL]]

Latest revision as of 12:07, 16 December 2022

Advertising: