You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

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

memsql> SHOW GROUPS FOR USER 'root'@'localhost';
+-------------------------------+
| Groups of user root@localhost |
+-------------------------------+
| group_0                       |
+-------------------------------+
1 row in set (0.00 sec)

Related Topics