Permissions, Privileges, and Access Controls in PostgreSQL - CVE-2023-39418

 

Permissions, Privileges, and Access Controls in PostgreSQL - CVE-2023-39418

Published: August 11, 2023 / Updated: January 30, 2024


Vulnerability identifier: #VU79455
CSH Severity: Low
CVSS v4: 2.3 [CVSS:4.0/AV:N/AC:L/AT:P/PR:L/UI:N/VC:L/VI:L/VA:N/SC:N/SI:N/SA:N]
CVE-ID: CVE-2023-39418
CWE-ID: CWE-264
Exploitation vector: Remote access
Exploit availability: No public exploit available

Vulnerability details

The vulnerability allows a remote user to escalate privileges within the application.

The vulnerability exists due to the MERGE command does not properly enforce UPDATE or SELECT row security policies. A remote user can read or update protected data.


Affected software

PostgreSQL
Amazon Linux AMI
Debian Linux
SUSE Linux Enterprise Server for SAP Applications 15
SUSE Linux Enterprise Server 15
SUSE Linux Enterprise Real Time 15
SUSE Linux Enterprise High Performance Computing 15
SUSE Linux Enterprise Desktop 15
SUSE Linux Enterprise Server 12
SUSE Linux Enterprise High Performance Computing 12
SUSE Linux Enterprise Software Development Kit 12
SUSE Linux Enterprise Server for SAP Applications 12
SUSE Manager Retail Branch Server
SUSE Manager Server
SUSE Manager Proxy
SUSE Linux Enterprise Micro
Anolis OS
Red Hat Enterprise Linux for ARM 64
Red Hat Enterprise Linux for Power, little endian
Red Hat Enterprise Linux for IBM z Systems
Red Hat Enterprise Linux for x86_64
Red Hat Enterprise Linux for Power, little endian - Extended Update Support
Red Hat Enterprise Linux for ARM 64 - Extended Update Support
Red Hat Enterprise Linux for IBM z Systems - Extended Update Support
Red Hat Enterprise Linux for x86_64 - Extended Update Support
Red Hat Enterprise Linux Server - AUS
Server Applications Module
Basesystem Module
SUSE Package Hub 15
openSUSE Leap
Ubuntu
openEuler
watsonx Orchestrate Cartridge for IBM Cloud Pak for Data
watsonx Assistant Cartridge
watsonx Orchestrate with watsonx Assistant Cartridge - Assistant Builder Component
Dell Policy Manager for Secure Connect Gateway (SCG)
Index Engines CyberSense
Red Hat Enterprise Linux Server for Power LE - Update Services for SAP Solutions
Red Hat Enterprise Linux Server for x86_64 - Update Services for SAP Solutions
pg_repack
pgaudit
postgres-decoderbufs
ghostscript-tools-printing
ghostscript
ghostscript-gtk
ghostscript-tools-dvipdf
ghostscript-tools-fonts
ghostscript-x11
libgs
libgs-devel
ghostscript-doc
postgresql-12 (Ubuntu package)
postgresql-client-12 (Ubuntu package)
libpq-devel
libpq-debuginfo
libpq-debugsource
libpq
postgresql-client-14 (Ubuntu package)
postgresql-14 (Ubuntu package)
postgresql-client-15 (Ubuntu package)
postgresql-15 (Ubuntu package)
postgresql-static
postgresql15
postgresql-test-rpm-macros
postgresql-upgrade-devel
postgresql-upgrade
postgresql
postgresql-contrib
postgresql-docs
postgresql-plperl
postgresql-plpython3
postgresql-pltcl
postgresql-private-devel
postgresql-private-libs
postgresql-server
postgresql-server-devel
postgresql-test
postgresql15-server-devel-debuginfo
postgresql15-server
libpq5-32bit
libecpg6-32bit
libpq5-debuginfo-32bit
postgresql15-docs
postgresql15-debuginfo
libecpg6
postgresql15-plpython-debuginfo
postgresql15-server-debuginfo
libpq5-debuginfo
postgresql15-plpython
postgresql15-plperl-debuginfo
postgresql15-contrib-debuginfo
libecpg6-debuginfo-32bit
postgresql15-pltcl-debuginfo
postgresql15-plperl
postgresql15-pltcl
postgresql15-contrib
libecpg6-debuginfo
libpq5
postgresql15-debugsource
postgresql15-devel
postgresql15-devel-debuginfo
postgresql15-server-devel
libpq5-32bit-debuginfo
postgresql15-llvmjit-debuginfo
postgresql15-test
postgresql15-llvmjit
postgresql15-llvmjit-devel
libecpg6-32bit-debuginfo
postgresql-15 (Debian package)
IBM Watson Speech Services Cartridge for IBM Cloud Pak for Data
IBM Sterling Connect:Direct Web Services
NetWorker
IBM Cloud Pak for Business Automation
Dell EMC VxRail Appliance

How to mitigate CVE-2023-39418

Install updates from vendor's website.

