Skip to main content

SHOW USERS

Lists all the users in the system.

Syntax

SHOW USERS;

Examples

SHOW USERS;

---
| name | hostname | auth_type | auth_string | is_configured |
|---------------------------|----------|----------------------|------------------------------------------|---------------|
| sqluser_johnappleseed | % | double_sha1_password | 147dee8f648a745805ee8dda80bb8e277559f55b | NO |
| johnappleseed@example.com | % | jwt | | NO |
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today