Skip to main content

SHOW USERS

Shows the list of user accounts.

Syntax

SHOW USERS

Examples

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