PostgreSQL -- PostgreSQL row security below e.g. subqueries disregards user ID changes

2024-11-14 · CVE-2024-10976 · VuXML entry

PostgreSQL project reports: Incomplete tracking in PostgreSQL of tables with row security allows a reused query to view or change different rows from those intended. CVE-2023-2455 and CVE-2016-2193 fixed most interaction between row security and user ID changes. They missed cases where a subquery, WITH query, security invoker view, or SQL-language function references a table with a row-level security policy. This …

Affected versions

• postgresql17-server < 17.1
• postgresql16-server < 16.5
• postgresql15-server < 15.9
• postgresql14-server < 14.14
• postgresql13-server < 13.17
• postgresql12-server < 12.21

By system

0 still vulnerable, 8 fixed. Where VuXML applies (FreeBSD, DragonFly, FreeBSD's derivatives) a port is vulnerable while its version is in a range; pkgsrc says itself whether it lists a CVE of this advisory; OpenBSD and MidnightBSD keep no list this site reads, so their row is only an estimate: FreeBSD's ranges applied to upstream's version.