This version of the Pivotal Greenplum documentation is no longer actively maintained. Click here to view the most up-to-date version of the Greenplum 4.x documentation.
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.
|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 may grant membership to others|