CVE-2024-10976

A flaw was found in PostgreSQL. This vulnerability allows incorrect row-level security policies to be applied via subqueries, WITH queries, security invoker views, or SQL-language functions that reference tables with row-level security policies. This issue arises when a query is planned under one role and executed under another, potentially leading to unauthorized reads or modifications of data.

Moderate impact affects Red Hat Enterprise Linux PostgreSQL deployments and other Red Hat-tracked PostgreSQL products. A query planned under one role and reused under another can apply an incorrect row-level security policy in subqueries, WITH queries, security-invoker views, or SQL-language functions, potentially allowing unauthorized reads or modifications. Exploitation requires a database using CREATE POLICY plus an application-specific combination of query-plan reuse, user-ID or role changes, and role-specific policies, consistent with Red Hat's CVSS 4.2 assessment (CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N). The current record marks Community Projects and Red Hat Enterprise Linux affects as affected; Red Hat In-Vehicle OS is also affected, but remediation is deferred, leaving the residual risk of unauthorized reads or modifications where those conditions exist. Red Hat's Moderate 4.2 assessment is lower than NIST's 5.4 because Red Hat assesses attack complexity as high rather than low.

The CVSS score(s) listed for this vulnerability do not reflect the associated product's status, and are included for informational purposes to better understand the severity of this vulnerability.

Mitigation for this issue is either not available or the currently available options don't meet the Red Hat Product Security criteria comprising ease of use and deployment, applicability to widespread installation base or stability.