The 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 Greenplum Database system.

    columntypereferencesdescription
    roleidoidpg_authid.oidID of the parent-level (group) role
    memberoidpg_authid.oidID of a member role
    grantoroidpg_authid.oidID of the role that granted this membership
    admin_optionboolean True if role member may grant membership to others

    Parent topic: System Catalogs Definitions