Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

SHOW USERS

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