Wiki / Configuration Parameters

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.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

boot val

off

category

Version and Platform Compatibility / Previous PostgreSQL Versions

context

superuser

documented

true

enumvals

Unknown

extra desc

Skips privilege checks when reading or modifying large objects, for compatibility with PostgreSQL releases prior to 9.0.

lang

en

max val

Unknown

metadata version

18

min val

Unknown

name

lo_compat_privileges

short desc

Enables backward compatibility mode for privilege checks on large objects.

source

pg-settings-source-snapshot

unit

Unknown

vartype

bool