pg_auth_members system catalog table 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 HAWQ system.
||oid||pg_authid.oid||ID of the parent-level (group) role|
||oid||pg_authid.oid||ID of a member role|
||oid||pg_authid.oid||ID of the role that granted this membership|
||boolean||True if role member may grant membership to others|