Unrated severityNVD Advisory· Published Aug 11, 2023· Updated Mar 12, 2026
Postgresql: extension script @substitutions@ within quoting allow sql injection
CVE-2023-39417
Description
IN THE EXTENSION SCRIPT, a SQL Injection vulnerability was found in PostgreSQL if it uses @extowner@, @extschema@, or @extschema:...@ inside a quoting construct (dollar quoting, '', or ""). If an administrator has installed files of a vulnerable, trusted, non-bundled extension, an attacker with database-level CREATE privilege can execute arbitrary code as the bootstrap superuser.
AI Insight
LLM-synthesized narrative grounded in this CVE's description and references.
Affected products
82- Red Hat/RHACS-3.74-RHEL-8v5cpe:/a:redhat:advanced_cluster_security:3.74::el8Range: 3.74.8-9
- Red Hat/RHACS-4.1-RHEL-8v5cpe:/a:redhat:advanced_cluster_security:4.1::el8Range: 4.1.6-6
- cpe:/a:redhat:advanced_cluster_security:4.2::el8Range: 4.2.4-7
cpe:/a:redhat:enterprise_linux:8::appstream+ 5 more
- cpe:/a:redhat:enterprise_linux:8::appstreamrange: 8090020231114113548.a75119d5
- cpe:/a:redhat:enterprise_linux:9::appstreamrange: 9030020231120082734.rhel9
- cpe:/a:redhat:enterprise_linux:9::crbrange: 0:13.13-1.el9_3
- cpe:/o:redhat:enterprise_linux:6
- cpe:/o:redhat:enterprise_linux:7
- cpe:/o:redhat:enterprise_linux:8
- Red Hat/Red Hat Enterprise Linux 8.6 Extended Update Supportv5cpe:/a:redhat:rhel_eus:8.6::appstreamRange: 8060020231128165328.ad008a3a
- Red Hat/Red Hat Enterprise Linux 8.8 Extended Update Supportv5cpe:/a:redhat:rhel_eus:8.8::appstreamRange: 8080020231113134015.63b34585
- Red Hat/Red Hat Enterprise Linux 9.0 Extended Update Supportv5cpe:/a:redhat:rhel_eus:9.0::appstreamRange: 0:13.13-1.el9_0
- Red Hat/Red Hat Enterprise Linux 9.2 Extended Update Supportv5cpe:/a:redhat:rhel_eus:9.2::appstreamRange: 9020020231115020618.rhel9
- cpe:/a:redhat:rhel_software_collections:3
- Red Hat/Red Hat Software Collections for Red Hat Enterprise Linux 7v5cpe:/a:redhat:rhel_software_collections:3::el7Range: 0:13.13-1.el7
cpe:/a:redhat:rhel_tus:8.2::appstream+ 1 more
- cpe:/a:redhat:rhel_tus:8.2::appstreamrange: 8020020231128165246.4cda2c84
- cpe:/a:redhat:rhel_tus:8.4::appstreamrange: 8040020231127154806.522a0ee4
- osv-coords64 versionspkg:bitnami/postgresqlpkg:rpm/almalinux/pgauditpkg:rpm/almalinux/pg_repackpkg:rpm/almalinux/postgres-decoderbufspkg:rpm/almalinux/postgresqlpkg:rpm/almalinux/postgresql-contribpkg:rpm/almalinux/postgresql-docspkg:rpm/almalinux/postgresql-plperlpkg:rpm/almalinux/postgresql-plpython3pkg:rpm/almalinux/postgresql-pltclpkg:rpm/almalinux/postgresql-private-develpkg:rpm/almalinux/postgresql-private-libspkg:rpm/almalinux/postgresql-serverpkg:rpm/almalinux/postgresql-server-develpkg:rpm/almalinux/postgresql-staticpkg:rpm/almalinux/postgresql-testpkg:rpm/almalinux/postgresql-test-rpm-macrospkg:rpm/almalinux/postgresql-upgradepkg:rpm/almalinux/postgresql-upgrade-develpkg:rpm/opensuse/postgresql11&distro=openSUSE%20Tumbleweedpkg:rpm/opensuse/postgresql12&distro=openSUSE%20Leap%2015.4pkg:rpm/opensuse/postgresql12&distro=openSUSE%20Leap%2015.5pkg:rpm/opensuse/postgresql12&distro=openSUSE%20Tumbleweedpkg:rpm/opensuse/postgresql13&distro=openSUSE%20Leap%2015.4pkg:rpm/opensuse/postgresql13&distro=openSUSE%20Leap%2015.5pkg:rpm/opensuse/postgresql13&distro=openSUSE%20Tumbleweedpkg:rpm/opensuse/postgresql14&distro=openSUSE%20Leap%2015.4pkg:rpm/opensuse/postgresql14&distro=openSUSE%20Leap%2015.5pkg:rpm/opensuse/postgresql14&distro=openSUSE%20Tumbleweedpkg:rpm/opensuse/postgresql15&distro=openSUSE%20Leap%2015.4pkg:rpm/opensuse/postgresql15&distro=openSUSE%20Leap%2015.5pkg:rpm/opensuse/postgresql15&distro=openSUSE%20Tumbleweedpkg:rpm/suse/postgresql12&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP1-LTSSpkg:rpm/suse/postgresql12&distro=SUSE%20Linux%20Enterprise%20Server%2012%20SP5pkg:rpm/suse/postgresql12&distro=SUSE%20Linux%20Enterprise%20Server%2015%20SP1-LTSSpkg:rpm/suse/postgresql12&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2012%20SP5pkg:rpm/suse/postgresql12&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2015%20SP1pkg:rpm/suse/postgresql12&distro=SUSE%20Linux%20Enterprise%20Software%20Development%20Kit%2012%20SP5pkg:rpm/suse/postgresql13&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Legacy%2015%20SP4pkg:rpm/suse/postgresql13&distro=SUSE%20Linux%20Enterprise%20Server%2012%20SP5pkg:rpm/suse/postgresql13&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2012%20SP5pkg:rpm/suse/postgresql13&distro=SUSE%20Linux%20Enterprise%20Software%20Development%20Kit%2012%20SP5pkg:rpm/suse/postgresql13&distro=SUSE%20Manager%20Proxy%204.2pkg:rpm/suse/postgresql13&distro=SUSE%20Manager%20Server%204.2pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Basesystem%2015%20SP4pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Legacy%2015%20SP5pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Package%20Hub%2015%20SP4pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Package%20Hub%2015%20SP5pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Server%20Applications%2015%20SP4pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Server%2012%20SP5pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2012%20SP5pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Software%20Development%20Kit%2012%20SP5pkg:rpm/suse/postgresql14&distro=SUSE%20Manager%20Proxy%204.2pkg:rpm/suse/postgresql14&distro=SUSE%20Manager%20Server%204.2pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Basesystem%2015%20SP4pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Basesystem%2015%20SP5pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Package%20Hub%2015%20SP4pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Server%20Applications%2015%20SP4pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Server%20Applications%2015%20SP5pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Server%2012%20SP5pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2012%20SP5pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Software%20Development%20Kit%2012%20SP5pkg:rpm/suse/postgresql15&distro=SUSE%20Manager%20Proxy%204.2pkg:rpm/suse/postgresql15&distro=SUSE%20Manager%20Server%204.2
>= 11.0.0, < 11.21.0+ 63 more
- (no CPE)range: >= 11.0.0, < 11.21.0
- (no CPE)range: < 1.5.0-1.module_el8.6.0+2760+1746ec94
- (no CPE)range: < 1.4.6-3.module_el8.6.0+2760+1746ec94
- (no CPE)range: < 0.10.0-2.module_el8.6.0+2760+1746ec94
- (no CPE)range: < 13.13-1.module_el8.9.0+3692+8714f643
- (no CPE)range: < 13.13-1.module_el8.9.0+3692+8714f643
- (no CPE)range: < 13.13-1.module_el8.9.0+3692+8714f643
- (no CPE)range: < 13.13-1.module_el8.9.0+3692+8714f643
- (no CPE)range: < 13.13-1.module_el8.9.0+3692+8714f643
- (no CPE)range: < 13.13-1.module_el8.9.0+3692+8714f643
- (no CPE)range: < 13.13-1.el9_3
- (no CPE)range: < 13.13-1.el9_3
- (no CPE)range: < 13.13-1.module_el8.9.0+3692+8714f643
- (no CPE)range: < 13.13-1.module_el8.9.0+3692+8714f643
- (no CPE)range: < 13.13-1.module_el8.9.0+3692+8714f643
- (no CPE)range: < 13.13-1.module_el8.9.0+3692+8714f643
- (no CPE)range: < 13.13-1.module_el8.9.0+3692+8714f643
- (no CPE)range: < 13.13-1.module_el8.9.0+3692+8714f643
- (no CPE)range: < 13.13-1.module_el8.9.0+3692+8714f643
- (no CPE)range: < 11.21-1.1
- (no CPE)range: < 12.16-150200.8.47.1
- (no CPE)range: < 12.16-150200.8.47.1
- (no CPE)range: < 12.16-1.1
- (no CPE)range: < 13.12-150200.5.43.1
- (no CPE)range: < 13.12-150200.5.43.1
- (no CPE)range: < 13.12-1.1
- (no CPE)range: < 14.9-150200.5.29.1
- (no CPE)range: < 14.9-150200.5.29.1
- (no CPE)range: < 14.9-1.1
- (no CPE)range: < 15.4-150200.5.12.1
- (no CPE)range: < 15.4-150200.5.12.1
- (no CPE)range: < 15.4-1.1
- (no CPE)range: < 12.16-150100.3.44.1
- (no CPE)range: < 12.16-3.42.1
- (no CPE)range: < 12.16-150100.3.44.1
- (no CPE)range: < 12.16-3.42.1
- (no CPE)range: < 12.16-150100.3.44.1
- (no CPE)range: < 12.16-3.42.1
- (no CPE)range: < 13.12-150200.5.43.1
- (no CPE)range: < 13.12-3.36.1
- (no CPE)range: < 13.12-3.36.1
- (no CPE)range: < 13.12-3.36.1
- (no CPE)range: < 13.12-150200.5.43.1
- (no CPE)range: < 13.12-150200.5.43.1
- (no CPE)range: < 14.9-150200.5.29.1
- (no CPE)range: < 14.9-150200.5.29.1
- (no CPE)range: < 14.9-150200.5.29.1
- (no CPE)range: < 14.9-150200.5.29.1
- (no CPE)range: < 14.9-150200.5.29.1
- (no CPE)range: < 14.9-3.26.1
- (no CPE)range: < 14.9-3.26.1
- (no CPE)range: < 14.9-3.26.1
- (no CPE)range: < 14.9-150200.5.29.1
- (no CPE)range: < 14.9-150200.5.29.1
- (no CPE)range: < 15.4-150200.5.12.1
- (no CPE)range: < 15.4-150200.5.12.1
- (no CPE)range: < 15.4-150200.5.12.1
- (no CPE)range: < 15.4-150200.5.12.1
- (no CPE)range: < 15.4-150200.5.12.1
- (no CPE)range: < 15.4-3.12.1
- (no CPE)range: < 15.4-3.12.1
- (no CPE)range: < 15.4-3.12.1
- (no CPE)range: < 15.4-150200.5.12.1
- (no CPE)range: < 15.4-150200.5.12.1
Patches
Vulnerability mechanics
References
24- access.redhat.com/errata/RHSA-2023:7545mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/errata/RHSA-2023:7579mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/errata/RHSA-2023:7580mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/errata/RHSA-2023:7581mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/errata/RHSA-2023:7616mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/errata/RHSA-2023:7656mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/errata/RHSA-2023:7666mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/errata/RHSA-2023:7667mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/errata/RHSA-2023:7694mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/errata/RHSA-2023:7695mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/errata/RHSA-2023:7714mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/errata/RHSA-2023:7770mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/errata/RHSA-2023:7772mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/errata/RHSA-2023:7784mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/errata/RHSA-2023:7785mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/errata/RHSA-2023:7883mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/errata/RHSA-2023:7884mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/errata/RHSA-2023:7885mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/errata/RHSA-2024:0304mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/errata/RHSA-2024:0332mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/errata/RHSA-2024:0337mitrevendor-advisoryx_refsource_REDHAT
- access.redhat.com/security/cve/CVE-2023-39417mitrevdb-entryx_refsource_REDHAT
- bugzilla.redhat.com/show_bug.cgimitreissue-trackingx_refsource_REDHAT
- www.postgresql.org/support/security/CVE-2023-39417mitre
News mentions
2- GitLab Security Release: 16.6.1, 16.5.3, 16.4.3GitLab Security Releases · Nov 30, 2023
- ABB Ability Symphony Plus EngineeringCISA Alerts