Difference between revisions of "PostgreSQL: Database roles"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
List [[users]] and roles: | List [[users]] and roles: | ||
* <code>[[\du]]</code> | * <code>[[\du]]</code> | ||
| + | * <code>[[\du+]]</code> | ||
* <code>[[SELECT rolname FROM pg_roles;]]</code> | * <code>[[SELECT rolname FROM pg_roles;]]</code> | ||
Revision as of 14:31, 27 April 2022
Create role:
List users and 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:
