SHOW GROUPS FOR USER
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
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
Last modified: August 18, 2023