# SHOW ROLES FOR USER

Show roles for a specific user.

## Syntax

```
SHOW ROLES FOR USER user_specification

user_specification:
  'user_name'@'host_name'

```

**Output**

| Column                    | Description             |
| ------------------------- | ----------------------- |
| `Roles of user user_name` | Roles of specified user |

**Example**

```sql
SHOW ROLES FOR USER 'root'@'localhost';

```

```output

+------------------------------+
| Roles of user root@localhost |
+------------------------------+
| role_name_0                  |
+------------------------------+
1 row 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](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/show-roles.md)

***

Modified at: August 18, 2023

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

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