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 <[email protected]>
Reported-by: Anthropic OSS program
Author: Nathan Bossart <[email protected]>
Co-authored-by: Anthropic OSS program
Reviewed-by: Andrew Dunstan <[email protected]>
Security: CVE-2026-116303
Backpatch-through: 14

Branch
------
REL_18_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/3531f4b343d7cad7c24b17d5e4ed74f1721d2a86
Author: Nathan Bossart <[email protected]>

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

Reply via email to