Difference between revisions of "List users"
Jump to navigation
Jump to search
(4 intermediate revisions by 2 users not shown) | |||
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> | ||
== Related terms == | == Related terms == | ||
− | * | + | * [[CREATE USER]] |
== See also == | == See also == | ||
+ | * {{CREATE USER}} | ||
+ | * {{psql}} | ||
* {{SQL}} | * {{SQL}} | ||
[[Category:Databases]] | [[Category:Databases]] |
Latest revision as of 10:38, 23 September 2024
- Postgres (
psql
):\du
or\du+
SELECT * FROM pg_roles;
- GCP:
gcloud projects get-iam-policy MY_PROJECT
Related terms[edit]
See also[edit]
- CREATE USER, List users
\du
,\du+
- PostgreSQL:
psql
,.psqlrc, .pgpass
,$HOME/.pg service.conf
,-U, -W, -d
, meta-commands:\du, \dg, \ddp, \dp, \list, \dn, \dt, \c, \l, \di, \q
,show users
,show
,su - postgres
,psql -c, \?, \connect, \conninfo
,--version, --help
, PL/pgSQL - 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: