SingleStore DB

information_schema.GROUPS_ROLES

This table contains information about groups and the roles that are part of them. If you (the current user) has the GRANT permission, you can see all role-group pairs in this table. Otherwise, you will see only the pairs from groups you are part of.

Column Name

Description

GROUP

The name of a given group.

ROLE

The role related to a given group.