CVE-2024-0985: postgresql — Fix

Description

Late privilege drop in REFRESH MATERIALIZED VIEW CONCURRENTLY in PostgreSQL allows an object creator to execute arbitrary SQL functions as the command issuer. The command intends to run SQL functions as the owner of the materialized view, enabling safe refresh of untrusted materialized views. The victim is a superuser or member of one of the attacker's roles. The attack requires luring the victim into running REFRESH MATERIALIZED VIEW CONCURRENTLY on the attacker's materialized view. Versions before PostgreSQL 16.2, 15.6, 14.11, 13.14, and 12.18 are affected.

Is your site exposed to CVE-2024-0985?

Run a free security scan — no signup, results in seconds.

CVSS v3.1 Score

8.0

HIGH

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

Weakness Type (CWE)

CWE-271 CWE-271

Affected Products

Vendor	Product	Versions
postgresql	postgresql	12.0 — 12.18
postgresql	postgresql	13.0 — 13.14
postgresql	postgresql	14.0 — 14.11
postgresql	postgresql	15.0 — 15.6

References

Advisories & Patches

https://www.postgresql.org/support/security/CVE-2024-0985/ https://www.postgresql.org/support/security/CVE-2024-0985/

Other References

https://lists.debian.org/debian-lts-announce/2024/03/msg00017.html https://saites.dev/projects/personal/postgres-cve-2024-0985/ https://lists.debian.org/debian-lts-announce/2024/03/msg00017.html https://saites.dev/projects/personal/postgres-cve-2024-0985/ https://security.netapp.com/advisory/ntap-20241220-0005/

Frequently Asked Questions

What is CVE-2024-0985? +

Late privilege drop in REFRESH MATERIALIZED VIEW CONCURRENTLY in PostgreSQL allows an object creator to execute arbitrary SQL functions as the command issuer. The command intends to run SQL functions as the owner of the materialized view, enabling safe refresh of untrusted materialized views. The victim is a superuser or member of one of the attacker's roles. The attack requires luring the victim into running REFRESH MATERIALIZED VIEW CONCURRENTLY on the attacker's materialized view. Versions before PostgreSQL 16.2, 15.6, 14.11, 13.14, and 12.18 are affected. It has a CVSS v3.1 base score of 8.0 (HIGH).

How severe is CVE-2024-0985? +

CVE-2024-0985 has a CVSS v3.1 score of 8.0 out of 10, rated HIGH. This is a high-severity vulnerability that should be prioritized for patching.

What products are affected by CVE-2024-0985? +

CVE-2024-0985 affects products from postgresql, specifically: postgresql. Check the affected products table above for specific version ranges.

How do I check if I'm vulnerable to CVE-2024-0985? +

You can use Secably's free Website Scanner to check your website for known vulnerabilities. For infrastructure scanning, use the Port Scanner to identify exposed services that may be affected. Check the vendor advisories linked above for specific patch and version information.

Related Vulnerabilities

CVE-2026-44477 9.9

CloudNativePG is a platform designed to manage PostgreSQL databases within Kubernetes environments. Prior to 1.29.1 and 1.28.3, the CloudNativePG metrics …

CVE-2025-53819 7.9

Nix is a package manager for Linux and other Unix systems. Builds with Nix 2.30.0 on macOS were executed with …

CVE-2025-23395 7.8

Screen 5.0.0 when it runs with setuid-root privileges does not drop privileges while operating on a user supplied path. This …

CVE-2024-35179 6.8

Stalwart Mail Server is an open-source mail server. Prior to version 0.8.0, when using `RUN_AS_USER`, the specified user (and therefore, …

CVE-2024-1597 10.0

pgjdbc, the PostgreSQL JDBC Driver, allows attacker to inject SQL if using PreferQueryMode=SIMPLE. Note this is not the default. In …

CVE-2024-7348 8.8

Time-of-check Time-of-use (TOCTOU) race condition in pg_dump in PostgreSQL allows an object creator to execute arbitrary SQL functions as the …

CVE-2024-0985