SHOW USERS

On this page

Show users on a SingleStore 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

Last modified: August 18, 2023

Was this article helpful?