# SHOW ROLES FOR GROUP

Show roles for a specific group.

## Syntax

```
SHOW ROLES FOR GROUP group_specification

group_specification:
  group
  [
    'group_name'
  ]

```

**Output**

| Column                      | Description              |
| --------------------------- | ------------------------ |
| `Roles of group group_name` | Roles of specified group |

## Example

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

```

```output

+------------------------+
| Roles of group group_0 |
+------------------------+
| role_name_0            |
+------------------------+
1 row in set (0.00 sec)

```

**Related Topics**

* [SHOW ROLES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/show-roles.md)
* [SHOW ROLES FOR USER](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/show-roles-for-user.md)

***

Modified at: August 18, 2023

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

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