lo_compat_privileges
In PostgreSQL releases prior to 9.0, large objects did not have access privileges and were, therefore, always readable and writable by all users. Setting this variable to on disables the new privilege checks, for compatibility with prior releases. The default is off. Only superusers and users with the appropriate SET privilege can change this setting. Setting this variable does not disable all security checks related to large objects — only those for which the default behavior has changed in PostgreSQL 9.0.
英文手册覆盖始于 PostgreSQL 7.4. 来源历史与运行验证各自保留独立版本边界。
当前阅读 PG 18·选择有来源记录的版本
此版本暂无所选语言的定义，以下显示原始英文内容。
- boot val
- off
- category
- Version and Platform Compatibility / Previous PostgreSQL Versions
- context
- superuser
- documented
- true
- enumvals
- 未知
- extra desc
- Skips privilege checks when reading or modifying large objects, for compatibility with PostgreSQL releases prior to 9.0.
- lang
- en
- max val
- 未知
- metadata version
- 18
- min val
- 未知
- name
- lo_compat_privileges
- short desc
- Enables backward compatibility mode for privilege checks on large objects.
- source
- pg-settings-source-snapshot
- unit
- 未知
- vartype
- bool
版本定义 PG 18
In PostgreSQL releases prior to 9.0, large objects did not have access privileges and were, therefore, always readable and writable by all users. Setting this variable to on disables the new privilege checks, for compatibility with prior releases. The default is off. Only superusers and users with the appropriate SET privilege can change this setting. Setting this variable does not disable all security checks related to large objects — only those for which the default behavior has changed in PostgreSQL 9.0.
比较版本
来源引用
定义来源
center · PostgreSQL 18 · english-manuals:7b9409a16a07641140ec9d32418928db0c5d3f3f9434760ab321d777b408ef46
正文语言: en · english-manuals:7b9409a16a07641140ec9d32418928db0c5d3f3f9434760ab321d777b408ef46