cve.bz

CVE-2024-10978 Incorrect Privilege Assignment

4.2 mediumEPSS 0.7%

Medium (4.2). EPSS 0.7% estimated probability of exploitation activity in the next 30 days.

On this page
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.

Severity

CVSS 3.1

4.2 medium
CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N
EPSS
0.7% (unchanged from 0.7% a week ago; 0.7% 30 days ago) estimated probability of exploitation activity in the next 30 days; 54th percentile. Scored 2026-11-22. A forecast for this CVE across the internet, not for your own systems.
CISA's assessment (SSVC)
Exploitation: none · Automatable: no · Technical impact: partial, assessed 2024-11-14. From CISA's Vulnrichment in the CVE List: whether it is exploited, whether exploiting it can be automated, and how much control it gives.
CWE
CWE-266 Incorrect Privilege Assignment
OWASP Top 10
A06:2025 Insecure Design
Published
Modified
NVD analysis
Analyzed, since modified
Record from
the NVD, synced

Fix and patched versions

Ask an AI about this CVE

Show the promptExplain CVE-2024-10978 for an engineer deciding whether to act. Use https://cve.bz/api/public/cves/CVE-2024-10978?via=ask-ai-copy and https://cve.bz/cve/CVE-2024-10978?via=ask-ai-copy as the source of truth: what is affected and which versions fix it, whether it is in CISA KEV, public exploits, and its EPSS (an internet-wide 30-day estimate of exploitation activity, not a forecast for my systems). If they give no fixed versions, use the CVE record https://cveawg.mitre.org/api/cve/CVE-2024-10978 or the vendor advisory, not third-party mirrors. Tell me how to check whether I am affected and how to verify a fix. Cite the sources and say where they are uncertain.

Opens a third-party assistant; its answer is its own, not cve.bz's. The prompt holds only this CVE's id and public links.

Affected

Versions

From the NVD's CPE matches.

ProductAffected
postgresql:postgresqlfrom 12.0 before 12.21
postgresql:postgresqlfrom 13.0 before 13.17
postgresql:postgresqlfrom 14.0 before 14.14
postgresql:postgresqlfrom 15.0 before 15.9
postgresql:postgresqlfrom 16.0 before 16.5
postgresql:postgresql17.0
postgresql:postgresql17.0:beta1
postgresql:postgresql17.0:beta2
postgresql:postgresql17.0:beta3
postgresql:postgresql17.0:rc1
debian:debian_linux11.0

Linux distributions

