pg_auth_members

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.

pg_auth_members

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.

Table 1. pg_catalog.pg_auth_members
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 may grant membership to others