CVE-2023-39417
Public on
Last Modified:
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.
Statement
Bundled extensions are not vulnerable. Also, PostgreSQL will block this attack in the core server, so there's no need to modify individual extensions.
Additional Information
- This content is not included.Bugzilla 2228111: postgresql: extension script @substitutions@ within quoting allow SQL injection
- Content from cwe.mitre.org is not included.CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')
- FAQ: Frequently asked questions about CVE-2023-39417
- Offline Security Data data is available for integration with other systems. See Offline Security Data API to get started.
External References
Content from www.cve.org is not included.https://www.cve.org/CVERecord?id=CVE-2023-39417
Content from nvd.nist.gov is not included.https://nvd.nist.gov/vuln/detail/CVE-2023-39417
Affected Packages and Issued Red Hat Security Errata
| Products / Services | Components | State | Errata |
|---|---|---|---|
| RHACS-3.74-RHEL-8 | advanced-cluster-security/rhacs-central-db-rhel8 | Fixed | RHSA-2024:0304 |
| RHACS-3.74-RHEL-8 | advanced-cluster-security/rhacs-main-rhel8 | Fixed | RHSA-2024:0304 |
| RHACS-3.74-RHEL-8 | advanced-cluster-security/rhacs-operator-bundle | Fixed | RHSA-2024:0304 |
| RHACS-3.74-RHEL-8 | advanced-cluster-security/rhacs-scanner-db-rhel8 | Fixed | RHSA-2024:0304 |
| RHACS-3.74-RHEL-8 | advanced-cluster-security/rhacs-scanner-db-slim-rhel8 | Fixed | RHSA-2024:0304 |
| RHACS-4.1-RHEL-8 | advanced-cluster-security/rhacs-central-db-rhel8 | Fixed | RHSA-2024:0332 |
| RHACS-4.1-RHEL-8 | advanced-cluster-security/rhacs-main-rhel8 | Fixed | RHSA-2024:0332 |
| RHACS-4.1-RHEL-8 | advanced-cluster-security/rhacs-operator-bundle | Fixed | RHSA-2024:0332 |
| RHACS-4.1-RHEL-8 | advanced-cluster-security/rhacs-scanner-db-rhel8 | Fixed | RHSA-2024:0332 |
| RHACS-4.1-RHEL-8 | advanced-cluster-security/rhacs-scanner-db-slim-rhel8 | Fixed | RHSA-2024:0332 |
| Red Hat Advanced Cluster Security 4.2 | advanced-cluster-security/rhacs-central-db-rhel8 | Fixed | RHSA-2024:0337 |
| Red Hat Advanced Cluster Security 4.2 | advanced-cluster-security/rhacs-main-rhel8 | Fixed | RHSA-2024:0337 |
| Red Hat Advanced Cluster Security 4.2 | advanced-cluster-security/rhacs-operator-bundle | Fixed | RHSA-2024:0337 |
| Red Hat Advanced Cluster Security 4.2 | advanced-cluster-security/rhacs-scanner-db-rhel8 | Fixed | RHSA-2024:0337 |
| Red Hat Advanced Cluster Security 4.2 | advanced-cluster-security/rhacs-scanner-db-slim-rhel8 | Fixed | RHSA-2024:0337 |
| Red Hat Enterprise Linux 6 | postgresql | Out of support scope | |
| Red Hat Enterprise Linux 7 | postgresql | Out of support scope | |
| Red Hat Enterprise Linux 8 | postgresql:13 | Fixed | RHSA-2023:7581 |
| Red Hat Enterprise Linux 8 | postgresql:12 | Fixed | RHSA-2023:7714 |
| Red Hat Enterprise Linux 8 | postgresql:15 | Fixed | RHSA-2023:7884 |
| Red Hat Enterprise Linux 8 | postgresql:10/postgresql | Not affected | |
| Red Hat Enterprise Linux 8.2 Advanced Update Support | postgresql:12 | Fixed | RHSA-2023:7667 |
| Red Hat Enterprise Linux 8.2 Telecommunications Update Service | postgresql:12 | Fixed | RHSA-2023:7667 |
| Red Hat Enterprise Linux 8.2 Update Services for SAP Solutions | postgresql:12 | Fixed | RHSA-2023:7667 |
| Red Hat Enterprise Linux 8.4 Advanced Mission Critical Update Support | postgresql:12 | Fixed | RHSA-2023:7694 |
| Red Hat Enterprise Linux 8.4 Advanced Mission Critical Update Support | postgresql:13 | Fixed | RHSA-2023:7695 |
| Red Hat Enterprise Linux 8.4 Telecommunications Update Service | postgresql:12 | Fixed | RHSA-2023:7694 |
| Red Hat Enterprise Linux 8.4 Telecommunications Update Service | postgresql:13 | Fixed | RHSA-2023:7695 |
| Red Hat Enterprise Linux 8.4 Update Services for SAP Solutions | postgresql:12 | Fixed | RHSA-2023:7694 |
| Red Hat Enterprise Linux 8.4 Update Services for SAP Solutions | postgresql:13 | Fixed | RHSA-2023:7695 |
| Red Hat Enterprise Linux 8.6 Extended Update Support | postgresql:13 | Fixed | RHSA-2023:7580 |
| Red Hat Enterprise Linux 8.6 Extended Update Support | postgresql:12 | Fixed | RHSA-2023:7666 |
| Red Hat Enterprise Linux 8.8 Extended Update Support | postgresql:13 | Fixed | RHSA-2023:7579 |
| Red Hat Enterprise Linux 8.8 Extended Update Support | postgresql:12 | Fixed | RHSA-2023:7656 |
| Red Hat Enterprise Linux 8.8 Extended Update Support | postgresql:15 | Fixed | RHSA-2023:7883 |
| Red Hat Enterprise Linux 9 | postgresql | Fixed | RHSA-2023:7784 |
| Red Hat Enterprise Linux 9 | postgresql:15 | Fixed | RHSA-2023:7785 |
| Red Hat Enterprise Linux 9.0 Extended Update Support | postgresql | Fixed | RHSA-2023:7545 |
| Red Hat Enterprise Linux 9.2 Extended Update Support | postgresql | Fixed | RHSA-2023:7616 |
| Red Hat Enterprise Linux 9.2 Extended Update Support | postgresql:15 | Fixed | RHSA-2023:7885 |
| Red Hat Software Collections | rh-postgresql10-postgresql | Will not fix | |
| Red Hat Software Collections for Red Hat Enterprise Linux 7 | rh-postgresql12-postgresql | Fixed | RHSA-2023:7770 |
| Red Hat Software Collections for Red Hat Enterprise Linux 7 | rh-postgresql13-postgresql | Fixed | RHSA-2023:7772 |
Common Vulnerability Scoring System (CVSS) Score Details
Important note
CVSS scores for open source components depend on vendor-specific factors (e.g. version or build chain). Therefore, Red Hat's score and impact rating can be different from NVD and other vendors. Red Hat remains the authoritative CVE Naming Authorities (CNA) source for its products and services (see Red Hat classifications ).
| CVSS v3 Score Breakdown | Red Hat | NVD |
|---|---|---|
| CVSS v3 Base Score | 7.5 | 8.8 |
| Attack Vector | Network | Network |
| Attack Complexity | High | Low |
| Privileges Required | Low | Low |
| User Interaction | None | None |
| Scope | Unchanged | Unchanged |
| Confidentiality Impact | High | High |
| Integrity Impact | High | High |
| Availability Impact | High | High |
CVSS v3 Vector
Red Hat CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:H/I:H/A:H
NVD CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H
Red Hat CVSS v3 Score Explanation
AC:H, because the attack prerequisite is an administrator must have files installed of a vulnerable, trusted, non-bundled extension.
Frequently Asked Questions
Why is Red Hat's CVSS v3 score or Impact different from other vendors?
For more information, see https://access.redhat.com/solutions/762393.
My product is listed as "Under investigation" or "Affected", when will Red Hat release a fix for this vulnerability?
- "Under investigation" doesn't necessarily mean that the product is affected by this vulnerability. It only means that our Analysis Team is still working on determining whether the product is affected and how it is affected.
- "Affected" means that our Analysis Team has determined that this product is affected by this vulnerability and might release a fix to address this in the near future.
What can I do if my product is listed as "Will not fix"?
Available options depend mostly on the Impact of the vulnerability and the current Life Cycle phase of your product. Overall, you have the following options:
- Upgrade to a supported product version that includes a fix for this vulnerability (recommended).
- Apply a mitigation (if one exists).
- Open a This content is not included.support case to request a prioritization of releasing a fix for this vulnerability.
What can I do if my product is listed as "Fix deferred"?
Available options depend mostly on the Impact of the vulnerability and the current Life Cycle phase of your product. Overall, you have the following options:
- Apply a mitigation (if one exists).
- Open a This content is not included.support case to request a prioritization of releasing a fix for this vulnerability.
- Red Hat Engineering focuses on addressing high-priority issues based on their complexity or limited lifecycle support. Therefore, lower-priority issues will not receive immediate fixes.
What is a mitigation?
I have a Red Hat product but it is not in the above list, is it affected?
Why is my security scanner reporting my product as vulnerable to this vulnerability even though my product version is fixed or not affected?
My product is listed as "Out of Support Scope". What does this mean?
Not sure what something means? Check out our Security Glossary.