Outdated Version
You are viewing an older version of this section. View current production version.
SHOW USERS
Show users on a cluster.
Syntax
SHOW USERS
Output
| Column | Description |
|---|---|
User |
Username |
Type |
Type of user (Native, SAML, PAM, or GSSAPI) |
Connections |
Number of user connections |
Is deleted |
Is deleted |
Default resource pool |
Default resource pool name when user starts a connection |
Is local |
Whether the user is automatically synchronized to all aggregators in the cluster. If the sync_permissions variable is enabled on your cluster, then all users other than root are automatically synchronized. |
Example
SHOW USERS;
****
+-------------------------+--------+-------------+------------+-----------------------+-----------+
| User | Type | Connections | Is deleted | Default resource pool | Is local |
+-------------------------+--------+-------------+------------+-----------------------+-----------+
| 'admin'@'127.0.0.1' | Native | 0 | | | SYNC |
| 'admin'@'localhost' | SAML | 0 | | | SYNC |
| 'dashboard'@'127.0.0.1' | Native | 0 | | respool1 | SYNC |
| 'root'@'%' | Native | 1 | | | LOCAL |
| 'pam'@'ident.secure.com'| PAM | 0 | | | SYNC |
+-------------------------+--------+-------------+------------+-----------------------+-----------+
Related Topics