PostgreSQL - update to 15.4
watsonx Orchestrate Cartridge for IBM Cloud Pak for Data - update to 5.2
pg_repack - update to 1.4.8-1
pgaudit - update to 1.7.0-1
postgres-decoderbufs - update to 1.9.7-1.Final
IBM Watson Speech Services Cartridge for IBM Cloud Pak for Data - update to 5.1.1
watsonx Assistant Cartridge - update to 5.1.1
watsonx Orchestrate with watsonx Assistant Cartridge - Assistant Builder Component - update to 5.1.1
Dell Policy Manager for Secure Connect Gateway (SCG) - update to 5.20
IBM Sterling Connect:Direct Web Services - addressed in versions 6.1.0.23, 6.2.0.22, 6.3.0.6
Dell EMC VxRail Appliance - update to 8.0.120
Index Engines CyberSense - update to 8.4
ghostscript-tools-printing - update to 10.01.2-2
ghostscript - update to 10.01.2-2
ghostscript-gtk - update to 10.01.2-2
ghostscript-tools-dvipdf - update to 10.01.2-2
ghostscript-tools-fonts - update to 10.01.2-2
ghostscript-x11 - update to 10.01.2-2
libgs - update to 10.01.2-2
libgs-devel - update to 10.01.2-2
ghostscript-doc - update to 10.01.2-2
postgresql-12 (Ubuntu package) - update to 12.16-0ubuntu0.20.04.1
postgresql-client-12 (Ubuntu package) - update to 12.16-0ubuntu0.20.04.1
libpq-devel - update to 13.12-1
libpq-debuginfo - update to 13.12-1
libpq-debugsource - update to 13.12-1
libpq - update to 13.12-1
postgresql-client-14 (Ubuntu package) - update to 14.9-0ubuntu0.22.04.1
postgresql-14 (Ubuntu package) - update to 14.9-0ubuntu0.22.04.1
postgresql-client-15 (Ubuntu package) - update to 15.4-0ubuntu0.23.04.1
postgresql-15 (Ubuntu package) - update to 15.4-0ubuntu0.23.04.1
postgresql-static - addressed in versions 15.4-1, 15.5-1.0.1
postgresql15 - update to 15.4-1
postgresql-test-rpm-macros - addressed in versions 15.4-1, 15.5-1.0.1
postgresql-upgrade-devel - addressed in versions 15.4-1, 15.5-1.0.1
postgresql-upgrade - addressed in versions 15.4-1, 15.5-1.0.1
postgresql - addressed in versions 15.4-1, 15.5-1.0.1
postgresql-contrib - addressed in versions 15.4-1, 15.5-1.0.1
postgresql-docs - addressed in versions 15.4-1, 15.5-1.0.1
postgresql-plperl - addressed in versions 15.4-1, 15.5-1.0.1
postgresql-plpython3 - addressed in versions 15.4-1, 15.5-1.0.1
postgresql-pltcl - addressed in versions 15.4-1, 15.5-1.0.1
postgresql-private-devel - addressed in versions 15.4-1, 15.5-1.0.1
postgresql-private-libs - addressed in versions 15.4-1, 15.5-1.0.1
postgresql-server - addressed in versions 15.4-1, 15.5-1.0.1
postgresql-server-devel - addressed in versions 15.4-1, 15.5-1.0.1
postgresql-test - addressed in versions 15.4-1, 15.5-1.0.1
postgresql15-server-devel-debuginfo - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
postgresql15-server - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
libpq5-32bit - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
libecpg6-32bit - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
libpq5-debuginfo-32bit - update to 15.4-3.12.1
postgresql15-docs - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
postgresql15-debuginfo - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
libecpg6 - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
postgresql15-plpython-debuginfo - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
postgresql15-server-debuginfo - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
libpq5-debuginfo - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
postgresql15-plpython - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
postgresql15-plperl-debuginfo - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
postgresql15-contrib-debuginfo - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
libecpg6-debuginfo-32bit - update to 15.4-3.12.1
postgresql15-pltcl-debuginfo - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
postgresql15-plperl - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
postgresql15 - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
postgresql15-pltcl - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
postgresql15-contrib - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
libecpg6-debuginfo - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
libpq5 - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
postgresql15-debugsource - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
postgresql15-devel - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
postgresql15-devel-debuginfo - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
postgresql15-server-devel - addressed in versions 15.4-3.12.1, 15.4-150200.5.12.1
libpq5-32bit-debuginfo - update to 15.4-150200.5.12.1
postgresql15-llvmjit-debuginfo - update to 15.4-150200.5.12.1
postgresql15-test - update to 15.4-150200.5.12.1
postgresql15-llvmjit - update to 15.4-150200.5.12.1
postgresql15-llvmjit-devel - update to 15.4-150200.5.12.1
libecpg6-32bit-debuginfo - update to 15.4-150200.5.12.1
postgresql-15 (Debian package) - update to 15.5-0+deb12u1
NetWorker - addressed in versions 19.9.0.4, 19.10.0.0
IBM Cloud Pak for Business Automation - addressed in versions 21.0.3.31, 23.0.2.3

External References

Related Security Bulletins