Skip to content
Fencer Vulns
medium 4.2

CVE-2024-10978 json

PostgreSQL SET ROLE, SET SESSION AUTHORIZATION reset to wrong user ID

published 2024-11-14 23 mo ago modified 2026-09-08 2 mo ago also BIT-postgresql-2024-10978 , EUVD-2024-33376 , JLSEC-2026-49

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

Summary

Incorrect privilege assignment in PostgreSQL allows a less-privileged application user to view or change different rows from those intended. An attack requires the application to use SET ROLE, SET SESSION AUTHORIZATION, or an equivalent feature. The problem arises when an application query uses parameters from the attacker or conveys query results to the attacker. If that query reacts to current_setting('role') or the current user ID, it may modify or return data as though the session had not used SET ROLE or SET SESSION AUTHORIZATION. The attacker does not control which incorrect user ID applies. Query text from less-privileged sources is not a concern here, because SET ROLE and SET SESSION AUTHORIZATION are not sandboxes for unvetted queries. Versions before PostgreSQL 17.1, 16.5, 15.9, 14.14, 13.17, and 12.21 are affected.

Patch / fix

  • bitnami postgresql 12.21.0, 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-10978

  • 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-10978

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-10978

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-53204AZL-53209

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-10978 updated cvss 4.2

postgresql: PostgreSQL SET ROLE, SET SESSION AUTHORIZATION reset to wrong user ID

  • 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.69% chance of exploitation in the next 30 days, higher than 53% 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 4.2 CVSS:3.1/AV:N/AC:H/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

Affected packages

ecosystem package affected fixed in
bitnami postgresql
<12.21.0
>=13.0.0, <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
12.21.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-266 Incorrect Privilege Assignment
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.