Privilege Dropping / Lowering Errors Affecting postgresql15-contrib package, versions <0:15.6-1.amzn2023.0.1


Severity

Recommended
0.0
high
0
10

Based on Amazon Linux security rating.

Threat Intelligence

EPSS
0.06% (28th percentile)

Do your applications use this vulnerable package?

In a few clicks we can analyze your entire application and see what components are vulnerable in your application, and suggest you quick fixes.

Test your applications
  • Snyk IDSNYK-AMZN2023-POSTGRESQL15CONTRIB-6393656
  • published6 Mar 2024
  • disclosed8 Feb 2024

Introduced: 8 Feb 2024

CVE-2024-0985  (opens in a new tab)
CWE-271  (opens in a new tab)

How to fix?

Upgrade Amazon-Linux:2023 postgresql15-contrib to version 0:15.6-1.amzn2023.0.1 or higher.
This issue was patched in ALAS2023-2024-547.

NVD Description

Note: Versions mentioned in the description apply only to the upstream postgresql15-contrib package and not the postgresql15-contrib package as distributed by Amazon-Linux. See How to fix? for Amazon-Linux:2023 relevant fixed versions and status.

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.

CVSS Scores

version 3.1