JVN#19872280: Multiple vulnerabilities in PostgreSQL extension module pg_ivm

pg_ivm provided by IVM Development Group is a PostgreSQL extension module that provides incremental view maintenance functionality of materialized views. pg_ivm contains multiple vulnerabilities listed below.

Exposure of sensitive information to an unauthorized actor (CWE-200) - CVE-2023-22847
An Incrementally Maintainable Materialized View (IMMV) created by pg_ivm may reflect rows with Row-Level Security that the owner of the IMMV should not have access to.

Uncontrolled search path element (CWE-427) - CVE-2023-23554
When refreshing an IMMV, pg_ivm executes functions without specifying schema names. Under certain conditions, pg_ivm may be tricked to execute unexpected functions from other schemas with the IMMV owner’s privilege.

Impact

• Information in tables protected by Row-Level Security may be retrieved by a user who is not authorized to access it - CVE-2023-22847
• An unexpected function provided by an attacker may be executed with the privilege of the materialized view owner - CVE-2023-23554

Solution

Update the Software
Update to the latest version according to the information provided by the developer.
The developer has released pg_ivm 1.5.1 that addresses the vulnerabilities.

Products Affected

• pg_ivm versions prior to 1.5.1