SHOW USERS
On this page
Show users on a SingleStore cluster.
Note: This command requires *. privileges on all databases to view all users in the cluster.
GRANT ALL ON *.* to <user>;
Refer to GRANT for more information.
Syntax
SHOW USERSOutput
|
Column |
Description |
|---|---|
|
|
Username |
|
|
Type of user (Native, SAML, PAM, or GSSAPI) |
|
|
Number of user connections |
|
|
Is deleted |
|
|
Default resource pool name when user starts a connection |
|
|
Whether the user is automatically synchronized to all aggregators in the cluster. |
Example
SHOW USERS;
+-------------------------+--------+-------------+------------+-----------------------+-----------+
| User | Type | Connections | Is deleted | Default resource pool | Is local |
+-------------------------+--------+-------------+------------+-----------------------+-----------+
| 'admin'@'127.0.0.1' | Native | 0 | | | SYNC |
| 'admin'@'localhost' | SAML | 0 | | | SYNC |
| 'dashboard'@'127.0.0.1' | Native | 0 | | respool1 | SYNC |
| 'root'@'%' | Native | 1 | | | LOCAL |
| 'pam'@'ident.secure.com'| PAM | 0 | | | SYNC |
+-------------------------+--------+-------------+------------+-----------------------+-----------+Related Topics
Last modified: October 16, 2025