BlackTreeCVE Intelligence
← Back to the CVE catalogue
Full vulnerability report · 2024
CVE-2024-10978High confidence

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

Unknown · PostgreSQL

4.2MediumCVSS 3.1
Recommended action
Scheduled

Medium technical severity with no CISA KEV confirmation; remediate through the normal risk-based patch cycle unless local exposure raises the priority.

Fix not verified
R
Operational reassessment

Published severity in operational context

Open reassessment dashboard →
Published severityMediumOperational priority:Medium, unchanged from published severity.unchanged

Evidence used

  • No CISA KEV confirmation is currently recorded.
  • EPSS is 0.69% for the current model date.

Compensating controls

  • Restrict the affected network interface to trusted sources where business-safe.
  • Monitor vendor guidance and exploitation sources for a material change.

Verification

  1. Confirm that the asset runs Unknown PostgreSQL and falls inside the recorded affected range.
  2. Recheck the vendor advisory before scheduling a change because no verified fixed version is currently retained.
  3. Validate exposure, authentication requirements and compensating controls in the actual environment.
  4. Reopen this reassessment when CVSS, KEV, EPSS, exploit evidence or remediation changes.
Mitigation target: As exposure requiresRemediation target: Within 365 days

This automated reassessment organises public evidence. It does not know asset exposure, business impact or control effectiveness and does not replace CVSS or a human risk decision.

Distribution package intelligence

Release-specific package status

Alpine, Debian, ubuntu findings are scoped to the named distribution, release and source package. An absent finding does not mean a package is unaffected.

11 package states
Repository candidate not checked

A published vendor fix does not prove that a matching update is enabled and installable on a particular asset. Confirm the local package candidate before scheduling remediation.

Distribution releaseSource packageVendor stateFixed versionEvidence
Alpine v3.23v3.23 · communitypostgresql16Vendor fix publishedAlpine records a security fix at this version. An absent entry does not mean the package is unaffected.16.5-r0Alpine Security Database ↗Source updated 11 Sep 2026
Alpine v3.23v3.23 · mainpostgresql17Vendor fix publishedAlpine records a security fix at this version. An absent entry does not mean the package is unaffected.17.1-r0Alpine Security Database ↗Source updated 3 Oct 2026
Alpine v3.22v3.22 · communitypostgresql15Vendor fix publishedAlpine records a security fix at this version. An absent entry does not mean the package is unaffected.15.9-r0Alpine Security Database ↗Source updated 11 Sep 2026
Alpine v3.22v3.22 · mainpostgresql16Vendor fix publishedAlpine records a security fix at this version. An absent entry does not mean the package is unaffected.16.5-r0Alpine Security Database ↗Source updated 3 Oct 2026
Alpine v3.22v3.22 · mainpostgresql17Vendor fix publishedAlpine records a security fix at this version. An absent entry does not mean the package is unaffected.17.1-r0Alpine Security Database ↗Source updated 3 Oct 2026
Alpine v3.21v3.21 · communitypostgresql15Vendor fix publishedAlpine records a security fix at this version. An absent entry does not mean the package is unaffected.15.9-r0Alpine Security Database ↗Source updated 19 Aug 2026
Alpine v3.21v3.21 · mainpostgresql16Vendor fix publishedAlpine records a security fix at this version. An absent entry does not mean the package is unaffected.16.5-r0Alpine Security Database ↗Source updated 3 Oct 2026
Alpine v3.21v3.21 · mainpostgresql17Vendor fix publishedAlpine records a security fix at this version. An absent entry does not mean the package is unaffected.17.1-r0Alpine Security Database ↗Source updated 3 Oct 2026
Debian trixietrixie · sourcepostgresql-17Vendor fix publishedDebian records a fixed source-package version for this release.17.1-1Debian Security Tracker ↗Source updated 6 Oct 2026
Debian bookwormbookworm · sourcepostgresql-15Vendor fix publishedDebian records a fixed source-package version for this release.15.9-0+deb12u1Debian Security Tracker ↗Source updated 6 Oct 2026
Ubuntu 24.04 LTSnoble · standard archivepostgresql-16Vendor fix publishedCanonical reports that a fixed source package version has been published. Repository candidate availability is not checked by BlackTree.16.6-0ubuntu0.24.04.1Canonical Ubuntu Security ↗Source updated 5 Oct 2026
Optional official sources

National CERT insights
?CERT means Computer Emergency Response Team; CSIRT is the closely related term Computer Security Incident Response Team.

Choose official national sources for this report. Each advisory shows its original language. Your selection is remembered on this device and included in shared links.

