Skip to main content

SHOW USERS

Shows the list of user accounts.

Syntax​

SHOW USERS

Examples​

SHOW USERS;
+------+----------+----------------------+---------------+
| name | hostname | auth_type            | is_configured |
+------+----------+----------------------+---------------+
| root | %        | double_sha1_password | YES           |
+------+----------+----------------------+---------------+
| test | %        | double_sha1_password | NO            |
+------+----------+----------------------+---------------+
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today