GROUP_PRIVILEGES

This view 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 view. 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.

Last modified: August 29, 2022

Was this article helpful?