# SHOW USERS FOR ROLE

Show users for a specific role.

## Syntax

```

SHOW USERS FOR ROLE 'role_name'

```

**Output**

| Column                     | Description                                                  |
| -------------------------- | ------------------------------------------------------------ |
| `User with role role_name` | User with role                                               |
| `Connections`              | Connections                                                  |
| `Is deleted`               | Is deleted                                                   |
| `Default resource pool`    | the default resource pool name when user starts a connection |

## Example

```sql
SHOW USERS FOR ROLE 'role_name_0'; 

```

```output

+-----------------------------+-------------+------------+-----------------------+
| Users with role role_name_0 | Connections | Is deleted | Default resource pool |
+-----------------------------+-------------+------------+-----------------------+
| 'root'@'localhost'          |           1 |            |                       |
+-----------------------------+-------------+------------+-----------------------+
1 row in set (0.00 sec)

```

**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](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/show-users.md)

***

Modified at: August 18, 2023

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

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