gp_roles_assigned
The gp_toolkit.gp_roles_assigned view shows all of the roles in the system, and their assigned members (if the role is also a group role).
This view is accessible to all users.
| Column | Description |
|---|---|
raroleid |
The role object ID. If this role has members (users), it is considered a group role |
rarolename |
The role (user or group) name |
ramemberid |
The role object ID of the role that is a member of this role |
ramembername |
Name of the role that is a member of this role |