Outdated Version

You are viewing an older version of this section. View current production version.

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