pgsql: Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE

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

pgsql: Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE

От:
Noah Misch <noah@leadboat.com>
Дата:
Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE.

This omission allowed roles without USAGE on a type to create range
types that depend on it, which could prevent the owner from
changing the type later.

Reported-by: Jingzhou Fu 
Author: Nathan Bossart 
Reviewed-by: Noah Misch 
Reviewed-by: Robert Haas 
Security: CVE-2026-6470
Backpatch-through: 14

Branch
------
REL_15_STABLE

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

Modified Files
--------------
doc/src/sgml/ref/create_type.sgml        |  5 +++++
src/backend/commands/typecmds.c          |  4 ++++
src/test/regress/expected/rangetypes.out | 15 +++++++++++++++
src/test/regress/sql/rangetypes.sql      | 14 ++++++++++++++
4 files changed, 38 insertions(+)

FAQ