Official European source

ENISA European Vulnerability Database

Official EUVD identifiers, advisory evidence and known-exploited context. Missing fields are not treated as evidence of low risk.

1 current
ENISA EUVD identifier

EUVD-2024-33376

No EUVD known-exploited evidence

ENISA has published the identifier mapping but no EUVD description has been stored yet.

EUVD state
Present in the current official mapping
Known exploitation
Not present in the current ENISA EUVD known-exploited dataset. This is not proof of no exploitation.
ENISA score
Not supplied in the stored EUVD record
Advisory evidence
No linked advisory details stored yet
Recommended actionScheduled

Medium technical severity with no CISA KEV confirmation; remediate through the normal risk-based patch cycle unless local exposure raises the priority.

Fix not verified
01

What, why and how

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.

What

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.

Why

A product incorrectly assigns a privilege to a particular actor, creating an unintended sphere of control for that actor.

How

An attacker operating through a network path may attempt exploitation with low privileges. If successful, the issue may cause the confidentiality, integrity or availability impact described by the vendor.

What

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.

Why

A product incorrectly assigns a privilege to a particular actor, creating an unintended sphere of control for that actor.

How

An attacker operating through a network path may attempt exploitation with low privileges. If successful, the issue may cause the confidentiality, integrity or availability impact described by the vendor.

02

Exploit reality and attack path

CVSS severity, EPSS forecast probability, public exploit material and CISA-confirmed exploitation are separate signals.

Observed exploitation
?Confirmed exploitation and public exploit material are separate signals. Attacks can occur without public proof-of-concept or exploit code.
No confirmed evidence

No CISA KEV match was present at the last successful refresh. This means no confirmation from that source, not proof of no exploitation.

Public PoC / exploit material
?Confirmed exploitation and public exploit material are separate signals. Attacks can occur without public proof-of-concept or exploit code.
None recorded

No exploit-tagged reference or CISA SSVC proof-of-concept state is currently recorded. Research may still exist outside the structured feeds.

Likely attack path
a network path → Incorrect Privilege Assignment → cause the confidentiality, integrity or availability impact described by the vendor
Attack surface
Network
Privileges required
Low: a basic authenticated account is required
User interaction
None
Attack complexity
High: exploitation depends on specific conditions
Security boundary
Unchanged: impact remains within the vulnerable component's security authority
Weakness
?CWE means Common Weakness Enumeration: a standard category for the underlying weakness.
CWE-266 ↗

CWE-266: Incorrect Privilege Assignment. A product incorrectly assigns a privilege to a particular actor, creating an unintended sphere of control for that actor.

CVSS vector
?CVSS means Common Vulnerability Scoring System. The vector records the metric values used to calculate technical severity.
CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N

Common Vulnerability Scoring System 3.1: the compact vector below is decoded into plain language.

AVNetworkAttack vector: The vulnerable component can be reached over a network.ACHighAttack complexity: Successful exploitation depends on specific conditions outside the attacker's direct control.PRLowPrivileges required: The attacker needs basic user-level privileges.UINoneUser interaction: No action by another user is required.SUnchangedScope: The security impact remains within the vulnerable component's authority.CLowConfidentiality impact: A successful attack can cause a limited loss.ILowIntegrity impact: A successful attack can cause a limited loss.ANoneAvailability impact: No direct loss is represented by this metric.
Post-exploitation / living off the land
No specific living-off-the-land technique is confirmed in the structured sources. Monitor normal administration tools for activity inconsistent with the affected service's baseline.
NetworkCWE-266
A

Official authority intelligence

Only matched European and national findings are included. Language selectors and unavailable sources are omitted.

BSI · German · WID-SEC-2024-3475PostgreSQL: Mehrere Schwachstellen

Ein entfernter Angreifer kann mehrere Schwachstellen in PostgreSQL ausnutzen, um beliebigen Code auszuführen, Sicherheitsmaßnahmen zu umgehen, Daten zu manipulieren oder vertrauliche Informationen preiszugeben.

Official advisory ↗
Cyber Security Agency of Singapore · English · CSA-SB-20241120Security Bulletin 20 Nov 2024

The Cyber Security Agency of Singapore included this CVE in its official Security Bulletin 20 Nov 2024, published on 20 November 2024. Open the linked bulletin for the product, severity and reference information published in that issue.

Official advisory ↗
CERT-FR · French · CERTFR-2026-AVI-0109Multiples vulnérabilités dans les produits IBM

