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

Multiple vulnerabilities in PostgreSQL extension module pg_ivm


pg_ivm provided by IVM Development Group contains multiple vulnerabilities.

Products Affected

  • pg_ivm versions prior to 1.5.1


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


  • 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


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.


JPCERT/CC Addendum

Vulnerability Analysis by JPCERT/CC


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 Reports
CERT Advisory
CPNI Advisory
CVE CVE-2023-22847
JVN iPedia JVNDB-2023-000023