CVE-2024-10976

一、漏洞信息
 漏洞编号：[CVE-2024-10976](https://nvd.nist.gov/vuln/detail/CVE-2024-10976)
 漏洞归属组件：[postgresql-13](https://gitee.com/src-openeuler/postgresql-13)
 漏洞归属的版本：13.3
 CVSS V3.0分值：
  BaseScore：5.4 Medium
  Vector：CVSS：3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N
 漏洞简述：
  Incomplete tracking in PostgreSQL of tables with row security allows a reused query to view or change different rows from those intended.  CVE-2023-2455 and CVE-2016-2193 fixed most interaction between row security and user ID changes.  They missed cases where a subquery, WITH query, security invoker view, or SQL-language function references a table with a row-level security policy.  This has the same consequences as the two earlier CVEs.  That is to say, it leads to potentially incorrect policies being applied in cases where role-specific policies are used and a given query is planned under one role and then executed under other roles.  This scenario can happen under security definer functions or when a common user and query is planned initially and then re-used across multiple SET ROLEs.  Applying an incorrect policy may permit a user to complete otherwise-forbidden reads and modifications.  This affects only databases that have used CREATE POLICY to define a row security policy.  An attacker must tailor an attack to a particular application s pattern of query plan reuse, user ID changes, and role-specific row security policies.  Versions before PostgreSQL 17.1, 16.5, 15.9, 14.14, 13.17, and 12.21 are affected.
 漏洞公开时间：2024-11-14 21:15:03
 漏洞创建时间：2024-11-15 23:30:07
 漏洞详情参考链接：
  https://nvd.nist.gov/vuln/detail/CVE-2024-10976
<details>
<summary>更多参考(点击展开)</summary>

| 参考来源 | 参考链接 | 来源链接 |
| ------- | -------- | -------- |
| f86ef6dc-4d3a-42ad-8f28-e6d5547a5007 | https://www.postgresql.org/support/security/CVE-2024-10976/ |  |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2024:10785 | https://bugzilla.redhat.com/show_bug.cgi?id=2326263 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2024:10788 | https://bugzilla.redhat.com/show_bug.cgi?id=2326263 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2024:10787 | https://bugzilla.redhat.com/show_bug.cgi?id=2326263 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2024:10791 | https://bugzilla.redhat.com/show_bug.cgi?id=2326263 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2024:10830 | https://bugzilla.redhat.com/show_bug.cgi?id=2326263 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2024:10832 | https://bugzilla.redhat.com/show_bug.cgi?id=2326263 |
| redhat_bugzilla | https://access.redhat.com/errata/RHSA-2024:10831 | https://bugzilla.redhat.com/show_bug.cgi?id=2326263 |
| debian |  | https://security-tracker.debian.org/tracker/CVE-2024-10976 |
| postgrepsql | https://www.postgresql.org//support/security/CVE-2024-10976/ | https://www.postgresql.org//support/security/CVE-2024-10976/ |
| postgrepsql | https://www.postgresql.org/about/news/postgresql-171-165-159-1414-1317-and-1221-released-2955/ | https://www.postgresql.org//support/security/CVE-2024-10976/ |
| gentoo |  | https://security.gentoo.org/glsa/202412-12 |
| anolis |  | https://anas.openanolis.cn/cves/detail/CVE-2024-10976 |
| mageia |  | http://advisories.mageia.org/MGASA-2024-0372.html |
| osv | https://www.postgresql.org/support/security/CVE-2024-10976/ | https://osv.dev/vulnerability/CVE-2024-10976 |
| osv | https://security.alpinelinux.org/vuln/CVE-2024-10976 | https://osv.dev/vulnerability/CVE-2024-10976 |
| osv | https://security-tracker.debian.org/tracker/CVE-2024-10976 | https://osv.dev/vulnerability/CVE-2024-10976 |
| amazon_linux_explore | https://access.redhat.com/security/cve/CVE-2024-10976 | https://explore.alas.aws.amazon.com/CVE-2024-10976.html |
| amazon_linux_explore | https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2024-10976 | https://explore.alas.aws.amazon.com/CVE-2024-10976.html |

</details>

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

| 影响的包 | 修复版本 | 修复补丁 | 问题引入补丁 | 来源  |
| ------- | -------- | ------- | -------- | --------- |
|  |  | https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=edcda9bb4c4500b75bb4a16c7c59834398ca2906 |  | debian |
|  |  | https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=562289460e118fcad44ec916dcdab21e4763c38c |  | debian |
|  |  | https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=6db5ea8de8ce15897b706009aaf701d23bd65b23 |  | debian |
|  |  | https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=4e51030af9e0a12d7fa06b73acd0c85024f81062 |  | debian |
|  |  | https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=952ff31e2a89e8ca79ecb12d61fddbeac3d89176 |  | debian |
|  |  | https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=448525e8a44080b6048e24f6942284b7eeae1a5c |  | debian |

</details>

二、漏洞分析结构反馈
 影响性分析说明：
  Incomplete tracking in PostgreSQL of tables with row security allows a reused query to view or change different rows from those intended. CVE-2023-2455 and CVE-2016-2193 fixed most interaction between row security and user ID changes. They missed cases where a subquery, WITH query, security invoker view, or SQL-language function references a table with a row-level security policy. This has the same consequences as the two earlier CVEs. That is to say, it leads to potentially incorrect policies being applied in cases where role-specific policies are used and a given query is planned under one role and then executed under other roles. This scenario can happen under security definer functions or when a common user and query is planned initially and then re-used across multiple SET ROLEs.
 openEuler评分：
  5.4
 Vector：CVSS：3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N
 受影响版本排查(受影响/不受影响)：
  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
Closed

Content Risk Flag

Comments (4)

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

Content Risk Flag

CVE-2024-10976

Comments (4)

Search

src-openEuler/postgresql-13
Closed