Vulnerability · Published Aug 11, 2023 · Assigned by redhat
CVE-2023-39418Postgresql: merge fails to enforce update or select row security policies
Low 3.1
In plain English
A low-severity security flaw in Red Hat Enterprise Linux 6 from Red Hat. There are no confirmed reports of exploitation so far. The chance it is exploited in the next 30 days is estimated at 1.1% (higher than 65% of all known vulnerabilities). Fixed versions are available - upgrade the affected package.
Severity (CVSS 3.1)3.1Low
Exploit odds (30 days)1.1%top 34.6% of all CVEs
Exploited in the wildNo reportsCISA SSVC: none
Attack toolingNoneno public tooling known
Official 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.
Affected packages & fixed versions
| Ecosystem | Package | Fixed in | Advisory |
|---|---|---|---|
| AlmaLinux:8 | pg_repack | 1.4.8-1.module_el8.8.0+3487+43ec1b9f | ALSA-2023:7884 |
| AlmaLinux:9 | pg_repack | 1.4.8-1.module_el9.2.0+22+09653793 | ALSA-2023:7785 |
| AlmaLinux:8 | pgaudit | 1.7.0-1.module_el8.8.0+3487+43ec1b9f | ALSA-2023:7884 |
| AlmaLinux:9 | pgaudit | 1.7.0-1.module_el9.2.0+22+09653793 | ALSA-2023:7785 |
| AlmaLinux:8 | postgres-decoderbufs | 1.9.7-1.Final.module_el8.8.0+3487+43ec1b9f | ALSA-2023:7884 |
| AlmaLinux:9 | postgres-decoderbufs | 1.9.7-1.Final.module_el9.2.0+22+09653793 | ALSA-2023:7785 |
| AlmaLinux:8 | postgresql | 15.5-1.module_el8.9.0+3706+885c732e | ALSA-2023:7884 |
| AlmaLinux:9 | postgresql | 15.5-1.module_el9.3.0+52+21733919 | ALSA-2023:7785 |
| AlmaLinux:8 | postgresql-contrib | 15.5-1.module_el8.9.0+3706+885c732e | ALSA-2023:7884 |
| AlmaLinux:9 | postgresql-contrib | 15.5-1.module_el9.3.0+52+21733919 | ALSA-2023:7785 |
| AlmaLinux:8 | postgresql-docs | 15.5-1.module_el8.9.0+3706+885c732e | ALSA-2023:7884 |
| AlmaLinux:9 | postgresql-docs | 15.5-1.module_el9.3.0+52+21733919 | ALSA-2023:7785 |
| AlmaLinux:8 | postgresql-plperl | 15.5-1.module_el8.9.0+3706+885c732e | ALSA-2023:7884 |
| AlmaLinux:9 | postgresql-plperl | 15.5-1.module_el9.3.0+52+21733919 | ALSA-2023:7785 |
| AlmaLinux:8 | postgresql-plpython3 | 15.5-1.module_el8.9.0+3706+885c732e | ALSA-2023:7884 |
| AlmaLinux:9 | postgresql-plpython3 | 15.5-1.module_el9.3.0+52+21733919 | ALSA-2023:7785 |
| AlmaLinux:8 | postgresql-pltcl | 15.5-1.module_el8.9.0+3706+885c732e | ALSA-2023:7884 |
| AlmaLinux:9 | postgresql-pltcl | 15.5-1.module_el9.3.0+52+21733919 | ALSA-2023:7785 |
| AlmaLinux:8 | postgresql-private-devel | 15.5-1.module_el8.9.0+3706+885c732e | ALSA-2023:7884 |
| AlmaLinux:9 | postgresql-private-devel | 15.5-1.module_el9.3.0+52+21733919 | ALSA-2023:7785 |
| AlmaLinux:8 | postgresql-private-libs | 15.5-1.module_el8.9.0+3706+885c732e | ALSA-2023:7884 |
| AlmaLinux:9 | postgresql-private-libs | 15.5-1.module_el9.3.0+52+21733919 | ALSA-2023:7785 |
| AlmaLinux:8 | postgresql-server | 15.5-1.module_el8.9.0+3706+885c732e | ALSA-2023:7884 |
| AlmaLinux:9 | postgresql-server | 15.5-1.module_el9.3.0+52+21733919 | ALSA-2023:7785 |
| AlmaLinux:8 | postgresql-server-devel | 15.5-1.module_el8.9.0+3706+885c732e | ALSA-2023:7884 |
| AlmaLinux:9 | postgresql-server-devel | 15.5-1.module_el9.3.0+52+21733919 | ALSA-2023:7785 |
| AlmaLinux:8 | postgresql-static | 15.5-1.module_el8.9.0+3706+885c732e | ALSA-2023:7884 |
| AlmaLinux:9 | postgresql-static | 15.5-1.module_el9.3.0+52+21733919 | ALSA-2023:7785 |
| AlmaLinux:8 | postgresql-test | 15.5-1.module_el8.9.0+3706+885c732e | ALSA-2023:7884 |
| AlmaLinux:9 | postgresql-test | 15.5-1.module_el9.3.0+52+21733919 | ALSA-2023:7785 |
| AlmaLinux:8 | postgresql-test-rpm-macros | 15.5-1.module_el8.9.0+3706+885c732e | ALSA-2023:7884 |
| AlmaLinux:9 | postgresql-test-rpm-macros | 15.5-1.module_el9.3.0+52+21733919 | ALSA-2023:7785 |
| AlmaLinux:8 | postgresql-upgrade | 15.5-1.module_el8.9.0+3706+885c732e | ALSA-2023:7884 |
| AlmaLinux:9 | postgresql-upgrade | 15.5-1.module_el9.3.0+52+21733919 | ALSA-2023:7785 |
| AlmaLinux:8 | postgresql-upgrade-devel | 15.5-1.module_el8.9.0+3706+885c732e | ALSA-2023:7884 |
| AlmaLinux:9 | postgresql-upgrade-devel | 15.5-1.module_el9.3.0+52+21733919 | ALSA-2023:7785 |
| Alpine:v3.20 | postgresql14 | 14.9-r0 | ALPINE-CVE-2023-39418 |
| Alpine:v3.20 | postgresql15 | 15.4-r0 | ALPINE-CVE-2023-39418 |
| Alpine:v3.21 | postgresql15 | 15.4-r0 | ALPINE-CVE-2023-39418 |
| Alpine:v3.22 | postgresql15 | 15.4-r0 | ALPINE-CVE-2023-39418 |
| Debian:12 | postgresql-15 | 15.5-0+deb12u1 | DSA-5553-1 |
| Debian:12 | postgresql-15 | 15.5-0+deb12u1 | DEBIAN-CVE-2023-39418 |
| Rocky Linux:8 | pg_repack | 0:1.4.8-1.module+el8.10.0+1858+fcc46a79 | RLSA-2023:7884 |
| Rocky Linux:8 | pg_repack | 0:1.4.8-1.module+el8.10.0+1622+bd25b19c | RLSA-2023:7884 |
| Rocky Linux:8 | pg_repack | 0:1.4.8-1.module+el8.9.0+1525+fc91df60 | RLSA-2023:7884 |
| Rocky Linux:8 | pg_repack | 0:1.4.8-1.module+el8.10.0+40056+df351139 | RLSA-2023:7884 |
| Rocky Linux:8 | pgaudit | 0:1.7.0-1.module+el8.10.0+40056+df351139 | RLSA-2023:7884 |
| Rocky Linux:8 | pgaudit | 0:1.7.0-1.module+el8.9.0+1525+fc91df60 | RLSA-2023:7884 |
| Rocky Linux:9 | pgaudit | 0:1.7.0-1.module+el9.5.0+30637+4391fcca | RLSA-2023:7785 |
| Rocky Linux:8 | postgres-decoderbufs | 0:1.9.7-1.Final.module+el8.9.0+1525+fc91df60 | RLSA-2023:7884 |
| Rocky Linux:8 | postgres-decoderbufs | 0:1.9.7-1.Final.module+el8.10.0+40056+df351139 | RLSA-2023:7884 |
| Rocky Linux:9 | postgres-decoderbufs | 0:1.9.7-1.Final.module+el9.5.0+30637+4391fcca | RLSA-2023:7785 |
Affected products (as reported)
| Vendor | Product | Versions |
|---|---|---|
| Red Hat | Red Hat Enterprise Linux 8 | see references |
| Red Hat | Red Hat Enterprise Linux 8.8 Extended Update Support | see references |
| Red Hat | Red Hat Enterprise Linux 9 | see references |
| Red Hat | Red Hat Enterprise Linux 9.2 Extended Update Support | see references |
| Red Hat | Red Hat Enterprise Linux 6 | see references |
| Red Hat | Red Hat Enterprise Linux 7 | see references |
| Red Hat | Red Hat Enterprise Linux 8 | see references |
| Red Hat | Red Hat Enterprise Linux 8 | see references |
| Red Hat | Red Hat Enterprise Linux 8 | see references |
| Red Hat | Red Hat Enterprise Linux 9 | see references |
| Red Hat | Red Hat Software Collections | see references |
| Red Hat | Red Hat Software Collections | see references |
| Red Hat | Red Hat Software Collections | see references |
Weakness: CWE-1220 · Vector: CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:N/I:L/A:N
References
- RHSA-2023:7785 vendor-advisory, x_refsource_REDHAT
- RHSA-2023:7883 vendor-advisory, x_refsource_REDHAT
- RHSA-2023:7884 vendor-advisory, x_refsource_REDHAT
- RHSA-2023:7885 vendor-advisory, x_refsource_REDHAT
- https://access.redhat.com/security/cve/CVE-2023-39418 vdb-entry, x_refsource_REDHAT
- RHBZ#2228112 issue-tracking, x_refsource_REDHAT
- https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=cb2ae5741f2458a474ed3c31458d242e678ff229
- https://www.postgresql.org/support/security/CVE-2023-39418/
- https://security.netapp.com/advisory/ntap-20230915-0002/ x_transferred
- https://www.debian.org/security/2023/dsa-5553 x_transferred