↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1
Pre-release documentation. PostgreSQL 19 Beta 3 is a testing release. The final release may differ.
52.9. pg_auth_members
Prev  Up Chapter 52. System Catalogs Home  Next

52.9. pg_auth_members #

The catalog pg_auth_members shows the membership relations between roles. Any non-circular set of relationships is allowed.

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 52.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

Prev  Up  Next
52.8. pg_authid  Home  52.10. pg_cast

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.