CVEMETERBack to radar
OFFICIAL RECORD · PostgreSQL

CVE-2024-10978

PUBLISHEDOfficial status check: verifiedCVSS 3.1: 4.2 · medium

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 PostgreSQL
CVSS: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 Security
CVSS: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

FieldStatusChecked at (UTC)Source
kevverified2026-11-19T17:59:58.648ZCISA KEV
cvssverified2026-11-19T12:01:26.311ZCVE Program
epssverified2026-11-19T16:04:37.769ZFIRST EPSS
patchesverified2026-11-19T16:01:08.293ZUbuntu Security
affectedverified2026-11-19T12:01:26.311ZCVE Program
lifecycleverified2026-11-19T12:01:26.311ZCVE 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&section=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 JSON
OSV · 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 JSON
OSV · 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 JSON
CVE 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 JSON

Correction 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 typeDistribution / releasePackageChannelVersion or source noteSource
upstream-releaseupstream / upstreampostgresql-17Not a distribution channel17.1Official record
ecosystem-boundaryDebian:13 / 13postgresql-17unknown17.1-1Official record
ecosystem-boundaryDebian:12 / 12postgresql-15unknown15.9-0+deb12u1Official record

Vendor notices and operational guidance

No connected vendor notice is available for this record.

Original sources and dates

Official status history