DistributionReleasePackageFixed inAdvisory
Debian11postgresql-1313.17-0+deb11u1DLA-3954-1
Debian12postgresql-1515.9-0+deb12u1DEBIAN-CVE-2024-10978 DSA-5812-1
Debian13postgresql-1717.1-1DEBIAN-CVE-2024-10978
Ubuntu20.04:LTSpostgresql-1212.22-0ubuntu0.20.04.1UBUNTU-CVE-2024-10978 USN-7132-1
Ubuntu22.04:LTSpostgresql-1414.15-0ubuntu0.22.04.1UBUNTU-CVE-2024-10978 USN-7132-1
Ubuntu24.04:LTSpostgresql-1616.6-0ubuntu0.24.04.1UBUNTU-CVE-2024-10978 USN-7132-1
UbuntuPro:14.04:LTSpostgresql-9.3no fix listedUBUNTU-CVE-2024-10978
UbuntuPro:16.04:LTSpostgresql-9.59.5.25-0ubuntu0.16.04.1+esm10UBUNTU-CVE-2024-10978 USN-7358-1
UbuntuPro:18.04:LTSpostgresql-10no fix listedUBUNTU-CVE-2024-10978
Red Hatenterprise_linux:8::appstreampg_repack, pg_repack-debuginfo, pg_repack-debugsource0:1.4.6-3.module+el8.9.0+19330+c97ddbdfRHSA-2024:10785
Red Hatenterprise_linux:8::appstreampg_repack, pg_repack-debuginfo, pg_repack-debugsource0:1.4.6-3.module+el8.9.0+20664+9c30cf7fRHSA-2024:10832
Red Hatenterprise_linux:8::appstreampg_repack, pg_repack-debuginfo, pg_repack-debugsource0:1.4.8-1.module+el8.9.0+19797+c4ce5969RHSA-2024:10830
Red Hatenterprise_linux:8::appstreampg_repack, pg_repack-debuginfo, pg_repack-debugsource0:1.5.1-1.module+el8.10.0+22551+c0330dc9RHSA-2024:10831
Red Hatenterprise_linux:8::appstreampgaudit, pgaudit-debuginfo, pgaudit-debugsource0:1.4.0-7.module+el8.10.0+22214+9beb89d6RHSA-2024:10785
Red Hatenterprise_linux:8::appstreampgaudit, pgaudit-debuginfo, pgaudit-debugsource0:1.5.0-1.module+el8.9.0+20664+9c30cf7fRHSA-2024:10832
Red Hatenterprise_linux:8::appstreampgaudit, pgaudit-debuginfo, pgaudit-debugsource0:1.7.0-1.module+el8.9.0+19797+c4ce5969RHSA-2024:10830
Red Hatenterprise_linux:8::appstreampgaudit, pgaudit-debuginfo, pgaudit-debugsource0:16.0-1.module+el8.10.0+20413+d8116364RHSA-2024:10831
Red Hatenterprise_linux:8::appstreampostgres-decoderbufs, postgres-decoderbufs-debuginfo, postgres-decoderbufs-debugsource0:0.10.0-2.module+el8.9.0+19330+c97ddbdfRHSA-2024:10785
Red Hatenterprise_linux:8::appstreampostgres-decoderbufs, postgres-decoderbufs-debuginfo, postgres-decoderbufs-debugsource0:0.10.0-2.module+el8.9.0+20664+9c30cf7fRHSA-2024:10832
Red Hatenterprise_linux:8::appstreampostgres-decoderbufs, postgres-decoderbufs-debuginfo, postgres-decoderbufs-debugsource0:1.9.7-1.Final.module+el8.9.0+19797+c4ce5969RHSA-2024:10830
Red Hatenterprise_linux:8::appstreampostgres-decoderbufs, postgres-decoderbufs-debuginfo, postgres-decoderbufs-debugsource0:2.4.0-1.Final.module+el8.10.0+20413+d8116364RHSA-2024:10831
15 more for Red Hat in the JSON and on Red Hat's page.
SUSEEnterprise Storage 7.1, Linux Enterprise High Performance Computing 15 SP2-LTSS, Linux Enterprise High Performance Computing 15 SP3-LTSS and 12 morepostgresql1414.15-150200.5.50.1SUSE-SU-2024:4176-1
SUSEEnterprise Storage 7.1, Linux Enterprise High Performance Computing 15 SP2-LTSS, Linux Enterprise High Performance Computing 15 SP3-LTSS and 8 morepostgresql1313.18-150200.5.64.1SUSE-SU-2024:4175-1
SUSEEnterprise Storage 7.1, Linux Enterprise High Performance Computing 15 SP2-LTSS, Linux Enterprise High Performance Computing 15 SP3-LTSS and 4 morepostgresql1212.22-150200.8.66.1SUSE-SU-2024:4099-1
SUSEEnterprise Storage 7.1, Linux Enterprise High Performance Computing 15 SP3-LTSS, Linux Enterprise High Performance Computing 15 SP4-ESPOS and 10 morepostgresql1616.6-150200.5.21.1SUSE-SU-2024:4173-1
SUSEEnterprise Storage 7.1, Linux Enterprise High Performance Computing 15 SP3-LTSS, Linux Enterprise High Performance Computing 15 SP4-ESPOS and 10 morepostgresql1717.2-150200.5.5.1SUSE-SU-2024:4173-1
SUSEEnterprise Storage 7.1, Linux Enterprise High Performance Computing 15 SP3-LTSS, Linux Enterprise High Performance Computing 15 SP4-ESPOS and 9 morepostgresql1515.10-150200.5.33.1SUSE-SU-2024:4174-1
SUSEEnterprise Storage 7.1, Linux Enterprise High Performance Computing 15 SP3-LTSS, Linux Enterprise Server 15 SP3-LTSS and 1 morepostgresql17-150300.10.27.1SUSE-SU-2024:4173-1
SUSELinux Enterprise High Performance Computing 15 SP2-LTSS, Linux Enterprise Server 15 SP2-LTSS, Linux Enterprise Server for SAP Applications 15 SP2postgresql17-150200.4.30.1SUSE-SU-2024:4173-1
SUSELinux Enterprise High Performance Computing 15 SP4-ESPOS, Linux Enterprise High Performance Computing 15 SP4-LTSS, Linux Enterprise Server 15 SP4-LTSS and 3 morepostgresql17-150400.4.18.1SUSE-SU-2024:4173-1
SUSELinux Enterprise Module for Basesystem 15 SP5, Linux Enterprise Module for Legacy 15 SP5, Linux Enterprise Module for Package Hub 15 SP5 and 1 morepostgresql17-150500.10.9.1SUSE-SU-2024:4173-1
SUSELinux Enterprise Module for Basesystem 15 SP6, Linux Enterprise Module for Package Hub 15 SP6, Linux Enterprise Module for Server Applications 15 SP6postgresql17-150600.17.6.1SUSE-SU-2024:4063-1
SUSELinux Enterprise Module for Basesystem 15 SP6, Linux Enterprise Module for Package Hub 15 SP6, Linux Enterprise Module for Server Applications 15 SP6postgresql1616.6-150600.16.10.1SUSE-SU-2024:4063-1
10 more for SUSE in the JSON and on SUSE's page.
openSUSELeap 15.5postgresql17-150500.10.9.1SUSE-SU-2024:4173-1
openSUSELeap 15.5postgresql1414.15-150200.5.50.1SUSE-SU-2024:4176-1
openSUSELeap 15.5postgresql1515.10-150200.5.33.1SUSE-SU-2024:4174-1
openSUSELeap 15.5postgresql1616.6-150200.5.21.1SUSE-SU-2024:4173-1
openSUSELeap 15.5postgresql1717.2-150200.5.5.1SUSE-SU-2024:4173-1
openSUSELeap 15.5, Leap 15.6postgresql1212.22-150200.8.66.1SUSE-SU-2024:4099-1
openSUSELeap 15.5, Leap 15.6postgresql1313.18-150200.5.64.1SUSE-SU-2024:4175-1
openSUSELeap 15.6postgresql17-150600.17.6.1SUSE-SU-2024:4063-1
openSUSELeap 15.6postgresql1414.15-150600.16.9.1SUSE-SU-2024:4118-1
openSUSELeap 15.6postgresql1515.10-150600.16.9.1SUSE-SU-2024:4098-1
openSUSELeap 15.6postgresql1616.6-150600.16.10.1SUSE-SU-2024:4063-1
openSUSELeap 15.6postgresql1717.2-150600.13.5.1SUSE-SU-2024:4063-1
6 more for openSUSE in the JSON and on openSUSE's page.
AlmaLinux8pg_repack1.4.6-3.module_el8.6.0+2760+1746ec94ALSA-2024:10785 ALSA-2024:10832
AlmaLinux8pg_repack1.4.6-3.module_el8.9.0+3704+f1f917ceALSA-2024:10785 ALSA-2024:10832
AlmaLinux8pg_repack1.4.8-1.module_el8.10.0+3798+606ebb9fALSA-2024:10830
AlmaLinux8pg_repack1.4.8-1.module_el8.9.0+3706+885c732eALSA-2024:10830
AlmaLinux8pg_repack1.5.1-1.module_el8.10.0+3930+ecf33554ALSA-2024:10831
AlmaLinux8pgaudit1.4.0-7.module_el8.10.0+3889+48cb11fb.alma.1ALSA-2024:10785
AlmaLinux8pgaudit1.4.0-7.module_el8.9.0+3740+0e74851f.alma.1ALSA-2024:10785
AlmaLinux8pgaudit1.5.0-1.module_el8.6.0+2760+1746ec94ALSA-2024:10832
AlmaLinux8pgaudit1.5.0-1.module_el8.6.0+3095+ee60d910ALSA-2024:10832
AlmaLinux8pgaudit1.7.0-1.module_el8.9.0+3706+885c732eALSA-2024:10830
AlmaLinux8pgaudit16.0-1.module_el8.10.0+3798+606ebb9fALSA-2024:10831
AlmaLinux8postgres-decoderbufs0.10.0-2.module_el8.6.0+2760+1746ec94ALSA-2024:10785 ALSA-2024:10832
20 more for AlmaLinux in the JSON.
Rocky Linux8pg_repack0:1.4.6-3.module+el8.10.0+1862+29bef648RLSA-2024:10785
Rocky Linux8pg_repack0:1.4.8-1.module+el8.10.0+1622+bd25b19cRLSA-2024:10830
Rocky Linux8pg_repack0:1.5.1-1.module+el8.10.0+1900+d7340343RLSA-2024:10831
Rocky Linux8pgaudit0:1.4.0-7.module+el8.9.0+1735+a332307bRLSA-2024:10785
Rocky Linux8pgaudit0:1.7.0-1.module+el8.9.0+1525+fc91df60RLSA-2024:10830
Rocky Linux8pgaudit0:16.0-1.module+el8.10.0+1622+bd25b19cRLSA-2024:10831
Rocky Linux8postgres-decoderbufs0:0.10.0-2.module+el8.10.0+1862+29bef648RLSA-2024:10785
Rocky Linux8postgres-decoderbufs0:1.9.7-1.Final.module+el8.9.0+1525+fc91df60RLSA-2024:10830
Rocky Linux8postgres-decoderbufs0:2.4.0-1.Final.module+el8.10.0+1622+bd25b19cRLSA-2024:10831
Rocky Linux8postgresql0:12.22-1.module+el8.10.0+1897+c7883fdeRLSA-2024:10785
Rocky Linux8postgresql0:15.10-1.module+el8.10.0+1899+05bbdd2cRLSA-2024:10830
Rocky Linux8postgresql0:16.6-1.module+el8.10.0+1900+d7340343RLSA-2024:10831
7 more for Rocky Linux in the JSON.
Alpinev3.17, v3.18, v3.19postgresql1313.17-r0ALPINE-CVE-2024-10978
Alpinev3.17, v3.18, v3.19 and 1 morepostgresql1414.14-r0ALPINE-CVE-2024-10978
Alpinev3.17, v3.18, v3.19 and 3 morepostgresql1515.9-r0ALPINE-CVE-2024-10978
Alpinev3.19, v3.20, v3.21 and 3 morepostgresql1616.5-r0ALPINE-CVE-2024-10978
Alpinev3.21, v3.22, v3.23 and 1 morepostgresql1717.1-r0ALPINE-CVE-2024-10978
Azure Linux2postgresql14.14-1AZL-53204
Azure Linux3postgresql16.5-1AZL-53209
Alpaquita23postgresql1515.9-r0BELL-CVE-2024-10978
Alpaquitastreampostgresql1717.1-r0BELL-CVE-2024-10978

