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(+)