Improper Preservation of Consistency Between Independent Representations of Shared State Affecting postgresql15-contrib package, versions <0:15.9-1.amzn2023.0.1


Severity

Recommended
high

Based on Amazon Linux security rating.

Threat Intelligence

EPSS
0.04% (11th 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-8495379
  • published11 Dec 2024
  • disclosed14 Nov 2024

Introduced: 14 Nov 2024

CVE-2024-10976  (opens in a new tab)
CWE-1250  (opens in a new tab)

How to fix?

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

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.

Incomplete tracking in PostgreSQL of tables with row security allows a reused query to view or change different rows from those intended. CVE-2023-2455 and CVE-2016-2193 fixed most interaction between row security and user ID changes. They missed cases where a subquery, WITH query, security invoker view, or SQL-language function references a table with a row-level security policy. This has the same consequences as the two earlier CVEs. That is to say, it leads to potentially incorrect policies being applied in cases where role-specific policies are used and a given query is planned under one role and then executed under other roles. This scenario can happen under security definer functions or when a common user and query is planned initially and then re-used across multiple SET ROLEs. Applying an incorrect policy may permit a user to complete otherwise-forbidden reads and modifications. This affects only databases that have used CREATE POLICY to define a row security policy. An attacker must tailor an attack to a particular application's pattern of query plan reuse, user ID changes, and role-specific row security policies. Versions before PostgreSQL 17.1, 16.5, 15.9, 14.14, 13.17, and 12.21 are affected.

CVSS Scores

version 3.1