# SHOW GROUPS FOR ROLE

Show groups for a specific role.

## Syntax

```
SHOW GROUPS FOR ROLE role_specification

role_specification:
  role
  [
    ROLE 'role_name'
  ]

```

**Output**

| Column                       | Description      |
| ---------------------------- | ---------------- |
| `Groups with role role_name` | Groups with role |

## Example

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

```

```output

+------------------------------+
| Groups with role role_name_0 |
+------------------------------+
| group_0                      |
+------------------------------+
1 row in set (0.00 sec)

```

**Related Topics**

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

***

Modified at: August 18, 2023

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

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