SHOW USERS

Show users on a MemSQL cluster.

Syntax

SHOW USERS

Output

Column Description
User user
Type the type of user (Native, SAML, PAM, or GSSAPI)
Connections connections
Is deleted is deleted
Default resource pool the default resource pool name when user starts a connection

Example

SHOW USERS;
****
+-------------------------+--------+-------------+------------+-----------------------+
| User                    | Type   | Connections | Is deleted | Default resource pool |
+-------------------------+--------+-------------+------------+-----------------------+
| 'admin'@'127.0.0.1'     | Native |           0 |            |                       |
| 'admin'@'localhost'     | SAML   |           0 |            |                       |
| 'dashboard'@'127.0.0.1' | Native |           0 |            | respool1              |
| 'root'@'%'              | Native |           1 |            |                       |
| 'pam'@'ident.secure.com'| PAM    |           0 |            |                       |
+-------------------------+--------+-------------+------------+-----------------------+
5 rows in set (0.00 sec)

Related Topics

Was this article useful?