JVN#19872280
Multiple vulnerabilities in PostgreSQL extension module pg_ivm

Overview

pg_ivm provided by IVM Development Group contains multiple vulnerabilities.

Products Affected

• pg_ivm versions prior to 1.5.1

Description

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.

  CVSS v3	CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:N/A:N	Base Score: 4.3
  CVSS v2	AV:N/AC:L/Au:S/C:P/I:N/A:N	Base Score: 4.0

• 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.

  CVSS v3	CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N	Base Score: 5.4
  CVSS v2	AV:N/AC:L/Au:S/C:P/I:P/A:N	Base Score: 5.5

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.