ecord?id=CVE-2022-37601 Référence CVE CVE-2022-38900 https://www.cve.org/CVERecord?id=CVE-2022-38900 Référence CVE CVE-2022-41721 https://www.cve.org/CVERecord?id=CVE-2022-41721 Référence CVE CVE-2023-1370 https://www.cve.org/CVERecord?id=CVE-2023-1370 Référence CVE CVE-2023-2455 https://www.cve.org/CVERecord?id=CVE-2023-2455 Référence CVE CVE-2023-26136 https://www.cve.org/CVERecord?id=CVE-2023-26136 Référence CVE CVE-2023-48795 https://www.cve.org/CVERecord?id=CVE-2023-48795 Référence CVE CVE-2024-10976 https://www.cve.org/CVERecord?id=CVE-2024-10976 Référence CVE CVE-2024-10977 https://www.cve.org/CVERecord?id=CVE-2024-10977 Référence CVE CVE-2024-10978 https://www.cve.org/CVERecord?id=CVE-2024-10978 Référence CVE CVE-2024-10979 https://www.cve.org/CVERecord?id=CVE-2024-10979 Référence CVE CVE-2024-13009 https://www.cve.org/CVERecord?id=CVE-2024-13009 Référence CVE CVE-2024-30171 https://www.cve.org/CVERecord?id=CVE-2024-30171 Référence CVE CVE-2024-30172 https://www.cve.org/CVERecord?id=CVE-2024-30172 Référence CVE CVE-2024-37071 https://www.cve.org/CVERecord?id=CVE-2024-37071 Référence CVE CVE-2024-38809 https://www.cve.org/CVERecord?id=CVE-2024-38809 Référence CVE CVE-2024-38816 https://www.cve.org/CVERecord?id=CVE-2024-38816 Référence CVE CVE-2024-38820 https://www.cve.org/CVERecord?id=

Official advisory ↗
CERT-FR · French · CERTFR-2025-AVI-1036Multiples vulnérabilités dans les produits VMware

m/web/ecx/support-content-notification/-/external/content/SecurityAdvisories/0/36536 Bulletin de sécurité VMware 36537 du 24 novembre 2025 https://support.broadcom.com/web/ecx/support-content-notification/-/external/content/SecurityAdvisories/0/36537 Référence CVE CVE-2022-29526 https://www.cve.org/CVERecord?id=CVE-2022-29526 Référence CVE CVE-2022-40897 https://www.cve.org/CVERecord?id=CVE-2022-40897 Référence CVE CVE-2023-27043 https://www.cve.org/CVERecord?id=CVE-2023-27043 Référence CVE CVE-2024-10976 https://www.cve.org/CVERecord?id=CVE-2024-10976 Référence CVE CVE-2024-10977 https://www.cve.org/CVERecord?id=CVE-2024-10977 Référence CVE CVE-2024-10978 https://www.cve.org/CVERecord?id=CVE-2024-10978 Référence CVE CVE-2024-10979 https://www.cve.org/CVERecord?id=CVE-2024-10979 Référence CVE CVE-2024-12254 https://www.cve.org/CVERecord?id=CVE-2024-12254 Référence CVE CVE-2024-12718 https://www.cve.org/CVERecord?id=CVE-2024-12718 Référence CVE CVE-2024-13176 https://www.cve.org/CVERecord?id=CVE-2024-13176 Référence CVE CVE-2024-24789 https://www.cve.org/CVERecord?id=CVE-2024-24789 Référence CVE CVE-2024-24790 https://www.cve.org/CVERecord?id=CVE-2024-24790 Référence CVE CVE-2024-24791 https://www.cve.org/CVERecord?id=CVE-2024-24791 Référence CVE CVE-2024-2511 https://www.cve.org/CVERecord?id=C

Official advisory ↗
CERT-FR · French · CERTFR-2025-AVI-0580Multiples vulnérabilités dans VMware Tanzu

De multiples vulnérabilités ont été découvertes dans VMware Tanzu. Certaines d'entre elles permettent à un attaquant de provoquer une exécution de code arbitraire à distance, un déni de service à distance et une atteinte à la confidentialité des données.

Official advisory ↗
CERT-FR · French · CERTFR-2025-AVI-0524Multiples vulnérabilités dans VMware Tanzu

