Skip to main content
Version: Next

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.

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 might grant membership to others