# SHOW USERS FOR GROUP

Show users for a specific group.

## Syntax

```
SHOW USERS FOR GROUP 'group_name'

```

**Output**

| Column                      | Description                                                  |
| --------------------------- | ------------------------------------------------------------ |
| `Users in group group_name` | Users in group                                               |
| `Connections`               | Connections                                                  |
| `Is deleted`                | Is deleted                                                   |
| `Default resource pool`     | the default resource pool name when user starts a connection |

## Example

```sql
SHOW USERS FOR GROUP 'group_0';

```

```output

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

```

**Related Topics**

* [SHOW USERS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/show-users.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: August 18, 2023

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

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