Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
52.9. pg_auth_members
Prev UpChapter 52. System CatalogsHome Next

52.9. pg_auth_members

The catalogpg_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 ofpg_auth_members per cluster, not one per database.

Table 52.9. pg_auth_members Columns

Column Type

Description

roleidoid (referencespg_authid.oid)

ID of a role that has a member

memberoid (referencespg_authid.oid)

ID of a role that is a member ofroleid

grantoroid (referencespg_authid.oid)

ID of the role that granted this membership

admin_optionbool

True ifmember can grant membership inroleid to others



Prev Up Next
52.8. pg_authid Home 52.10. pg_cast
pdfepub
Go to Postgres Pro Standard 15
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

[8]ページ先頭

©2009-2025 Movatter.jp