pgsql: Check EXECUTE privilege on type-to-json cast functions.

Поиск
Список
Период
Сортировка
Искать

pgsql: Check EXECUTE privilege on type-to-json cast functions.

От:
Noah Misch <noah@leadboat.com>
Дата:
Check EXECUTE privilege on type-to-json cast functions.

When converting a value to json or jsonb, to_json() and its many
friends execute the cast function without first checking for
EXECUTE privileges.  To fix, check privileges and invoke the
object access hook before calling the cast function.  This
covers to_json(), to_jsonb(), row_to_json(), array_to_json(), the
json[b]_build_*() and *_agg() functions, the SQL/JSON constructors
(v16 and later), and COPY TO with FORMAT json (v19 and later).

Reported-by: Filip Janus 
Reported-by: Anthropic OSS program
Author: Nathan Bossart 
Co-authored-by: Anthropic OSS program
Reviewed-by: Andrew Dunstan 
Security: CVE-2026-116303
Backpatch-through: 14

Branch
------
REL_16_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/ab7594cd162076263a902d08f3a063548cb93f2c
Author: Nathan Bossart 

Modified Files
--------------
src/backend/utils/adt/json.c             |  9 +++++++++
src/backend/utils/adt/jsonb.c            | 11 +++++++++++
src/test/regress/expected/privileges.out | 21 +++++++++++++++++++++
src/test/regress/sql/privileges.sql      | 15 +++++++++++++++
4 files changed, 56 insertions(+)

FAQ