{"kind": "role", "major": "18", "item": {"slug": "pg_read_all_data", "name": "pg_read_all_data", "name_zh": "pg_read_all_data", "category": "Data access", "summary": "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.", "aliases": [], "versions": {"14": {"facts": [{"label": "Name", "value": "pg_read_all_data"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 14.24 Documentation", "label": "14.24", "major": "14", "channel": "stable", "revision": "c4f98c255865a7a07ab35932e3b23ce2ab575a70c0cd8d3194de646732680f44"}, "sources": [{"url": "/docs/14/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 14.24 Documentation", "sha256": "c4f98c255865a7a07ab35932e3b23ce2ab575a70c0cd8d3194de646732680f44"}, {"url": "https://www.postgresql.org/docs/14/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 14 online manual"}], "sections": [], "description": ["Read all data (tables, views, sequences), as if having SELECT rights on those objects, and USAGE rights on all schemas, even without having it explicitly. This role does not have the role attribute BYPASSRLS set. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is GRANTed to."]}, "15": {"facts": [{"label": "Name", "value": "pg_read_all_data"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 15.19 Documentation", "label": "15.19", "major": "15", "channel": "stable", "revision": "043d217ec318b20df8710081386db7be2eacafc839eae7f0c12df2712955f55a"}, "sources": [{"url": "/docs/15/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 15.19 Documentation", "sha256": "043d217ec318b20df8710081386db7be2eacafc839eae7f0c12df2712955f55a"}, {"url": "https://www.postgresql.org/docs/15/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 15 online manual"}], "sections": [], "description": ["Read all data (tables, views, sequences), as if having SELECT rights on those objects, and USAGE rights on all schemas, even without having it explicitly. This role does not have the role attribute BYPASSRLS set. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is GRANTed to."]}, "16": {"facts": [{"label": "Name", "value": "pg_read_all_data"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 16.15 Documentation", "label": "16.15", "major": "16", "channel": "stable", "revision": "8626abe19619170614b1adbddcf8a8b5c58983fa82b372312ed7da04b73593ea"}, "sources": [{"url": "/docs/16/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 16.15 Documentation", "sha256": "8626abe19619170614b1adbddcf8a8b5c58983fa82b372312ed7da04b73593ea"}, {"url": "https://www.postgresql.org/docs/16/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 16 online manual"}], "sections": [], "description": ["Read all data (tables, views, sequences), as if having SELECT rights on those objects, and USAGE rights on all schemas, even without having it explicitly. This role does not have the role attribute BYPASSRLS set. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is GRANTed to."]}, "17": {"facts": [{"label": "Name", "value": "pg_read_all_data"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 17.11 Documentation", "label": "17.11", "major": "17", "channel": "stable", "revision": "64c01b6876124ed9b6190d7418108b81e2f35b6290b0562b8e4466a65e0eb603"}, "sources": [{"url": "/docs/17/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 17.11 Documentation", "sha256": "64c01b6876124ed9b6190d7418108b81e2f35b6290b0562b8e4466a65e0eb603"}, {"url": "https://www.postgresql.org/docs/17/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 17 online manual"}], "sections": [], "description": ["Read all data (tables, views, sequences), as if having SELECT rights on those objects, and USAGE rights on all schemas, even without having it explicitly. This role does not have the role attribute BYPASSRLS set. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is GRANTed to."]}, "18": {"facts": [{"label": "Name", "value": "pg_read_all_data"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 18.6 Documentation", "label": "18.6", "major": "18", "channel": "stable", "revision": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, "sources": [{"url": "/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-READ-ALL-DATA", "label": "PostgreSQL 18.6 Documentation", "sha256": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, {"url": "https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-READ-ALL-DATA", "label": "PostgreSQL 18 online manual"}], "sections": [], "description": ["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."]}, "19": {"facts": [{"label": "Name", "value": "pg_read_all_data"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 19beta4 Documentation", "label": "19beta4", "major": "19", "channel": "preview", "revision": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, "sources": [{"url": "/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-READ-ALL-DATA", "label": "PostgreSQL 19beta4 Documentation", "sha256": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, {"url": "https://www.postgresql.org/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-READ-ALL-DATA", "label": "PostgreSQL 19 online manual"}], "sections": [], "description": ["pg_read_all_data allows reading all data (tables, views, sequences, large objects), 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."]}, "20": {"facts": [{"label": "Name", "value": "pg_read_all_data"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 20devel Documentation", "label": "20devel", "major": "20", "channel": "devel", "revision": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, "sources": [{"url": "/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-READ-ALL-DATA", "label": "PostgreSQL 20devel Documentation", "sha256": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, {"url": "https://www.postgresql.org/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-READ-ALL-DATA", "label": "PostgreSQL devel online manual"}], "sections": [], "description": ["pg_read_all_data allows reading all data (tables, views, sequences, large objects), 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."]}}, "content_hash": "4c1c6e5a63d184de658c43acd28b7a1577dd488ef82b99495a47b5f20c6ffe9a", "imported_at": "2026-09-27T09:57:59.053"}, "snapshot": {"facts": [{"label": "Name", "value": "pg_read_all_data"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 18.6 Documentation", "label": "18.6", "major": "18", "channel": "stable", "revision": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, "sources": [{"url": "/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-READ-ALL-DATA", "label": "PostgreSQL 18.6 Documentation", "sha256": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, {"url": "https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-READ-ALL-DATA", "label": "PostgreSQL 18 online manual"}], "sections": [], "description": ["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."]}, "comparison": {"left": "13", "right": "14", "status": "added", "diff": "--- PostgreSQL 13\n+++ PostgreSQL 14\n@@ -1 +1,14 @@\n-Not recorded in this version\n+{\n+  \"facts\": [\n+    {\n+      \"label\": \"Name\",\n+      \"value\": \"pg_read_all_data\"\n+    },\n+    {\n+      \"label\": \"Manual terminology\",\n+      \"value\": \"Predefined roles\"\n+    }\n+  ],\n+  \"signature\": null,\n+  \"tables\": null\n+}"}}