SHOW ROLES 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 roles for a specific user.
Syntax
SHOW ROLES FOR USER user_specification
user_specification:
'user_name'@'host_name'
Output
Column |
Description |
---|---|
|
Roles of specified user |
Example
SHOW ROLES FOR USER 'root'@'localhost';
+------------------------------+
| Roles of user root@localhost |
+------------------------------+
| role_name_0 |
+------------------------------+
1 row in set (0.00 sec)
Related Topics
Last modified: August 18, 2023