From the distributions' data via OSV.dev: the Debian Security Tracker; Ubuntu Security Notices © Canonical Ltd., CC BY-SA 4.0; Red Hat Security Data © Red Hat, Inc., CC BY 4.0; SUSE security data, CC BY 4.0; AlmaLinux's OSV database, MIT; Rocky Linux's errata, BSD-3-Clause; the Alpine secdb, CC BY-SA 4.0; Microsoft's Azure Linux vulnerability data, MIT; BellSoft's OSV database, MIT. Modified: reformatted and linked to CVE records. Credits. On the distributions' own pages: Debian · Ubuntu · Red Hat · SUSE · openSUSE · Alpine · Alpaquita.

Red Hat

Red Hat rates this Moderate.

Red Hat's statement

Impact: Moderate. In Red Hat Enterprise Linux, PostgreSQL is affected by a flaw in which a less-privileged application user can view or modify unintended rows when an application uses SET ROLE, SET SESSION AUTHORIZATION, or an equivalent feature and attacker-influenced parameters or query results cause a query to depend on current_setting('role') or the current user ID. The CVSS 3.1 score is 4.2 (AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N), reflecting network reachability, low privileges, and high attack complexity, with limited confidentiality and integrity impact and no availability impact. The current affects mark PostgreSQL as affected in the Red Hat Enterprise Linux update streams represented for RHEL 8, RHEL 9, and RHEL for Business 10; community-project packages are delegated to upstream. For Red Hat In-Vehicle OS, remediation is deferred with the tracker resolved as "Won't Do"; the record gives no more specific deferral rationale, and residual risk remains that a qualifying less-privileged application user could access or change unintended rows. For the delegated affected products, a fix is being pursued.

