# SHOW ROLES

Shows the list of roles on a cluster.

## Syntax

```
SHOW ROLES [LIKE 'pattern'];

```

**Output**

| Column  | Description |
| ------- | ----------- |
| `ROLES` | Role name   |

## Remarks

* `LIKE`: allows users to find roles matching a specific naming pattern.The pattern can include wildcard characters, such as %, to represent zero or more characters in the search string.
  ```
  SHOW ROLES LIKE 'xyz';
  ```

* The information\_schema.`ROLES` view provides metadata about the roles configured within the cluster.
* A user with the `SHOW METADATA` or `GRANT` permission can list all roles. Without these permissions, role visibility follows the general information schema access rules. Refer to [Accessing the Information Schema](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/accessing-the-information-schema.md) for more information.

## Example

```sql
SHOW ROLES;

```

```output

+-------------+
| Roles       |
+-------------+
| role_name_0 |
| role_name_1 |
| role_name_2 |
| role_name_3 |
+-------------+
4 rows in set (0.00 sec)

```

**Related Topics**

* [SHOW ROLES FOR GROUP](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/show-roles-for-group.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: May 12, 2026

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

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