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 |
Example
SHOW GROUPS FOR USER 'root'@'localhost'; +-------------------------------+ | Groups of user root@localhost | +-------------------------------+ | group_0 | +-------------------------------+ 1 row in set (0.00 sec)
Related Topics