{"Entry":{"collection":"role","key":"pg_write_all_data","name":"pg_write_all_data","aliases":[],"metadata":{"aliases":[],"category":"Data access","content_hash":"2436644025bf2f2440c1c79ab66a1bd4d7a73c6dc7984d8946c4ae32abf52b52","derived_content_hash":"a65a49843e7ca79ce0253f6581bd4e3889ab088566032bcb546de70aed16133b","imported_at":"2026-09-27T17:57:59.065824+08:00","name":"pg_write_all_data","name_zh":"pg_write_all_data","repair_provenance":{"original_source_revision":"","receipt_sha256":"c12597a9426f02edeec47cf94b5789759c9fe981295bbddf2040a5f2d9fa6248","repair":"wiki-repair-20261023"},"slug":"pg_write_all_data","source_rev":"wiki-repair-20261023:8dfa6b30e5f27517ec0aab9ad5e3d1079e80c672f3265f9fa32d68e32556f580","summary":"pg_write_all_data allows writing all data (tables, views, sequences, large objects), as if having INSERT , UPDATE , and DELETE 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."}},"Definition":{"Collection":"role","Key":"pg_write_all_data","SourceDatabase":"center","Version":"18","SourceTable":"predefined_role","SourceKey":"pg_write_all_data","SourceRevision":"b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75","Facts":{"description":["pg_write_all_data allows writing all data (tables, views, sequences), as if having INSERT , UPDATE , and DELETE 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."],"description_zh":"pg_write_all_data 允许写入所有数据（表、视图、序列），其效果就像对这些对象拥有 INSERT、UPDATE 和 DELETE 权限并对所有模式拥有 USAGE 权限一样。该角色不会绕过行级安全（RLS）策略。如果正在使用 RLS，管理员可能希望对被授予此角色的角色设置 BYPASSRLS。","description_zh_html":"\u003cp\u003e\n\u003ccode class=\"literal\"\u003epg_write_all_data\u003c/code\u003e 允许写入所有数据（表、视图、序列），其效果就像对这些对象拥有 \u003ccode class=\"command\"\u003eINSERT\u003c/code\u003e、\u003ccode class=\"command\"\u003eUPDATE\u003c/code\u003e 和 \u003ccode class=\"command\"\u003eDELETE\u003c/code\u003e 权限并对所有模式拥有 \u003ccode class=\"literal\"\u003eUSAGE\u003c/code\u003e 权限一样。该角色不会绕过行级安全（RLS）策略。如果正在使用 RLS，管理员可能希望对被授予此角色的角色设置 \u003ccode class=\"literal\"\u003eBYPASSRLS\u003c/code\u003e。\n      \u003c/p\u003e","facts":[{"label":"Name","value":"pg_write_all_data"},{"label":"Manual terminology","value":"Predefined roles"}],"related":[],"release":{"channel":"stable","label":"18.6","major":"18","ref":"PostgreSQL 18.6 Documentation","revision":"b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"},"sections":[],"sources":[{"label":"PostgreSQL 18.6 Documentation","sha256":"b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75","url":"/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-READ-ALL-DATA"},{"label":"PostgreSQL 18 online manual","url":"https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-READ-ALL-DATA"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/predefined-roles.html","sha256":"99e1fbd83b1da2cf9da5823238b31d78c953c6118ecc61939808d2bf32f9b56d"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-pgdoc"},"ManualEvidence":{"release":{"channel":"stable","label":"18.6","major":"18","ref":"PostgreSQL 18.6 Documentation","revision":"b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"},"sources":[{"label":"PostgreSQL 18.6 Documentation","sha256":"b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75","url":"/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-READ-ALL-DATA"},{"label":"PostgreSQL 18 online manual","url":"https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-READ-ALL-DATA"}]},"MeasuredEvidence":{}},"Text":{"Collection":"role","Key":"pg_write_all_data","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_write_all_data","Summary":"pg_write_all_data allows writing all data (tables, views, sequences), as if having INSERT , UPDATE , and DELETE 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.","BodyHTML":"\u003cp\u003epg_write_all_data allows writing all data (tables, views, sequences), as if having INSERT , UPDATE , and DELETE 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.\u003c/p\u003e","SourceRevision":"b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75","ContentHash":"dd5175c96ad83244799cec91bcdafb69b28f00e7ed1726ccb38c216df8c36e9d","Payload":{"description":["pg_write_all_data allows writing all data (tables, views, sequences), as if having INSERT , UPDATE , and DELETE 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."],"related":[],"sections":[]}},"RequestedLocale":"en","Fallback":false,"Versions":["14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}