Published:2023/03/06  Last Updated:2023/03/06

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.

References

JPCERT/CC Addendum

Vulnerability Analysis by JPCERT/CC

Credit

IVM Development Group reported these vulnerabilities to IPA to notify users of its solution through JVN. JPCERT/CC and IVM Development Group coordinated under the Information Security Early Warning Partnership.

Other Information

JPCERT Alert
JPCERT Reports
CERT Advisory
CPNI Advisory
TRnotes
CVE CVE-2023-22847
CVE-2023-23554
JVN iPedia JVNDB-2023-000023