{"Entry":{"collection":"catalog","key":"pg_auth_members","name":"pg_auth_members","aliases":[],"metadata":{"changed_in":["16"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.0","order":false,"removed":[],"status":"added","to":"8.1","types":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"True if member may grant membership in roleid to others","name":"admin_option","to":"True if member can grant membership in roleid to others"}],"from":"8.2","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.3","types":[],"unlisted":[]},{"added":["oid","inherit_option","set_option"],"attributes":[],"description_changed":false,"descriptions":[],"from":"15","listing":[],"order":false,"removed":[],"status":"changed","to":"16","types":[],"unlisted":[]}],"column_count":7,"content_hash":"83f0174557d8b95ddc0339fa6281cffb6e4c13fa86e9d75fcd2ee1b5f99b5d2c","first_version":"8.1","imported_at":"2026-09-30T00:40:55.353812+08:00","kind":"catalog","last_version":"20","name":"pg_auth_members","position":7,"present_in":["8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"r","shared":false,"source_rev":"english-manuals:651a007f00d2521d9876eb03a39aacde8b6321854e5662524cac92cdcd58457e","summary":"The catalog pg_auth_members shows the membership relations between roles.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_auth_members","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_auth_members","SourceRevision":"english-manuals:651a007f00d2521d9876eb03a39aacde8b6321854e5662524cac92cdcd58457e","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Row identifier","description_zh":"","documented":true,"documented_name":"oid","hidden":false,"name":"oid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":2,"description":"ID of a role that has a member","description_zh":"","documented":true,"documented_name":"roleid","hidden":false,"name":"roleid","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":3,"description":"ID of a role that is a member of roleid","description_zh":"","documented":true,"documented_name":"member","hidden":false,"name":"member","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":4,"description":"ID of the role that granted this membership","description_zh":"","documented":true,"documented_name":"grantor","hidden":false,"name":"grantor","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":5,"description":"True if member can grant membership in roleid to others","description_zh":"","documented":true,"documented_name":"admin_option","hidden":false,"name":"admin_option","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":6,"description":"True if the member automatically inherits the privileges of the granted role","description_zh":"","documented":true,"documented_name":"inherit_option","hidden":false,"name":"inherit_option","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":7,"description":"True if the member can SET ROLE to the granted role","description_zh":"","documented":true,"documented_name":"set_option","hidden":false,"name":"set_option","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16}],"description":"The catalog pg_auth_members shows the membership relations between roles. Any non-circular set of relationships is allowed.\n\nBecause 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.","description_zh":"","doc":{"anchor":"id-1.10.4.11.5","file":"catalog-pg-auth-members.html","lang":"en","sha256":"a9074fddc29e047b3b0d6761fa65f71a06236f7c671fdc7d20939a842aad716f","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","roleid","member","grantor","admin_option","inherit_option","set_option"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.11.5","file":"catalog-pg-auth-members.html","lang":"en","sha256":"a9074fddc29e047b3b0d6761fa65f71a06236f7c671fdc7d20939a842aad716f","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","roleid","member","grantor","admin_option","inherit_option","set_option"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_auth_members","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_auth_members","Summary":"目录pg_auth_members展示了角色之间的成员关系。允许任何无环的关系集合。\n\n由于用户身份是集簇范围的，pg_auth_members在一个集簇的所有数据库之间共享：在一个集簇中只有一份pg_auth_members拷贝，而不是每个数据库一份。","BodyHTML":"\u003cp\u003e目录pg_auth_members展示了角色之间的成员关系。允许任何无环的关系集合。\n\n由于用户身份是集簇范围的，pg_auth_members在一个集簇的所有数据库之间共享：在一个集簇中只有一份pg_auth_members拷贝，而不是每个数据库一份。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"925f3f2c4d610ba48e7a2a702f1dc4a307a351832c52b287d5fa0c63982d025e","Payload":{"columns":[{"description_zh":"行标识符","name":"oid","type":"oid","zh_from":"doc"},{"description_zh":"拥有成员的角色的ID","name":"roleid","type":"oid","zh_from":"doc"},{"description_zh":"roleid的成员角色的ID","name":"member","type":"oid","zh_from":"doc"},{"description_zh":"授权此成员关系的角色的ID","name":"grantor","type":"oid","zh_from":"doc"},{"description_zh":"如果member能够将roleid的成员资格授予其他角色，则为真","name":"admin_option","type":"boolean","zh_from":"doc"},{"description_zh":"如果成员会自动继承被授予角色的权限，则为真","name":"inherit_option","type":"boolean","zh_from":"doc"},{"description_zh":"如果成员可以 SET ROLE 到被授予的角色，则为真","name":"set_option","type":"boolean","zh_from":"doc"}],"description_zh":"目录pg_auth_members展示了角色之间的成员关系。允许任何无环的关系集合。\n\n由于用户身份是集簇范围的，pg_auth_members在一个集簇的所有数据库之间共享：在一个集簇中只有一份pg_auth_members拷贝，而不是每个数据库一份。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}