Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

SHOW ROLES FOR USER

On this page

The SHOW ROLES FOR USER command shows roles for a specific user.

Syntax

SHOW ROLES FOR USER user_specification

user_specification:
  'user_name'@'host_name'

Output

Column

Description

Roles of user user_name

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:

Was this article helpful?