CVE-2024-10978
PostgreSQL SET ROLE, SET SESSION AUTHORIZATION reset to wrong user ID
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.
Exposure status: unknown. This page does not establish whether an installed system is affected or corrected.
Severity and exploitation evidence
EPSS: 0.690% · score date 2026-11-19. EPSS is an estimated probability over the next 30 days, not proof of exploitation.
CISA KEV: not included in the checked catalog; exploitation may still occur. Last checked: 2026-11-19T17:59:58.648Z. Public exploit availability is not used to set this status.
CVSS 3.1 · 4.2 · published by PostgreSQLCVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N
Assessment source · checked 2026-11-19T12:01:26.311Z
CVSS 3.1 · 4.2 · published by Ubuntu SecurityCVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N
Assessment source · checked 2026-11-19T16:01:08.293Z
Verification by field
| Field | Status | Checked at (UTC) | Source |
|---|---|---|---|
| kev | verified | 2026-11-19T17:59:58.648Z | CISA KEV |
| cvss | verified | 2026-11-19T12:01:26.311Z | CVE Program |
| epss | verified | 2026-11-19T16:04:37.769Z | FIRST EPSS |
| patches | verified | 2026-11-19T16:01:08.293Z | Ubuntu Security |
| affected | verified | 2026-11-19T12:01:26.311Z | CVE Program |
| lifecycle | verified | 2026-11-19T12:01:26.311Z | CVE Program |
Affected versions and configuration
n/a PostgreSQL; default status: unaffected: 17 to < 17.1 [affected; scheme: rpm]; 16 to < 16.5 [affected; scheme: rpm]; 15 to < 15.9 [affected; scheme: rpm]; 14 to < 14.14 [affected; scheme: rpm]; 13 to < 13.17 [affected; scheme: rpm]; 0 to < 12.21 [affected; scheme: rpm]
Defaults, conditional configuration, package status and version schemes are retained below. A version range alone is not an exposure verdict.
Ubuntu Security · ubuntu-package · full conditions
[
{
"name": "postgresql-17",
"debian": "https://tracker.debian.org/pkg/postgresql-17",
"source": "https://ubuntu.com/security/cve?package=postgresql-17",
"ubuntu": "https://packages.ubuntu.com/search?suite=all§ion=all&arch=any&searchon=sourcenames&keywords=postgresql-17",
"statuses": [
{
"pocket": "security",
"status": "DNE",
"component": null,
"description": "",
"release_codename": "stonking"
},
{
"pocket": "security",
"status": "DNE",
"component": null,
"description": "",
"release_codename": "focal"
},
{
"pocket": "security",
"status": "DNE",
"component": null,
"description": "",
"release_codename": "jammy"
},
{
"pocket": "security",
"status": "DNE",
"component": null,
"description": "",
"release_codename": "noble"
},
{
"pocket": "security",
"status": "DNE",
"component": null,
"description": "",
"release_codename": "oracular"
},
{
"pocket": "security",
"status": "released",
"component": null,
"description": "17.1",
"release_codename": "upstream"
},
{
"pocket": "security",
"status": "not-affected",
"component": null,
"description": "17.2-1",
"release_codename": "plucky"
},
{
"pocket": "security",
"status": "not-affected",
"component": null,
"description": "17.2-1",
"release_codename": "questing"
},
{
"pocket": "security",
"status": "DNE",
"component": null,
"description": "",
"release_codename": "resolute"
}
]
}
]Archived source JSONOSV · osv · full conditions
{
"id": "DEBIAN-CVE-2024-10978",
"aliases": [],
"affected": [
{
"ranges": [
{
"type": "ECOSYSTEM",
"events": [
{
"introduced": "0"
},
{
"fixed": "17.1-1"
}
]
}
],
"package": {
"name": "postgresql-17",
"purl": "pkg:deb/debian/postgresql-17?arch=source&distro=trixie",
"ecosystem": "Debian:13"
},
"versions": [],
"database_specific": {
"source": "https://storage.googleapis.com/debian-osv/debian-cve-osv/DEBIAN-CVE-2024-10978.json"
},
"ecosystem_specific": {
"urgency": "not yet assigned"
}
}
],
"severity": [
{
"type": "CVSS_V3",
"score": "CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N"
}
],
"upstream": [
"CVE-2024-10978"
],
"withdrawn": null,
"references": [
{
"url": "https://security-tracker.debian.org/tracker/CVE-2024-10978",
"type": "ADVISORY"
}
],
"relatedGitRanges": [],
"database_specific": {}
}Archived source JSONOSV · osv · full conditions
{
"id": "DEBIAN-CVE-2024-10978",
"aliases": [],
"affected": [
{
"ranges": [
{
"type": "ECOSYSTEM",
"events": [
{
"introduced": "0"
},
{
"fixed": "15.9-0+deb12u1"
}
]
}
],
"package": {
"name": "postgresql-15",
"purl": "pkg:deb/debian/postgresql-15?arch=source&distro=bookworm",
"ecosystem": "Debian:12"
},
"versions": [
"15.3-0+deb12u1",
"15.3-1",
"15.4-0+deb12u1",
"15.4-1",
"15.4-2",
"15.4-3",
"15.5-0+deb12u1",
"15.6-0+deb12u1",
"15.7-0+deb12u1",
"15.8-0+deb12u1"
],
"database_specific": {
"source": "https://storage.googleapis.com/debian-osv/debian-cve-osv/DEBIAN-CVE-2024-10978.json"
},
"ecosystem_specific": {
"urgency": "not yet assigned"
}
}
],
"severity": [
{
"type": "CVSS_V3",
"score": "CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N"
}
],
"upstream": [
"CVE-2024-10978"
],
"withdrawn": null,
"references": [
{
"url": "https://security-tracker.debian.org/tracker/CVE-2024-10978",
"type": "ADVISORY"
}
],
"relatedGitRanges": [],
"database_specific": {}
}Archived source JSONCVE Program · cve-json · full conditions
{
"affected": [
{
"vendor": "n/a",
"product": "PostgreSQL",
"versions": [
{
"status": "affected",
"version": "17",
"lessThan": "17.1",
"versionType": "rpm"
},
{
"status": "affected",
"version": "16",
"lessThan": "16.5",
"versionType": "rpm"
},
{
"status": "affected",
"version": "15",
"lessThan": "15.9",
"versionType": "rpm"
},
{
"status": "affected",
"version": "14",
"lessThan": "14.14",
"versionType": "rpm"
},
{
"status": "affected",
"version": "13",
"lessThan": "13.17",
"versionType": "rpm"
},
{
"status": "affected",
"version": "0",
"lessThan": "12.21",
"versionType": "rpm"
}
],
"defaultStatus": "unaffected"
}
],
"additionalContainers": [
{
"title": "CISA ADP Vulnrichment",
"metrics": [
{
"other": {
"type": "ssvc",
"content": {
"id": "CVE-2024-10978",
"role": "CISA Coordinator",
"options": [
{
"Exploitation": "none"
},
{
"Automatable": "no"
},
{
"Technical Impact": "partial"
}
],
"version": "2.0.3",
"timestamp": "2024-11-14T18:53:38.409914Z"
}
}
}
],
"providerMetadata": {
"orgId": "134c704f-9b21-4f2e-91b3-4a467353bcc0",
"shortName": "CISA-ADP",
"dateUpdated": "2024-11-14T19:29:16.719Z"
}
},
{
"title": "CVE Program Container",
"references": [
{
"url": "https://www.postgresql.org/message-id/173171334532.1547978.1518068370217143844%40wrigleys.postgresql.org"
},
{
"url": "https://lists.debian.org/debian-lts-announce/2024/11/msg00018.html"
},
{
"url": "https://lists.debian.org/debian-lts-announce/2024/11/msg00011.html"
}
],
"providerMetadata": {
"orgId": "af854a3a-2127-422b-91ae-364da2661108",
"shortName": "CVE",
"dateUpdated": "2025-11-03T21:51:39.867Z"
}
}
]
}Archived source JSONCorrection evidence
Distribution packages and upstream releases are distinct. ESM channels may require the corresponding Ubuntu entitlement. Notes and branch ranges are not installable package versions. OSV fixed boundaries are ecosystem-specific version thresholds, not proof that a package is currently available or installed.
| Evidence type | Distribution / release | Package | Channel | Version or source note | Source |
|---|---|---|---|---|---|
| upstream-release | upstream / upstream | postgresql-17 | Not a distribution channel | 17.1 | Official record |
| ecosystem-boundary | Debian:13 / 13 | postgresql-17 | unknown | 17.1-1 | Official record |
| ecosystem-boundary | Debian:12 / 12 | postgresql-15 | unknown | 15.9-0+deb12u1 | Official record |
Vendor notices and operational guidance
No connected vendor notice is available for this record.
Original sources and dates
- CVE ProgramConsulted: 2026-11-19T12:01:26.311ZArchived source JSON
Source publication: 2024-11-14T13:00:07.398Z
Source modification: 2025-11-03T21:51:39.867ZDocument fingerprint
ab7ec57807c33c8d57149498f6b5f59b9e27104b24def536185ade2cb15a8558 - Ubuntu SecurityConsulted: 2026-11-19T16:01:08.293ZArchived source JSON
Source publication: 2024-11-14T13:15:00.000Z
Source modification: 2025-08-19T22:10:46.899ZDocument fingerprint
f4b00408acf6619e716a79d94682622ebebe57f320d3d8253293bc1b9a1c9c50 - OSVConsulted: 2026-11-19T12:52:05.592ZArchived source JSON
Source publication: 2024-11-14T13:15:04.217Z
Source modification: 2026-11-02T12:00:53.333ZDocument fingerprint
bc7377159fbe1883ea8a51101a0bcce2f458a18dc726dd446fd2fa90a886a417 - OSVConsulted: 2026-11-19T12:52:08.472ZArchived source JSON
Source publication: 2024-11-14T13:15:04.217Z
Source modification: 2026-11-02T12:00:53.333ZDocument fingerprint
f99aedadc224159839f616997f8960cddd28c97207494f9c647b7c1e87e10fac - CISA KEVConsulted: 2026-11-19T17:59:58.648ZArchived source JSON
Source publication: not supplied
Source modification: 2026-11-18T19:17:41.0354ZDocument fingerprint
a35fdc67c7d9802988dcfc1d3ff1198da327948d1db122ab7692ac201055ac56 - FIRST EPSSConsulted: 2026-11-19T16:04:37.769ZArchived source JSON
Source publication: not supplied
Source modification: not suppliedDocument fingerprint
eeab810781addaf3718bffbbfbd9069ab904b94a362008ceb3a8de1b19f5ac77
Official status history
- UNKNOWN → PUBLISHED · · evidence