Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

SHOW USERS

Show users on a SingleStore DB cluster.

Syntax

SHOW USERS

Output

Column Description
User Username
Type Type of user (Native, SAML, PAM, or GSSAPI)
Connections Number of user connections
Is deleted Is deleted
Default resource pool Default resource pool name when user starts a connection
Is local Whether the user is automatically synchronized to all aggregators in the cluster. If the sync_permissions variable is enabled on your cluster, then all users other than root are automatically synchronized.

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