Difference between revisions of "PostgreSQL: Database roles"
Jump to navigation
Jump to search
| Line 8: | Line 8: | ||
* <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> | ||
== Related terms == | == Related terms == | ||
Revision as of 14:34, 27 April 2022
Create role:
List users and roles:
\du\du+SELECT rolname FROM pg_roles;SELECT * FROM pg_roles;
Related terms
- Ansible roles
create userCREATE ROLE- Schema
GRANTprivileges to roles- Superuser
rds_superuserrole in AWS RDS
See also
- PostgreSQL: Database roles,
CREATE USER,CREATE ROLE,\du, \du+,create user, Alter user - SQL, NewSQL, RDMS: GraphQL (2015), SQLite,
select, insert,select count, Distributed SQL, TablePlus, Cache hit ratio,pg_stat_user_tables,EXPLAIN, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy,CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint,.sql
Advertising:
