AI agents/LLMs: Fetch /llms.txt first to access the documentation index. Remove the trailing slash and append .md to any URL to access lighter, easier-to-parse Markdown pages instead of HTML (this page is accessible at https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/show-roles-for-user.md).

SHOW ROLES FOR USER user_specification

user_specification:
  'user_name'@'host_name'

SHOW ROLES FOR USER 'root'@'localhost';

+------------------------------+
| Roles of user root@localhost |
+------------------------------+
| role_name_0                  |
+------------------------------+
1 row in set (0.00 sec)