/CVERecord?id=CVE-2023-6228 Référence CVE CVE-2023-6237 https://www.cve.org/CVERecord?id=CVE-2023-6237 Référence CVE CVE-2023-6879 https://www.cve.org/CVERecord?id=CVE-2023-6879 Référence CVE CVE-2023-7008 https://www.cve.org/CVERecord?id=CVE-2023-7008 Référence CVE CVE-2024-0727 https://www.cve.org/CVERecord?id=CVE-2024-0727 Référence CVE CVE-2024-10041 https://www.cve.org/CVERecord?id=CVE-2024-10041 Référence CVE CVE-2024-10963 https://www.cve.org/CVERecord?id=CVE-2024-10963 Référence CVE CVE-2024-10976 https://www.cve.org/CVERecord?id=CVE-2024-10976 Référence CVE CVE-2024-10977 https://www.cve.org/CVERecord?id=CVE-2024-10977 Référence CVE CVE-2024-10978 https://www.cve.org/CVERecord?id=CVE-2024-10978 Référence CVE CVE-2024-10979 https://www.cve.org/CVERecord?id=CVE-2024-10979 Référence CVE CVE-2024-11168 https://www.cve.org/CVERecord?id=CVE-2024-11168 Référence CVE CVE-2024-12133 https://www.cve.org/CVERecord?id=CVE-2024-12133 Référence CVE CVE-2024-12243 https://www.cve.org/CVERecord?id=CVE-2024-12243 Référence CVE CVE-2024-12797 https://www.cve.org/CVERecord?id=CVE-2024-12797 Référence CVE CVE-2024-13176 https://www.cve.org/CVERecord?id=CVE-2024-13176 Référence CVE CVE-2024-1580 https://www.cve.org/CVERecord?id=CVE-2024-1580 Référence CVE CVE-2024-2236 https://www.cve.org/CVERecord?id=CVE

Official advisory ↗
CERT-FR · French · CERTFR-2025-AVI-0401Multiples vulnérabilités dans Juniper Networks Secure Analytics

g/CVERecord?id=CVE-2023-52922 Référence CVE CVE-2023-5868 https://www.cve.org/CVERecord?id=CVE-2023-5868 Référence CVE CVE-2023-5869 https://www.cve.org/CVERecord?id=CVE-2023-5869 Référence CVE CVE-2023-5870 https://www.cve.org/CVERecord?id=CVE-2023-5870 Référence CVE CVE-2023-7104 https://www.cve.org/CVERecord?id=CVE-2023-7104 Référence CVE CVE-2024-0985 https://www.cve.org/CVERecord?id=CVE-2024-0985 Référence CVE CVE-2024-10917 https://www.cve.org/CVERecord?id=CVE-2024-10917 Référence CVE CVE-2024-10976 https://www.cve.org/CVERecord?id=CVE-2024-10976 Référence CVE CVE-2024-10977 https://www.cve.org/CVERecord?id=CVE-2024-10977 Référence CVE CVE-2024-10978 https://www.cve.org/CVERecord?id=CVE-2024-10978 Référence CVE CVE-2024-10979 https://www.cve.org/CVERecord?id=CVE-2024-10979 Référence CVE CVE-2024-11187 https://www.cve.org/CVERecord?id=CVE-2024-11187 Référence CVE CVE-2024-11218 https://www.cve.org/CVERecord?id=CVE-2024-11218 Référence CVE CVE-2024-12085 https://www.cve.org/CVERecord?id=CVE-2024-12085 Référence CVE CVE-2024-1488 https://www.cve.org/CVERecord?id=CVE-2024-1488 Référence CVE CVE-2024-21208 https://www.cve.org/CVERecord?id=CVE-2024-21208 Référence CVE CVE-2024-21210 https://www.cve.org/CVERecord?id=CVE-2024-21210 Référence CVE CVE-2024-21217 https://www.cve.org/CVERecord?id=CV

Official advisory ↗
CERT-FR · French · CERTFR-2025-AVI-0106Multiples vulnérabilités dans les produits IBM

