SingleStore Managed Service

information_schema.GROUP_PRIVILEGES

This table contains information about privileges as they relate to the roles and groups they are associated with. 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 name of a role associated with a given group.

DATABASE

The name of the related database.

TABLE

The name of the table to which a given privilege relates.

PRIVILEGES

The privileges associated with a given role.