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

 

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

Published: May 11, 2023


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

Vulnerability details

The vulnerability allows a remote user to execute arbitrary code on the system.

The vulnerability exists due to improperly imposed security restrictions. A remote database user with   CREATE privilege can bypass protective search_path changes via "CREATE SCHEMA ... schema_element" command and execute arbitrary code on the system.


Affected software

PostgreSQL
Debian Linux
Amazon Linux AMI
Oracle Linux
SUSE Linux Enterprise Server 15
SUSE Linux Enterprise High Performance Computing 15
SUSE Linux Enterprise Server for SAP Applications 15
SUSE Linux Enterprise Server 12
SUSE Linux Enterprise High Performance Computing 12
SUSE Linux Enterprise High Performance Computing LTSS 15
SUSE Linux Enterprise High Performance Computing ESPOS 15
SUSE Linux Enterprise Real Time 15
SUSE Linux Enterprise Desktop 15
SUSE Linux Enterprise Server for SAP Applications 12
SUSE Linux Enterprise Software Development Kit 12
SUSE CaaS Platform
SUSE Manager Retail Branch Server
SUSE Manager Proxy
SUSE Manager Server
SUSE Linux Enterprise Micro
SUSE Enterprise Storage
Red Hat Enterprise Linux for Power, little endian
Red Hat Enterprise Linux for x86_64
Red Hat Enterprise Linux for IBM z Systems
Anolis OS
Red Hat Enterprise Linux for ARM 64
Red Hat Enterprise Linux Server - TUS
Red Hat Enterprise Linux Server - AUS
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
SUSE OpenStack Cloud
SUSE OpenStack Cloud Crowbar
SUSE Linux Enterprise Server 12 SP2 BCL
SUSE Linux Enterprise Server 12 SP4 ESPOS
SUSE Linux Enterprise Server 12 SP4 LTSS
SUSE Linux Enterprise Server 15 SP1 LTSS
SUSE Linux Enterprise High Performance Computing 15 SP1 LTSS
SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS
SUSE Linux Enterprise Server 15 SP2 LTSS
SUSE Linux Enterprise Server 15 SP3 LTSS
Server Applications Module
Basesystem Module
Legacy Module
SUSE Package Hub 15
openSUSE Leap
Ubuntu
openEuler
IBM Security QRadar Network Threat Analytics
IBM Cloud Pak for Watson AIOps
Index Engines CyberSense
EMC Cloud Tiering Appliance
Dell Data Protection Central
IBM Cloud Pak for Multicloud Management
IBM Connect Direct for Microsoft Windows
Red Hat Enterprise Linux Server for Power LE - Update Services for SAP Solutions
postgresql-9.5 (Ubuntu package)
postgresql-client-9.5 (Ubuntu package)
postgres-decoderbufs
pgaudit
pg_repack
postgresql92
postgresql-10 (Ubuntu package)
postgresql-client-10 (Ubuntu package)
postgresql-contrib
postgresql-upgrade-devel
postgresql-upgrade
postgresql-test-rpm-macros
postgresql-test
postgresql-static
postgresql-server-devel
postgresql-server
postgresql-pltcl
postgresql-plpython3
postgresql-plperl
postgresql
postgresql-docs
postgresql-12 (Ubuntu package)
postgresql-client-12 (Ubuntu package)
rh-postgresql12-postgresql (Red Hat package)
postgresql12-docs
postgresql12-debugsource
postgresql12-server-debuginfo
postgresql12-plpython-debuginfo
postgresql12-plpython
postgresql12
postgresql12-contrib-debuginfo
postgresql12-pltcl
postgresql12-server
postgresql12-debuginfo
postgresql12-plperl
postgresql12-pltcl-debuginfo
postgresql12-plperl-debuginfo
postgresql12-contrib
postgresql12-server-devel-debuginfo
postgresql12-server-devel
postgresql12-devel
postgresql12-devel-debuginfo
libpq5-32bit-debuginfo
libpq5-32bit
libpq5-debuginfo
libpq5
libecpg6-debuginfo
libecpg6
postgresql12-llvmjit-devel
postgresql12-test
postgresql12-llvmjit
postgresql12-llvmjit-debuginfo
postgresql-13 (Debian package)
postgresql (Red Hat package)
postgresql13-docs
postgresql13-contrib-debuginfo
postgresql13-debuginfo
postgresql13-plperl-debuginfo
postgresql13-contrib
postgresql13-server-debuginfo
postgresql13-plperl
postgresql13-plpython
postgresql13
postgresql13-pltcl
postgresql13-server
postgresql13-server-devel
postgresql13-server-devel-debuginfo
postgresql13-devel-debuginfo
postgresql13-devel
postgresql13-debugsource
postgresql13-plpython-debuginfo
postgresql13-pltcl-debuginfo
postgresql13-llvmjit-devel
postgresql13-test
postgresql13-llvmjit
postgresql13-llvmjit-debuginfo
libpq-debugsource
libpq-devel
libpq-debuginfo
libpq
rh-postgresql13-postgresql (Red Hat package)
postgresql-14 (Ubuntu package)
postgresql-client-14 (Ubuntu package)
postgresql14-pltcl-debuginfo
postgresql14-devel
postgresql14-plpython-debuginfo
postgresql14-contrib
postgresql14-contrib-debuginfo
postgresql14
postgresql14-server-debuginfo
postgresql14-server
postgresql14-debuginfo
postgresql14-plperl
postgresql14-docs
postgresql14-plpython
postgresql14-pltcl
postgresql14-plperl-debuginfo
postgresql14-server-devel
postgresql14-server-devel-debuginfo
postgresql14-debugsource
postgresql14-devel-debuginfo
postgresql14-llvmjit
postgresql14-llvmjit-devel
postgresql14-llvmjit-debuginfo
postgresql14-test
postgresql15
postgresql-client-15 (Ubuntu package)
postgresql-15 (Ubuntu package)
postgresql-private-libs
postgresql-private-devel
postgresql15-pltcl-debuginfo
postgresql15-plpython-debuginfo
postgresql15-contrib
postgresql15-pltcl
postgresql15-contrib-debuginfo
postgresql15-plperl-debuginfo
postgresql15-server
postgresql15-plpython
postgresql15-docs
postgresql15-debuginfo
postgresql15-server-debuginfo
postgresql15-plperl
postgresql15-devel
libpq5-debuginfo-32bit
postgresql15-server-devel
libecpg6-debuginfo-32bit
libecpg6-32bit
postgresql15-server-devel-debuginfo
postgresql15-devel-debuginfo
postgresql15-debugsource
postgresql15-llvmjit
postgresql15-test
libecpg6-32bit-debuginfo
postgresql15-llvmjit-devel
postgresql15-llvmjit-debuginfo
IBM Cloud Pak for Business Automation
IBM Spectrum Copy Data Management
Isolation Segment
VMware Tanzu Application Service for VMs
IBM Sterling Connect:Direct Web Services
IBM Observability with Instana
IBM Data Risk Manager
VMware Tanzu Operations Manager
IBM Storage Scale System
Juniper Secure Analytics (JSA)
Dell EMC VxRail Appliance
Operational Decision Manager
IBM Security Verify Access

