The pg_auth_members catalog provides information about membership relations between roles.
| Column name | Data type | Description |
|---|---|---|
oid |
oid |
A row identifier. |
roleid |
oid (references pg_authid.oid) |
The ID of the role to which the member belongs. |
member |
oid (references pg_authid.oid) |
The ID of a role that is the member of roleid. |
grantor |
oid (references pg_authid.oid) |
The ID of a role that granted the membership. |
admin_option |
bool |
Specifies whether the member can grant membership in roleid to others (TRUE) or not (FALSE). |
inherit_option |
bool |
Specifies whether the member automatically inherits the privileges of the granted role (TRUE) or not (FALSE). |
set_option |
bool |
Specifies whether the member can SET ROLE to the granted role (TRUE) or not (FALSE). |