VDB

CVE-2024-10978

CVE-2024-10978 PUBLISHED CVSS 4.2 MEDIUM

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

Reported by postgresql · Published November 14, 2024

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.

Fixed versions

Upgrade to a fixed version or later. Language registries are listed first, then Linux distributions, then vendor products.

PackageEcosystemFixed in
postgresql15Amazon Linux15.9-1.amzn2023.0.1
postgresql15-upgrade-develAmazon Linux15.9-1.amzn2023.0.1
postgresql15-serverAmazon Linux15.9-1.amzn2023.0.1
postgresql15-staticAmazon Linux15.9-1.amzn2023.0.1
postgresql16-testAmazon Linux16.5-1.amzn2023.0.1
postgresql16-llvmjitAmazon Linux16.5-1.amzn2023.0.1
postgresql15-testAmazon Linux15.9-1.amzn2023.0.1
postgresql16-upgradeAmazon Linux16.5-1.amzn2023.0.1
postgresql-13Chainguard13.17-r0
postgresql-16Chainguard16.5-r0
postgresql16-serverAmazon Linux16.5-1.amzn2023.0.1
postgresql15-docsAmazon Linux15.9-1.amzn2023.0.1

41 more packages have a fixed version. See every fix in Lookup.

Risk scores

CVSS 3.1
4.2
CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N

Affected products

VendorProductVersions
n/aPostgreSQL17, 16, 15
n/aPostgreSQL17, 16, 15

Timeline

  • Nov 14, 2024 Coalition ESS Score (18 in total, the first dated here)
  • Nov 14, 2024 CVE Published
  • Nov 14, 2024 PoC Published (3 in total, the first dated here)
  • Nov 15, 2024 EPSS Score (30 in total, the first dated here)
  • Nov 3, 2025 CVE Updated
  • Jun 2, 2026 Security Advisory (33 in total, the first dated here)
  • Oct 23, 2026 Distribution Patch (23 in total, the first dated here)

Query this with the API

The same record, from the CLI:

vulnetix vdb vuln CVE-2024-10978
vulnetix vdb fixes CVE-2024-10978

Or with curl, using the org id and key from your account page:

curl -s -H "Authorization: ApiKey ${VULNETIX_ORG_ID}:${VULNETIX_API_KEY}" \
  "https://api.vdb.vulnetix.com/v2/vuln/CVE-2024-10978/fixes/registry"

The Community plan is free and allows 50 queries a day. Get a free API key · API quickstart

Look up in the Resolve Platform →
$ Lookup Community · 50/day Open Lookup ›