You are viewing an older version of this section. View current production version.
Join the SingleStore 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 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