Difference between revisions of "PostgreSQL: Database roles"
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
== Related terms == | == Related terms == | ||
| − | + | * <code>[[CREATE ROLE]]</code>, <code>[[create user]]</code> | |
| − | * <code>[[ | ||
| − | |||
* [[Schema]] | * [[Schema]] | ||
* <code>[[GRANT]]</code> privileges to [[roles]] | * <code>[[GRANT]]</code> privileges to [[roles]] | ||
| − | * [[Superuser]] | + | * <code>[[Superuser]]</code> |
* <code>[[rds_superuser]]</code> role in [[AWS RDS]] | * <code>[[rds_superuser]]</code> role in [[AWS RDS]] | ||
| + | * [[Ansible roles]] | ||
== See also == | == See also == | ||
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
CREATE ROLE,create user- Schema
GRANTprivileges to rolesSuperuserrds_superuserrole in AWS RDS- Ansible roles
See also
- PostgreSQL: Database roles,
CREATE USER,CREATE ROLE,\du, \du+,create user, Alter user - SQL, NewSQL: 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
Advertising:
