Postgresql 中文操作指南
53.9. pg_auth_members #
目录 pg_auth_members 显示了角色之间的成员关系。允许任何非循环关系集。
The catalog pg_auth_members shows the membership relations between roles. Any non-circular set of relationships is allowed.
因为用户标识是整个群集的，所以 pg_auth_members 在群集的所有数据库中共享：每个群集只有一个 pg_auth_members 的副本，而不是每个数据库一个。
Because user identities are cluster-wide, pg_auth_members is shared across all databases of a cluster: there is only one copy of pg_auth_members per cluster, not one per database.
Table 53.9. pg_auth_members Columns
Table 53.9. pg_auth_members Columns
Column Type Description |
oid oid Row identifier |
roleid oid (references pg_authid.oid) ID of a role that has a member |
member oid (references pg_authid.oid) ID of a role that is a member of roleid |
grantor oid (references pg_authid.oid) ID of the role that granted this membership |
admin_option bool True if member can grant membership in roleid to others |
inherit_option bool True if the member automatically inherits the privileges of the granted role |
set_option bool True if the member can SET ROLE to the granted role |