The SHOW USERS statement lists the users for all databases.

Synopsis

SHOW USERS

Required privileges

The user must have the SELECT privilege on the system table.

Example

copy
icon/buttons/copy
> SHOW USERS;
  user_name
+------------+
  jpointsman
  maxroach
  root
(3 rows)

Alternatively, within the built-in SQL shell, you can use the \du shell command:

copy
icon/buttons/copy
> \du
  user_name
+------------+
  jpointsman
  maxroach
  root
(3 rows)

See also



Yes No