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 |
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
