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.
Vendor Status
Vendor | Link |
IVM Development Group | sraoss/pg_ivm: IVM (Incremental View Maintenance) implementation as a PostgreSQL extension |
pg_ivm 1.5.1 (2023-03-02) |
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 |