SHOW USERS

2020-02-16

The SHOW USERS statement lists the users for all databases.

Synopsis

{% include {{ page.version.version }}/sql/diagrams/show_users.html %}

Required privileges

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

Example

> SHOW USERS;
+-------------+
|  user_name  |
+-------------+
| jpointsman  |
| maxroach    |
| root        |
+-------------+

See also