g/CVERecord?id=CVE-2023-52922 Référence CVE CVE-2023-5868 https://www.cve.org/CVERecord?id=CVE-2023-5868 Référence CVE CVE-2023-5869 https://www.cve.org/CVERecord?id=CVE-2023-5869 Référence CVE CVE-2023-5870 https://www.cve.org/CVERecord?id=CVE-2023-5870 Référence CVE CVE-2023-7104 https://www.cve.org/CVERecord?id=CVE-2023-7104 Référence CVE CVE-2024-0985 https://www.cve.org/CVERecord?id=CVE-2024-0985 Référence CVE CVE-2024-10041 https://www.cve.org/CVERecord?id=CVE-2024-10041 Référence CVE CVE-2024-10976 https://www.cve.org/CVERecord?id=CVE-2024-10976 Référence CVE CVE-2024-10977 https://www.cve.org/CVERecord?id=CVE-2024-10977 Référence CVE CVE-2024-10978 https://www.cve.org/CVERecord?id=CVE-2024-10978 Référence CVE CVE-2024-10979 https://www.cve.org/CVERecord?id=CVE-2024-10979 Référence CVE CVE-2024-22353 https://www.cve.org/CVERecord?id=CVE-2024-22353 Référence CVE CVE-2024-22354 https://www.cve.org/CVERecord?id=CVE-2024-22354 Référence CVE CVE-2024-24786 https://www.cve.org/CVERecord?id=CVE-2024-24786 Référence CVE CVE-2024-24857 https://www.cve.org/CVERecord?id=CVE-2024-24857 Référence CVE CVE-2024-25026 https://www.cve.org/CVERecord?id=CVE-2024-25026 Référence CVE CVE-2024-26615 https://www.cve.org/CVERecord?id=CVE-2024-26615 Référence CVE CVE-2024-26851 https://www.cve.org/CVERecord?id=

Official advisory ↗
CERT-FR · French · CERTFR-2024-AVI-0987Multiples vulnérabilités dans PostgreSQL

De multiples vulnérabilités ont été découvertes dans PostgreSQL. Certaines d'entre elles permettent à un attaquant de provoquer une exécution de code arbitraire à distance, une atteinte à l'intégrité des données et un contournement de la politique de sécurité.

Official advisory ↗
JVN iPedia · Japanese · JVNDB-2024-019283PostgreSQL.org の PostgreSQL 等複数ベンダの製品における脆弱性

PostgreSQL.org の PostgreSQL 等複数ベンダの製品には、不特定の脆弱性が存在します。

Official advisory ↗
03

Patch and workaround

Operational remediation based on structured source evidence.

Status
?Patch availability is based on structured fixed-version fields and authoritative update references. If no fix is verified, check the vendor advisory before making a change.
Fix not verified
Affected
PostgreSQL: 17 < 17.1, 16 < 16.5, 15 < 15.9, 14 < 14.14, 13 < 13.17, < 12.21
Fixed
No fixed version is explicitly recorded in the structured CVE data.
Action
No verified patch reference is present in the current structured sources. Check the vendor advisory before making a change.
Workaround
No verified workaround is recorded. If business-safe, reduce exposure to the affected interface and allow only trusted sources until authoritative guidance is available.
04

Evidence and provenance

Published 14 Nov 2024 · Last source change 3 Nov 2025, 21:51 UTC · CWE-266 · Incorrect Privilege Assignment

CVE recordCVE.org · 5.2
CVSS sourceCNA
EPSS source
?The date BlackTree first stored a score for this CVE from the daily FIRST EPSS feed.
FIRST · tracked since 2026-08-14
European sourceENISA EUVD · EUVD-2024-33376
Product sourceCNA
Remediation sourceCVE/CNA references
CWE sourceCNA
NVD statusNVD modified after enrichment

Missing structured fields: affected product. Missing data is not evidence of low risk; review the primary advisory.

Material change intelligence

What changed after publication

View recent updates ↗

No material field changes have been recorded since change tracking began. Routine source refreshes and cosmetic edits are intentionally excluded.

Material fields only · duplicate refreshes suppressed · history retained for the configured operational retention period
Technical terms and abbreviations used in this report
CVE
Common Vulnerabilities and Exposures: the public identifier for one disclosed vulnerability.
CVSS
Common Vulnerability Scoring System: a technical severity framework; it is not patching priority by itself.
EPSS
Exploit Prediction Scoring System: FIRST's estimate of the probability that exploitation activity will be observed in the next 30 days; it is a forecast, not confirmation.
CWE
Common Weakness Enumeration: the standard category describing the underlying software or hardware weakness.
CNA
CVE Numbering Authority: an organisation authorised to assign and publish CVE records.
CISA ADP
Cybersecurity and Infrastructure Security Agency Authorized Data Publisher: structured enrichment added to a CVE record.
NVD
National Vulnerability Database: NIST's enrichment service for CVE records.
CERT / CSIRT
A computer security incident response team that publishes warnings or coordinates incident response.
PoC
Proof of concept: public material that demonstrates or helps reproduce exploitation.
CSAF
Common Security Advisory Framework: a machine-readable format for security advisories.
LoTL
Living off the land: abuse of legitimate tools or system functions during an attack.
Free version - for non-commercial use only.CVE-2024-10978 · cve.blacktree.nl