Difference between revisions of "List users"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
* [[Postgres]] (<code>[[psql]]</code>): <code>[[\du]]</code> or <code>[[\du+]]</code> | * [[Postgres]] (<code>[[psql]]</code>): <code>[[\du]]</code> or <code>[[\du+]]</code> | ||
| − | * <code>SELECT * FROM pg_roles;</code> | + | * <code>[[SELECT * FROM pg_roles]];</code> |
* [[GCP]]: <code>[[gcloud projects get-iam-policy]] MY_PROJECT</code> | * [[GCP]]: <code>[[gcloud projects get-iam-policy]] MY_PROJECT</code> | ||
Revision as of 18:34, 14 December 2022
- Postgres (
psql):\duor\du+ SELECT * FROM pg_roles;- GCP:
gcloud projects get-iam-policy MY_PROJECT
Related terms
- Connect to a database
- Show databases
- Create database
- Delete database
- Create user
- List users
- List databases
- List tables:
show tables - GRANT
See also
- 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
Advertising:
