SHOW USERS

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

SQL

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

SHOW USERS

On this page

Syntax

Example

Was this article helpful?

On this page

Was this article helpful?