SingleStore DB

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