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

Example

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

Related Topics