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.
| Package | Affected | Fixed in | Status |
|---|---|---|---|
| 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
| Product | Affected versions | Fixed 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
| Product | Affected versions | Fixed 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
- Debian Security Tracker CVE-2023-39418 vendor-advisory
- RHSA-2023:7785 third-party-advisory vendor-advisory
- RHSA-2023:7883 third-party-advisory vendor-advisory
- RHSA-2023:7884 third-party-advisory vendor-advisory
- RHSA-2023:7885 third-party-advisory vendor-advisory
- access.redhat.com third-party-advisory vdb-entry
- RHBZ#2228112 issue-tracking patch third-party-advisory
- git.postgresql.org mailing-list patch
- www.postgresql.org vendor-advisory
- security.netapp.com
- www.debian.org
- security.alpinelinux.org vendor-advisory
- ENISA EUVD EUVD-2023-43142 third-party-advisory