Skip to content
Fencer Vulns
medium 4.2

CVE-2024-10976 json

PostgreSQL row security below e.g. subqueries disregards user ID changes

published 2024-11-14 23 mo ago modified 2026-09-10 59 d ago also BIT-postgresql-2024-10976 , EUVD-2024-33374 , JLSEC-2026-47

cvss
4.2
version 3.1, CNA
cisa kev
Not listed
not in CISA's catalog
epss
0.8%
EPSS 0.8% chance of exploitation in 30 days, percentile 55%
public exploits
0
none known

Summary

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.

Patch / fix

  • bitnami postgresql 13.17.0, 14.14.0, 15.9.0, 16.5.0, 17.1.0
  • julia LibPQ_jll 16.8.0+0
  • n/a PostgreSQL 12.21, 13.17, 14.14, 15.9, 16.5, 17.1
  • postgresql-15 Debian 12 15.9-0+deb12u1
  • postgresql-17 Debian 13 17.1-1

debian advisories DEBIAN-CVE-2024-10976

  • postgresql-12 Ubuntu 20.04 LTS 12.22-0ubuntu0.20.04.1
  • postgresql-14 Ubuntu 22.04 LTS 14.15-0ubuntu0.22.04.1
  • postgresql-16 Ubuntu 24.04 LTS 16.6-0ubuntu0.24.04.1
  • postgresql-9.5 Ubuntu Pro 16.04 LTS 9.5.25-0ubuntu0.16.04.1+esm10

ubuntu advisories UBUNTU-CVE-2024-10976

Ubuntu security data © Canonical Ltd., from https://github.com/canonical/ubuntu-security-notices via OSV; changed: normalised to fixed package versions per release. CC BY-SA 4.0

  • pgaudit RHEL 8 1.7.0-1.module+el8.9.0+19797+c4ce5969
  • pg_repack RHEL 8 1.4.8-1.module+el8.9.0+19797+c4ce5969
  • postgresql RHEL 8 15.10-1.module+el8.10.0+22550+22c7d5ca
  • postgresql-test RHEL 8 15.10-1.module+el8.10.0+22550+22c7d5ca
  • postgresql-pltcl RHEL 8 15.10-1.module+el8.10.0+22550+22c7d5ca
  • postgresql-plperl RHEL 8 15.10-1.module+el8.10.0+22550+22c7d5ca
  • postgresql-server RHEL 8 15.10-1.module+el8.10.0+22550+22c7d5ca
  • postgresql-contrib RHEL 8 15.10-1.module+el8.10.0+22550+22c7d5ca

red hat advisories RHSA-2024:10830RHSA-2024:10831RHSA-2024:10832RHSA-2024:10791RHSA-2024:10788RHSA-2024:10787

  • postgresql14 SLES for SAP 15 SP4, SLES for SAP 15 SP3, SLES for SAP 15 SP2 +13 more 14.15-150200.5.50.1
  • postgresql13 SLES for SAP 15 SP4, SLES for SAP 15 SP3, SLES for SAP 15 SP2 +10 more 13.18-150200.5.64.1
  • postgresql15 SLES for SAP 15 SP4, SLES for SAP 15 SP3, SLES 15 SP4-LTSS +10 more 15.10-150200.5.33.1
  • postgresql17 SLES for SAP 15 SP4, SLES for SAP 15 SP3, SLES 15 SP4-LTSS +11 more 17.2-150200.5.5.1
  • postgresql SLE Module for Server Applications 15 SP5, SLE Module for Package Hub 15 SP5, SLE Module for Legacy 15 SP5 +2 more 17-150500.10.9.1
  • postgresql SLES for SAP 15 SP3, SLES 15 SP3-LTSS, SLE High Performance Computing 15 SP3-LTSS +1 more 17-150300.10.27.1
  • postgresql SLES for SAP 15 SP4, SLES 15 SP4-LTSS, SLE High Performance Computing 15 SP4-LTSS +3 more 17-150400.4.18.1
  • postgresql16 SLES for SAP 15 SP4, SLES for SAP 15 SP3, SLES 15 SP4-LTSS +11 more 16.6-150200.5.21.1

