CVE-2023-39417

一、漏洞信息
 漏洞编号：[CVE-2023-39417](https://nvd.nist.gov/vuln/detail/CVE-2023-39417)
 漏洞归属组件：[postgresql-13](https://gitee.com/src-openeuler/postgresql-13)
 漏洞归属的版本：13.3
 CVSS V3.0分值：
  BaseScore：8.8 High
  Vector：CVSS：3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H
 漏洞简述：
  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.
 漏洞公开时间：2023-08-11 21:15:09
 漏洞创建时间：2024-01-19 00:48:23
 漏洞详情参考链接：
  https://nvd.nist.gov/vuln/detail/CVE-2023-39417
<details>
<summary>更多参考(点击展开)</summary>

| 参考来源 | 参考链接 | 来源链接 |
| ------- | -------- | -------- |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2023:7545 |  |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2023:7579 |  |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2023:7580 |  |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2023:7581 |  |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2023:7616 |  |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2023:7656 |  |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2023:7666 |  |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2023:7667 |  |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2023:7694 |  |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2023:7695 |  |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2023:7714 |  |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2023:7770 |  |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2023:7772 |  |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2023:7784 |  |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2023:7785 |  |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2023:7883 |  |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2023:7884 |  |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2023:7885 |  |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2024:0304 |  |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2024:0332 |  |
| secalert.redhat.com | https://access.redhat.com/errata/RHSA-2024:0337 |  |
| secalert.redhat.com | https://access.redhat.com/security/cve/CVE-2023-39417 |  |
| secalert.redhat.com | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |  |
| secalert.redhat.com | https://www.postgresql.org/support/security/CVE-2023-39417 |  |
| redhat_bugzilla | https://www.postgresql.org/support/security/CVE-2023-39417 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2023:7545 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2023:7579 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2023:7580 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2023:7581 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2023:7616 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2023:7656 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2023:7667 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2023:7666 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2023:7694 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2023:7695 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2023:7714 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2023:7770 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2023:7772 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2023:7784 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2023:7785 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2023:7885 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2023:7883 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2023:7884 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2024:0304 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2024:0332 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2024:0337 | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| debian |  | https://security-tracker.debian.org/tracker/CVE-2023-39417 |
| postgrepsql | https://www.postgresql.org//support/security/CVE-2023-39417/ | https://www.postgresql.org//support/security/CVE-2023-39417/ |
| postgrepsql | https://www.postgresql.org/about/news/postgresql-154-149-1312-1216-1121-and-postgresql-16-beta-3-released-2689/ | https://www.postgresql.org//support/security/CVE-2023-39417/ |
| anolis |  | https://anas.openanolis.cn/cves/detail/CVE-2023-39417 |
| cve_search |  | https://www.postgresql.org/support/security/CVE-2023-39417 |
| cve_search |  | https://access.redhat.com/security/cve/CVE-2023-39417 |
| cve_search |  | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |
| cve_search |  | https://security.netapp.com/advisory/ntap-20230915-0002/ |
| cve_search |  | https://lists.debian.org/debian-lts-announce/2023/10/msg00003.html |
| cve_search |  | https://www.debian.org/security/2023/dsa-5554 |
| cve_search |  | https://www.debian.org/security/2023/dsa-5553 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2023:7545 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2023:7579 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2023:7580 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2023:7581 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2023:7616 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2023:7656 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2023:7666 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2023:7667 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2023:7694 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2023:7695 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2023:7714 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2023:7770 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2023:7772 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2023:7784 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2023:7785 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2023:7883 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2023:7884 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2023:7885 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2024:0304 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2024:0332 |
| cve_search |  | https://access.redhat.com/errata/RHSA-2024:0337 |
| mageia |  | http://advisories.mageia.org/MGASA-2023-0261.html |
| amazon_linux_explore | https://access.redhat.com/security/cve/CVE-2023-39417 | https://explore.alas.aws.amazon.com/CVE-2023-39417.html |
| amazon_linux_explore | https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2023-39417 | https://explore.alas.aws.amazon.com/CVE-2023-39417.html |
| snyk | https://www.postgresql.org/support/security/CVE-2023-39417 | https://security.snyk.io/vuln/SNYK-UNMANAGED-POSTGRESQL-5838567 |
| snyk | https://github.com/postgres/postgres/commit/919ebb023e74546c6293352556365091c5402366 | https://security.snyk.io/vuln/SNYK-UNMANAGED-POSTGRESQL-5838567 |
| snyk | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 | https://security.snyk.io/vuln/SNYK-UNMANAGED-POSTGRESQL-5838567 |

</details>

漏洞分析指导链接：
  https://gitee.com/openeuler/cve-manager/blob/master/cve-vulner-manager/doc/md/manual.md
 漏洞数据来源:
  其它
 漏洞补丁信息：
  <details>
<summary>详情(点击展开)</summary>

| 影响的包 | 修复版本 | 修复补丁 | 问题引入补丁 | 来源  |
| ------- | -------- | ------- | -------- | --------- |
|  |  | https://github.com/postgres/postgres/commit/919ebb023e74546c6293352556365091c5402366 |  | snyk |
|  |  | https://access.redhat.com/errata/RHSA-2023:7545 |  | nvd |
|  |  | https://access.redhat.com/errata/RHSA-2023:7579 |  | nvd |
|  |  | https://access.redhat.com/errata/RHSA-2023:7580 |  | nvd |
|  |  | https://access.redhat.com/errata/RHSA-2023:7581 |  | nvd |
|  |  | https://access.redhat.com/errata/RHSA-2023:7616 |  | nvd |
|  |  | https://access.redhat.com/errata/RHSA-2023:7656 |  | nvd |
|  |  | https://access.redhat.com/errata/RHSA-2023:7666 |  | nvd |
|  |  | https://access.redhat.com/errata/RHSA-2023:7667 |  | nvd |
|  |  | https://access.redhat.com/errata/RHSA-2023:7694 |  | nvd |
|  |  | https://access.redhat.com/errata/RHSA-2023:7695 |  | nvd |
|  |  | https://access.redhat.com/errata/RHSA-2023:7714 |  | nvd |
|  |  | https://access.redhat.com/errata/RHSA-2023:7770 |  | nvd |
|  |  | https://access.redhat.com/errata/RHSA-2023:7772 |  | nvd |
|  |  | https://access.redhat.com/errata/RHSA-2023:7784 |  | nvd |
|  |  | https://access.redhat.com/errata/RHSA-2023:7785 |  | nvd |
|  |  | https://access.redhat.com/errata/RHSA-2023:7883 |  | nvd |
|  |  | https://access.redhat.com/errata/RHSA-2023:7884 |  | nvd |
|  |  | https://access.redhat.com/errata/RHSA-2023:7885 |  | nvd |
|  |  | https://access.redhat.com/errata/RHSA-2024:0304 |  | nvd |
|  |  | https://access.redhat.com/errata/RHSA-2024:0332 |  | nvd |
|  |  | https://access.redhat.com/errata/RHSA-2024:0337 |  | nvd |
|  |  | https://access.redhat.com/security/cve/CVE-2023-39417 |  | nvd |
|  |  | https://bugzilla.redhat.com/show_bug.cgi?id=2228111 |  | nvd |
|  |  | https://www.postgresql.org/support/security/CVE-2023-39417 |  | nvd |

</details>

二、漏洞分析结构反馈
 影响性分析说明：
  An extension script is vulnerable if it uses @extowner@, @extschema@, or @extschema:...@ inside a quoting construct (dollar quoting,   , or   ). No bundled extension is vulnerable. Vulnerable uses do appear in a documentation example and in non-bundled extensions. Hence, the attack prerequisite is an administrator having installed files of a vulnerable, trusted, non-bundled extension. Subject to that prerequisite, this enables an attacker having database-level CREATE privilege to execute arbitrary code as the bootstrap superuser. PostgreSQL will block this attack in the core server, so there s no need to modify individual extensions.
 openEuler评分：
  8.8
 Vector：CVSS：3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H
 受影响版本排查(受影响/不受影响)：
  1.openEuler-20.03-LTS-SP4(13.20):受影响
2.master:不受影响
3.openEuler-22.03-LTS-SP3:不受影响
4.openEuler-22.03-LTS-SP4:不受影响
5.openEuler-24.03-LTS:不受影响
6.openEuler-24.03-LTS-Next:不受影响
7.openEuler-24.03-LTS-SP1:不受影响

修复是否涉及abi变化(是/否)：
  1.master:否
2.openEuler-20.03-LTS-SP4(13.20):否
3.openEuler-22.03-LTS-SP3:否
4.openEuler-22.03-LTS-SP4:否
5.openEuler-24.03-LTS:否
6.openEuler-24.03-LTS-Next:否
7.openEuler-24.03-LTS-SP1:否

原因说明：
  1.openEuler-20.03-LTS-SP4(13.20):正常修复
2.master:不受影响-组件不存在
3.openEuler-22.03-LTS-SP3:不受影响-组件不存在
4.openEuler-22.03-LTS-SP4:不受影响-组件不存在
5.openEuler-24.03-LTS:不受影响-组件不存在
6.openEuler-24.03-LTS-Next:不受影响-组件不存在
7.openEuler-24.03-LTS-SP1:不受影响-组件不存在

三、漏洞修复
安全公告链接：https://www.openeuler.org/zh/security/safety-bulletin/detail/?id=openEuler-SA-2025-1335

src-openEuler/postgresql-13

内容风险标识

评论 (5)

src-openEuler/postgresql-13 .gitee-modal { width: 500px !important; }

内容风险标识

CVE-2023-39417

评论 (5)

搜索帮助

src-openEuler/postgresql-13