Skip to content

CVE-2023-39418 Postgresql: merge fails to enforce update or select row security policies

MediumCVSS 4.3 EPSS 1.1%
Published
Updated
Exploit status
No public exploit known
CISA SSVC
No known exploitation · automatable: no · technical impact: partial
Technology
DebianRed Hat

Description

A vulnerability was found in PostgreSQL with the use of the MERGE command, which fails to test new rows against row security policies defined for UPDATE and SELECT. If UPDATE and SELECT policies forbid some rows that INSERT policies do not forbid, a user could store such rows.

Upgrade path

30 packages: 27 fixed.

PackageAffectedFixed inStatus
alpine/postgresql(Alpine v3.13) < 13.12-r0 13.12-r0 Fixed
alpine/postgresql(Alpine v3.14) < 13.12-r0 13.12-r0 Fixed
alpine/postgresql12(Alpine v3.15) < 12.16-r0 12.16-r0 Fixed
alpine/postgresql12(Alpine v3.16) < 12.16-r0 12.16-r0 Fixed
alpine/postgresql12(Alpine v3.17) < 12.16-r0 12.16-r0 Fixed
alpine/postgresql12(Alpine v3.18) < 12.16-r0 12.16-r0 Fixed
alpine/postgresql13(Alpine v3.15) < 13.12-r0 13.12-r0 Fixed
alpine/postgresql13(Alpine v3.16) < 13.12-r0 13.12-r0 Fixed
alpine/postgresql13(Alpine v3.17) < 13.12-r0 13.12-r0 Fixed
alpine/postgresql13(Alpine v3.18) < 13.12-r0 13.12-r0 Fixed
alpine/postgresql13(Alpine v3.19) < 13.12-r0 13.12-r0 Fixed
alpine/postgresql14(Alpine v3.15) < 14.9-r0 14.9-r0 Fixed
alpine/postgresql14(Alpine v3.16) < 14.9-r0 14.9-r0 Fixed
alpine/postgresql14(Alpine v3.17) < 14.9-r0 14.9-r0 Fixed
alpine/postgresql14(Alpine v3.18) < 14.9-r0 14.9-r0 Fixed
alpine/postgresql14(Alpine v3.19) < 14.9-r0 14.9-r0 Fixed
alpine/postgresql14(Alpine v3.20) < 14.9-r0 14.9-r0 Fixed
alpine/postgresql15(Alpine v3.17) < 15.4-r0 15.4-r0 Fixed
alpine/postgresql15(Alpine v3.18) < 15.4-r0 15.4-r0 Fixed
alpine/postgresql15(Alpine v3.19) < 15.4-r0 15.4-r0 Fixed
alpine/postgresql15(Alpine v3.20) < 15.4-r0 15.4-r0 Fixed
alpine/postgresql15(Alpine v3.21) < 15.4-r0 15.4-r0 Fixed
alpine/postgresql15(Alpine v3.22) < 15.4-r0 15.4-r0 Fixed
debian/postgresql-15(Debian 12) < 15.5-0+deb12u1; = 15.3-0+deb12u1; = 15.3-1; = 15.4-0+deb12u1 +3 more 15.5-0+deb12u1 Fixed
postgresql >= 15.0, < 15.4 15.4 Fixed
redhat enterprise linux < 8090020231114113548.a75119d5; < 9030020231120082734.rhel9; = 8; = 8.0 +2 more 8090020231114113548.a75119d5, 9030020231120082734.rhel9 Fixed
redhat rhel eus < 8080020231113134015.63b34585; < 9020020231115020618.rhel9 8080020231113134015.63b34585, 9020020231115020618.rhel9 Fixed
debian linux = 12.0 No fix listed Versions listed
redhat rhel els = 6; = 7 No fix listed Versions listed
redhat rhel software collections = 3 No fix listed Versions listed

Affected products

ProductAffected versionsFixed in
debian/postgresql-15(Debian:12) < 15.5-0+deb12u1 15.5-0+deb12u1
debian/postgresql-15(Debian:12) = 15.3-0+deb12u1 No fix listed
debian/postgresql-15(Debian:12) = 15.3-1 No fix listed
debian/postgresql-15(Debian:12) = 15.4-0+deb12u1 No fix listed
debian/postgresql-15(Debian:12) = 15.4-1 No fix listed
debian/postgresql-15(Debian:12) = 15.4-2 No fix listed
debian/postgresql-15(Debian:12) = 15.4-3 No fix listed
redhat enterprise linux < 8090020231114113548.a75119d5 8090020231114113548.a75119d5
redhat rhel eus < 8080020231113134015.63b34585 8080020231113134015.63b34585
redhat enterprise linux < 9030020231120082734.rhel9 9030020231120082734.rhel9
redhat rhel eus < 9020020231115020618.rhel9 9020020231115020618.rhel9
redhat rhel els = 6 No fix listed
redhat rhel els = 7 No fix listed
redhat enterprise linux = 8 No fix listed
redhat enterprise linux = 9 No fix listed
redhat rhel software collections = 3 No fix listed
postgresql >= 15.0, < 15.4 15.4
redhat enterprise linux = 8.0 No fix listed
redhat enterprise linux = 9.0 No fix listed
debian linux = 12.0 No fix listed
alpine/postgresql(Alpine:v3.13) < 13.12-r0 13.12-r0
alpine/postgresql(Alpine:v3.14) < 13.12-r0 13.12-r0
alpine/postgresql12(Alpine:v3.15) < 12.16-r0 12.16-r0
alpine/postgresql12(Alpine:v3.16) < 12.16-r0 12.16-r0
alpine/postgresql12(Alpine:v3.17) < 12.16-r0 12.16-r0
Show 18 more
ProductAffected versionsFixed in
alpine/postgresql12(Alpine:v3.18) < 12.16-r0 12.16-r0
alpine/postgresql13(Alpine:v3.15) < 13.12-r0 13.12-r0
alpine/postgresql13(Alpine:v3.16) < 13.12-r0 13.12-r0
alpine/postgresql13(Alpine:v3.17) < 13.12-r0 13.12-r0
alpine/postgresql13(Alpine:v3.18) < 13.12-r0 13.12-r0
alpine/postgresql13(Alpine:v3.19) < 13.12-r0 13.12-r0
alpine/postgresql14(Alpine:v3.15) < 14.9-r0 14.9-r0
alpine/postgresql14(Alpine:v3.16) < 14.9-r0 14.9-r0
alpine/postgresql14(Alpine:v3.17) < 14.9-r0 14.9-r0
alpine/postgresql14(Alpine:v3.18) < 14.9-r0 14.9-r0
alpine/postgresql14(Alpine:v3.19) < 14.9-r0 14.9-r0
alpine/postgresql14(Alpine:v3.20) < 14.9-r0 14.9-r0
alpine/postgresql15(Alpine:v3.17) < 15.4-r0 15.4-r0
alpine/postgresql15(Alpine:v3.18) < 15.4-r0 15.4-r0
alpine/postgresql15(Alpine:v3.19) < 15.4-r0 15.4-r0
alpine/postgresql15(Alpine:v3.20) < 15.4-r0 15.4-r0
alpine/postgresql15(Alpine:v3.21) < 15.4-r0 15.4-r0
alpine/postgresql15(Alpine:v3.22) < 15.4-r0 15.4-r0

References