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