↑↓ 选择↵ 打开⌫ 切换范围完整搜索

PG.CENTER 连接 PostgreSQL 文档、百科与生态知识。由 Pigsty 维护。

Wiki / 预定义角色

pg_read_all_data

pg_read_all_data allows reading all data (tables, views, sequences), as if having SELECT rights on those objects and USAGE rights on all schemas. This role does not bypass row-level security (RLS) policies. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is granted to.

当前阅读 PG 18·选择有来源记录的版本

此版本暂无所选语言的定义,以下显示原始英文内容。

Name
pg_read_all_data
Manual terminology
Predefined roles

版本定义 PG 18

pg_read_all_data allows reading all data (tables, views, sequences), as if having SELECT rights on those objects and USAGE rights on all schemas. This role does not bypass row-level security (RLS) policies. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is granted to.

比较版本

来源引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75

正文语言: en · b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75