pg_auth_members
The pg_auth_members system catalog table in the pg_catalog schema shows the membership relations between roles. Any non-circular set of relationships is allowed. Because roles are system-wide, pg_auth_members is shared across all databases of a Apache Cloudberry system.
| column | type | references | description | 
|---|---|---|---|
| roleid | oid | pg_authid.oid | ID of the parent-level (group) role | 
| member | oid | pg_authid.oid | ID of a member role | 
| grantor | oid | pg_authid.oid | ID of the role that granted this membership | 
| admin_option | boolean | True if role member might grant membership to others |