suse advisories SUSE-SU-2025:01799-1SUSE-SU-2024:4176-1SUSE-SU-2024:4175-1SUSE-SU-2024:4174-1SUSE-SU-2024:4173-1SUSE-SU-2024:4118-1

  • postgresql12 openSUSE Tumbleweed 12.21-1.1
  • postgresql13 openSUSE Tumbleweed 13.17-1.1
  • postgresql14 openSUSE Tumbleweed 14.14-1.1
  • postgresql15 openSUSE Tumbleweed 15.9-1.1
  • postgresql16 openSUSE Tumbleweed 16.5-1.1
  • postgresql17 openSUSE Tumbleweed 17.1-1.1

opensuse advisories openSUSE-SU-2024:14501-1openSUSE-SU-2024:14502-1openSUSE-SU-2024:14503-1openSUSE-SU-2024:14504-1openSUSE-SU-2024:14505-1openSUSE-SU-2024:14506-1

  • pgaudit AlmaLinux 8 1.7.0-1.module_el8.9.0+3706+885c732e
  • pg_repack AlmaLinux 8 1.4.8-1.module_el8.9.0+3706+885c732e
  • pg_repack AlmaLinux 8 1.4.8-1.module_el8.10.0+3798+606ebb9f
  • postgresql AlmaLinux 8 15.10-1.module_el8.10.0+3929+38258aa5
  • postgresql-test AlmaLinux 8 15.10-1.module_el8.10.0+3929+38258aa5
  • postgresql-pltcl AlmaLinux 8 15.10-1.module_el8.10.0+3929+38258aa5
  • postgresql-plperl AlmaLinux 8 15.10-1.module_el8.10.0+3929+38258aa5
  • postgresql-server AlmaLinux 8 15.10-1.module_el8.10.0+3929+38258aa5

almalinux advisories ALSA-2024:10830ALSA-2024:10831ALSA-2024:10832ALSA-2024:10785ALSA-2024:10787ALSA-2024:10788

  • pgaudit Rocky Linux 9 1.7.0-1.module+el9.5.0+30637+4391fcca
  • pg_repack Rocky Linux 9 1.4.8-2.module+el9.5.0+30637+4391fcca
  • postgres-decoderbufs Rocky Linux 9 1.9.7-1.Final.module+el9.5.0+30637+4391fcca
  • pgaudit Rocky Linux 9 16.0-1.module+el9.5.0+30638+72f697e1
  • pgvector Rocky Linux 9 0.6.2-1.module+el9.5.0+30638+72f697e1
  • pg_repack Rocky Linux 9 1.5.1-1.module+el9.5.0+30638+72f697e1
  • postgres-decoderbufs Rocky Linux 9 2.4.0-1.Final.module+el9.5.0+30638+72f697e1
  • pgaudit Rocky Linux 8 1.4.0-7.module+el8.9.0+1735+a332307b

rocky linux advisories RLSA-2024:10787RLSA-2024:10788RLSA-2024:10785RLSA-2024:10830RLSA-2024:10831RLSA-2024:10832

  • postgresql13 Alpine 3.19, Alpine 3.18, Alpine 3.17 13.17-r0
  • postgresql14 Alpine 3.20, Alpine 3.19, Alpine 3.18 +1 more 14.14-r0
  • postgresql15 Alpine 3.22, Alpine 3.21, Alpine 3.20 +3 more 15.9-r0
  • postgresql16 Alpine 3.24, Alpine 3.23, Alpine 3.22 +3 more 16.5-r0
  • postgresql17 Alpine 3.24, Alpine 3.23, Alpine 3.22 +1 more 17.1-r0