How to mitigate CVE-2023-2454

Install updates from vendor's website.

PostgreSQL - addressed in versions 11.20, 12.15, 13.11, 14.8, 15.3
IBM Security QRadar Network Threat Analytics - update to 1.4.3
IBM Cloud Pak for Multicloud Management - update to 2.3.8
IBM Cloud Pak for Business Automation - addressed in versions 21.0.3.26, 23.0.1.4
postgresql-9.5 (Ubuntu package) - update to Ubuntu Pro (Infra-only)
postgresql-client-9.5 (Ubuntu package) - update to Ubuntu Pro
postgres-decoderbufs - addressed in versions 0.10.0-2, 1.9.7-1.Final
pgaudit - addressed in versions 1.4.0-5, 1.5.0-1, 1.7.0-1
pg_repack - addressed in versions 1.4.6-3, 1.4.8-1
IBM Data Risk Manager - update to 2.0.6.19
IBM Spectrum Copy Data Management - update to 2.2.20.1
VMware Tanzu Operations Manager - update to 2.10.9
Isolation Segment - addressed in versions 2.11.36, 2.13.21, 3.0.14, 4.0.5
VMware Tanzu Application Service for VMs - addressed in versions 2.11.42, 2.13.24, 3.0.14, 4.0.5
IBM Cloud Pak for Watson AIOps - update to 4.1.2
IBM Connect Direct for Microsoft Windows - addressed in versions 6.0.0.4 iFix068, 6.1.0.2 iFix063, 6.2.0.4 iFix037, 6.3.0.0 iFix002
IBM Sterling Connect:Direct Web Services - addressed in versions 6.1.0.19, 6.2.0.17
IBM Storage Scale System - addressed in versions 6.1.2.8, 6.1.9.0
Juniper Secure Analytics (JSA) - update to 7.5.0 UP11 IF03
Dell EMC VxRail Appliance - update to 8.0.101
Index Engines CyberSense - update to 8.4
Operational Decision Manager - addressed in versions 8.10.5.1 Interim fix 49, 8.11.0.1 Interim fix 26, 8.12.0 Interim fix 8
postgresql92 - update to 9.2.24-3.69
IBM Security Verify Access - update to 10.0.7.0
postgresql-10 (Ubuntu package) - update to 10.23-0ubuntu0.18.04.2
postgresql-client-10 (Ubuntu package) - update to 10.23-0ubuntu0.18.04.2
postgresql-contrib - addressed in versions 10.23-2, 12.15-1.0.1, 13.11-1.0.1, 15.3-1.0.1
postgresql-upgrade-devel - addressed in versions 10.23-2, 12.15-1.0.1, 13.11-1.0.1, 15.3-1.0.1
postgresql-upgrade - addressed in versions 10.23-2, 12.15-1.0.1, 13.11-1.0.1, 15.3-1.0.1
postgresql-test-rpm-macros - addressed in versions 10.23-2, 12.15-1.0.1, 13.11-1.0.1, 15.3-1.0.1
postgresql-test - addressed in versions 10.23-2, 12.15-1.0.1, 13.11-1.0.1, 15.3-1.0.1
postgresql-static - addressed in versions 10.23-2, 12.15-1.0.1, 13.11-1.0.1, 15.3-1.0.1
postgresql-server-devel - addressed in versions 10.23-2, 12.15-1.0.1, 13.11-1.0.1, 15.3-1.0.1
postgresql-server - addressed in versions 10.23-2, 12.15-1.0.1, 13.11-1.0.1, 15.3-1.0.1
postgresql-pltcl - addressed in versions 10.23-2, 12.15-1.0.1, 13.11-1.0.1, 15.3-1.0.1
postgresql-plpython3 - addressed in versions 10.23-2, 12.15-1.0.1, 13.11-1.0.1, 15.3-1.0.1
postgresql-plperl - addressed in versions 10.23-2, 12.15-1.0.1, 13.11-1.0.1, 15.3-1.0.1
postgresql - addressed in versions 10.23-2, 12.15-1.0.1, 13.11-1.0.1, 15.3-1.0.1
postgresql-docs - addressed in versions 10.23-2, 12.15-1.0.1, 13.11-1.0.1, 15.3-1.0.1
postgresql-12 (Ubuntu package) - update to 12.15-0ubuntu0.20.04.1
postgresql-client-12 (Ubuntu package) - update to 12.15-0ubuntu0.20.04.1
rh-postgresql12-postgresql (Red Hat package) - update to 12.15-1.el7
postgresql12-docs - addressed in versions 12.15-3.39.1, 12.15-150100.3.41.1, 12.15-150200.8.44.1
postgresql12-debugsource - addressed in versions 12.15-3.39.1, 12.15-150100.3.41.1, 12.15-150200.8.44.1
postgresql12-server-debuginfo - addressed in versions 12.15-3.39.1, 12.15-150100.3.41.1, 12.15-150200.8.44.1
postgresql12-plpython-debuginfo - addressed in versions 12.15-3.39.1, 12.15-150100.3.41.1, 12.15-150200.8.44.1
postgresql12-plpython - addressed in versions 12.15-3.39.1, 12.15-150100.3.41.1, 12.15-150200.8.44.1
postgresql12 - addressed in versions 12.15-3.39.1, 12.15-150100.3.41.1, 12.15-150200.8.44.1
postgresql12-contrib-debuginfo - addressed in versions 12.15-3.39.1, 12.15-150100.3.41.1, 12.15-150200.8.44.1
postgresql12-pltcl - addressed in versions 12.15-3.39.1, 12.15-150100.3.41.1, 12.15-150200.8.44.1
postgresql12-server - addressed in versions 12.15-3.39.1, 12.15-150100.3.41.1, 12.15-150200.8.44.1
postgresql12-debuginfo - addressed in versions 12.15-3.39.1, 12.15-150100.3.41.1, 12.15-150200.8.44.1
postgresql12-plperl - addressed in versions 12.15-3.39.1, 12.15-150100.3.41.1, 12.15-150200.8.44.1
postgresql12-pltcl-debuginfo - addressed in versions 12.15-3.39.1, 12.15-150100.3.41.1, 12.15-150200.8.44.1
postgresql12-plperl-debuginfo - addressed in versions 12.15-3.39.1, 12.15-150100.3.41.1, 12.15-150200.8.44.1
postgresql12-contrib - addressed in versions 12.15-3.39.1, 12.15-150100.3.41.1, 12.15-150200.8.44.1
postgresql12-server-devel-debuginfo - addressed in versions 12.15-3.39.1, 12.15-150100.3.41.1, 12.15-150200.8.44.1
postgresql12-server-devel - addressed in versions 12.15-3.39.1, 12.15-150100.3.41.1, 12.15-150200.8.44.1
postgresql12-devel - addressed in versions 12.15-3.39.1, 12.15-150100.3.41.1, 12.15-150200.8.44.1
postgresql12-devel-debuginfo - addressed in versions 12.15-3.39.1, 12.15-150100.3.41.1, 12.15-150200.8.44.1
libpq5-32bit-debuginfo - addressed in versions 12.15-150100.3.41.1, 15.3-150200.5.9.1
libpq5-32bit - addressed in versions 12.15-150100.3.41.1, 15.3-3.9.1, 15.3-150200.5.9.1
libpq5-debuginfo - addressed in versions 12.15-150100.3.41.1, 15.3-3.9.1, 15.3-150200.5.9.1
libpq5 - addressed in versions 12.15-150100.3.41.1, 15.3-3.9.1, 15.3-150200.5.9.1
libecpg6-debuginfo - addressed in versions 12.15-150100.3.41.1, 15.3-3.9.1, 15.3-150200.5.9.1
libecpg6 - addressed in versions 12.15-150100.3.41.1, 15.3-3.9.1, 15.3-150200.5.9.1
postgresql12-llvmjit-devel - update to 12.15-150200.8.44.1
postgresql12-test - update to 12.15-150200.8.44.1
postgresql12-llvmjit - update to 12.15-150200.8.44.1
postgresql12-llvmjit-debuginfo - update to 12.15-150200.8.44.1
EMC Cloud Tiering Appliance - addressed in versions 13.1.0.2.33, 13.2.0.2.24
postgresql-13 (Debian package) - update to 13.11-0+deb11u1
postgresql (Red Hat package) - addressed in versions 13.11-1.el9_2, 13.13-1.el9_0
postgresql13-docs - addressed in versions 13.11-3.33.1, 13.11-150200.5.40.1
postgresql13-contrib-debuginfo - addressed in versions 13.11-3.33.1, 13.11-150200.5.40.1
postgresql13-debuginfo - addressed in versions 13.11-3.33.1, 13.11-150200.5.40.1
postgresql13-plperl-debuginfo - addressed in versions 13.11-3.33.1, 13.11-150200.5.40.1
postgresql13-contrib - addressed in versions 13.11-3.33.1, 13.11-150200.5.40.1
postgresql13-server-debuginfo - addressed in versions 13.11-3.33.1, 13.11-150200.5.40.1
postgresql13-plperl - addressed in versions 13.11-3.33.1, 13.11-150200.5.40.1
postgresql13-plpython - addressed in versions 13.11-3.33.1, 13.11-150200.5.40.1
postgresql13 - addressed in versions 13.11-3.33.1, 13.11-150200.5.40.1
postgresql13-pltcl - addressed in versions 13.11-3.33.1, 13.11-150200.5.40.1
postgresql13-server - addressed in versions 13.11-3.33.1, 13.11-150200.5.40.1
postgresql13-server-devel - addressed in versions 13.11-3.33.1, 13.11-150200.5.40.1
postgresql13-server-devel-debuginfo - addressed in versions 13.11-3.33.1, 13.11-150200.5.40.1
postgresql13-devel-debuginfo - addressed in versions 13.11-3.33.1, 13.11-150200.5.40.1
postgresql13-devel - addressed in versions 13.11-3.33.1, 13.11-150200.5.40.1
postgresql13-debugsource - addressed in versions 13.11-3.33.1, 13.11-150200.5.40.1
postgresql13-plpython-debuginfo - addressed in versions 13.11-3.33.1, 13.11-150200.5.40.1
postgresql13-pltcl-debuginfo - addressed in versions 13.11-3.33.1, 13.11-150200.5.40.1
postgresql13-llvmjit-devel - update to 13.11-150200.5.40.1
postgresql13-test - update to 13.11-150200.5.40.1
postgresql13-llvmjit - update to 13.11-150200.5.40.1
postgresql13-llvmjit-debuginfo - update to 13.11-150200.5.40.1
libpq-debugsource - update to 13.12-1
libpq-devel - update to 13.12-1
libpq-debuginfo - update to 13.12-1
libpq - update to 13.12-1
rh-postgresql13-postgresql (Red Hat package) - update to 13.13-1.el7
postgresql-14 (Ubuntu package) - addressed in versions 14.8-0ubuntu0.22.04.1, 14.8-0ubuntu0.22.10.1
postgresql-client-14 (Ubuntu package) - addressed in versions 14.8-0ubuntu0.22.04.1, 14.8-0ubuntu0.22.10.1
postgresql14-pltcl-debuginfo - addressed in versions 14.8-3.23.1, 14.8-150200.5.26.1
postgresql14-devel - addressed in versions 14.8-3.23.1, 14.8-150200.5.26.1
postgresql14-plpython-debuginfo - addressed in versions 14.8-3.23.1, 14.8-150200.5.26.1
postgresql14-contrib - addressed in versions 14.8-3.23.1, 14.8-150200.5.26.1
postgresql14-contrib-debuginfo - addressed in versions 14.8-3.23.1, 14.8-150200.5.26.1
postgresql14 - addressed in versions 14.8-3.23.1, 14.8-150200.5.26.1
postgresql14-server-debuginfo - addressed in versions 14.8-3.23.1, 14.8-150200.5.26.1
postgresql14-server - addressed in versions 14.8-3.23.1, 14.8-150200.5.26.1
postgresql14-debuginfo - addressed in versions 14.8-3.23.1, 14.8-150200.5.26.1
postgresql14-plperl - addressed in versions 14.8-3.23.1, 14.8-150200.5.26.1
postgresql14-docs - addressed in versions 14.8-3.23.1, 14.8-150200.5.26.1
postgresql14-plpython - addressed in versions 14.8-3.23.1, 14.8-150200.5.26.1
postgresql14-pltcl - addressed in versions 14.8-3.23.1, 14.8-150200.5.26.1
postgresql14-plperl-debuginfo - addressed in versions 14.8-3.23.1, 14.8-150200.5.26.1
postgresql14-server-devel - addressed in versions 14.8-3.23.1, 14.8-150200.5.26.1
postgresql14-server-devel-debuginfo - addressed in versions 14.8-3.23.1, 14.8-150200.5.26.1
postgresql14-debugsource - addressed in versions 14.8-3.23.1, 14.8-150200.5.26.1
postgresql14-devel-debuginfo - addressed in versions 14.8-3.23.1, 14.8-150200.5.26.1
postgresql14-llvmjit - update to 14.8-150200.5.26.1
postgresql14-llvmjit-devel - update to 14.8-150200.5.26.1
postgresql14-llvmjit-debuginfo - update to 14.8-150200.5.26.1
postgresql14-test - update to 14.8-150200.5.26.1
postgresql15 - update to 15.0-1
postgresql-client-15 (Ubuntu package) - update to 15.3-0ubuntu0.23.04.1
postgresql-15 (Ubuntu package) - update to 15.3-0ubuntu0.23.04.1
postgresql-private-libs - update to 15.3-1.0.1
postgresql-private-devel - update to 15.3-1.0.1
postgresql15-pltcl-debuginfo - addressed in versions 15.3-3.9.1, 15.3-150200.5.9.1
postgresql15-plpython-debuginfo - addressed in versions 15.3-3.9.1, 15.3-150200.5.9.1
postgresql15-contrib - addressed in versions 15.3-3.9.1, 15.3-150200.5.9.1
postgresql15-pltcl - addressed in versions 15.3-3.9.1, 15.3-150200.5.9.1
postgresql15-contrib-debuginfo - addressed in versions 15.3-3.9.1, 15.3-150200.5.9.1
postgresql15 - addressed in versions 15.3-3.9.1, 15.3-150200.5.9.1
postgresql15-plperl-debuginfo - addressed in versions 15.3-3.9.1, 15.3-150200.5.9.1
postgresql15-server - addressed in versions 15.3-3.9.1, 15.3-150200.5.9.1
postgresql15-plpython - addressed in versions 15.3-3.9.1, 15.3-150200.5.9.1
postgresql15-docs - addressed in versions 15.3-3.9.1, 15.3-150200.5.9.1
postgresql15-debuginfo - addressed in versions 15.3-3.9.1, 15.3-150200.5.9.1
postgresql15-server-debuginfo - addressed in versions 15.3-3.9.1, 15.3-150200.5.9.1
postgresql15-plperl - addressed in versions 15.3-3.9.1, 15.3-150200.5.9.1
postgresql15-devel - addressed in versions 15.3-3.9.1, 15.3-150200.5.9.1
libpq5-debuginfo-32bit - update to 15.3-3.9.1
postgresql15-server-devel - addressed in versions 15.3-3.9.1, 15.3-150200.5.9.1
libecpg6-debuginfo-32bit - update to 15.3-3.9.1
libecpg6-32bit - addressed in versions 15.3-3.9.1, 15.3-150200.5.9.1
postgresql15-server-devel-debuginfo - addressed in versions 15.3-3.9.1, 15.3-150200.5.9.1
postgresql15-devel-debuginfo - addressed in versions 15.3-3.9.1, 15.3-150200.5.9.1
postgresql15-debugsource - addressed in versions 15.3-3.9.1, 15.3-150200.5.9.1
postgresql15-llvmjit - update to 15.3-150200.5.9.1
postgresql15-test - update to 15.3-150200.5.9.1
libecpg6-32bit-debuginfo - update to 15.3-150200.5.9.1
postgresql15-llvmjit-devel - update to 15.3-150200.5.9.1
postgresql15-llvmjit-debuginfo - update to 15.3-150200.5.9.1
Dell Data Protection Central - update to 19.11.0-2
IBM Observability with Instana - update to 265

External References

Related Security Bulletins