Red Hat's mitigation

Mitigation for this issue is either not available or the currently available options don't meet the Red Hat Product Security criteria comprising ease of use and deployment, applicability to widespread installation base or stability.

ProductPackageStateAdvisory
Red Hat Enterprise Linux 8postgresql:12-8100020241122084405.489197e6Fixed 2024-12-04RHSA-2024:10785
Red Hat Enterprise Linux 8postgresql:15-8100020241122084744.489197e6Fixed 2024-12-05RHSA-2024:10830
Red Hat Enterprise Linux 8postgresql:16-8100020241122085009.489197e6Fixed 2024-12-05RHSA-2024:10831
Red Hat Enterprise Linux 8postgresql:13-8100020241122084628.489197e6Fixed 2024-12-05RHSA-2024:10832
Red Hat Enterprise Linux 9postgresql:15-9050020241122141928.rhel9Fixed 2024-12-04RHSA-2024:10787
Red Hat Enterprise Linux 9postgresql:16-9050020241122142517.rhel9Fixed 2024-12-04RHSA-2024:10788
Red Hat Enterprise Linux 9postgresql-0:13.18-1.el9_5Fixed 2024-12-04RHSA-2024:10791
Red Hat Enterprise Linux 7postgresqlOut of support scope

Contains Red Hat Security Data © Red Hat, Inc., licensed under CC BY 4.0. Source: https://access.redhat.com/security/data. Modified: reformatted. Red Hat's page for CVE-2024-10978.

References

Check your stackJSON