alpine advisories ALPINE-CVE-2024-10976

Alpine secdb © Alpine Linux, from https://secdb.alpinelinux.org via OSV; changed: normalised to fixed package versions per release. CC BY-SA 4.0

  • postgresql CBL-Mariner 2.0 14.14-1
  • postgresql Azure Linux 3.0 16.5-1

azure linux advisories AZL-53201AZL-53215

Azure Linux vulnerability data, Copyright (c) Microsoft Corporation, from https://github.com/microsoft/AzureLinuxVulnerabilityData via OSV, under the MIT licence; changed: normalised to fixed package versions per release. MIT

Vendor advisories

What the vendors themselves say about their products: affected, fixed or not affected, and what to do.

red hat product security vex CVE-2024-10976 updated cvss 4.2

postgresql: PostgreSQL row security below e.g. subqueries disregards user ID changes

  • Red Hat Enterprise Linux 7 postgresql, postgresql-libs, postgresql-test, postgresql-pltcl, postgresql-plperl, postgresql-server, +3 more
    affected: workaround, no fix planned “Out of support scope”
  • Red Hat CodeReady Linux Builder (v. 9) postgresql-test 13.18-1.el9_5, postgresql-test-rpm-macros 13.18-1.el9_5
    fixed: vendor fix RHSA-2024:10791
  • Red Hat Enterprise Linux AppStream (v. 8) pgaudit 1.5.0-1.module+el8.9.0+20664+9c30cf7f, pgaudit 1.7.0-1.module+el8.9.0+19797+c4ce5969, pgaudit 16.0-1.module+el8.10.0+20413+d8116364, pgaudit 1.4.0-7.module+el8.10.0+22214+9beb89d6, pg_repack 1.4.6-3.module+el8.9.0+19330+c97ddbdf, pg_repack 1.4.6-3.module+el8.9.0+20664+9c30cf7f, +44 more
    fixed: vendor fix RHSA-2024:10785
  • Red Hat Enterprise Linux AppStream (v. 9) postgresql 13.18-1.el9_5, postgresql-pltcl 13.18-1.el9_5, postgresql-plperl 13.18-1.el9_5, postgresql-server 13.18-1.el9_5, postgresql-contrib 13.18-1.el9_5, postgresql-upgrade 13.18-1.el9_5, +29 more
    fixed: vendor fix RHSA-2024:10787

Red Hat CSAF VEX © Red Hat, Inc., from https://security.access.redhat.com/data/csaf/v2/vex/; changed: reduced to product statuses and remediations. CC BY 4.0 · csaf

CISA SSVC

Exploitation
none
Automatable
no
Technical impact
partial
Assessed
23 mo ago

Exploit prediction

0.77% chance of exploitation in the next 30 days, higher than 55% of all scored CVEs (FIRST EPSS, 2026-11-08).

CVSS scores

assigned by version score vector
CNA 3.1 4.2 CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N
NVD 3.1 5.4 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N
OSV 3.1 4.2 CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N
OSV 3.1 5.4 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N

Affected packages

ecosystem package affected fixed in
bitnami postgresql
<13.17.0
>=14.0.0, <14.14.0
>=15.0.0, <15.9.0
>=16.0.0, <16.5.0
>=17.0.0, <17.1.0
13.17.0
14.14.0
15.9.0
16.5.0
17.1.0
julia LibPQ_jll
<16.8.0+0
16.8.0+0

Affected products

  • n/a PostgreSQL

Classification

Weakness
  • CWE-1250 Improper Preservation of Consistency Between Independent Representations of Shared State
Technology feeds

References

Sources

Fencer Vulns keeps one entry per vulnerability: the CVE id wins, then GHSA, and records that alias each other are merged, except that two CVEs always keep separate entries. The same data is available as JSON.

CPEs and fixed versions use Anchore's correction of NVD's data: Added CPE configurations because not yet analyzed by NVD.