# SHOW USERS

Show users on a SingleStore cluster.

**Note**: This command requires `*.*`  privileges on all databases to view all users in the cluster.

```sql
GRANT ALL ON *.* to <user>;
```

Refer to [GRANT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/grant.md) for more information.

## 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 thecluster. If the`sync_permissions`variable is enabled on yourcluster, then all users other than`root`are automatically synchronized. |

## Example

```sql
SHOW USERS;

```

```output

+-------------------------+--------+-------------+------------+-----------------------+-----------+
| 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 FOR GROUP](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/show-users-for-group.md)
* [SHOW USERS FOR ROLE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/show-users-for-role.md)

***

Modified at: October 16, 2025

Source: [/db/v9.1/reference/sql-reference/security-management-commands/show-users/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/show-users/)

(An index of the documentation is available at /llms.txt)