# SHOW GROUPS FOR USER

Show groups for a specific user.

## Syntax

```

SHOW GROUPS FOR USER user_specification

user_specification:
  user
  [
    USER 'user_name'
  ]

```

**Output**

| Column                     | Description    |
| -------------------------- | -------------- |
| `Groups of user user_name` | groups of user |

## Example

```
SHOW GROUPS FOR USER 'root'@'localhost';

```

```output

+-------------------------------+
| Groups of user root@localhost |
+-------------------------------+
| group_0                       |
+-------------------------------+
1 row in set (0.00 sec)

```

**Related Topics**

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

***

Modified at: August 18, 2023

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

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