Security advisory

{
  "id": "ccbd0750891f1fecedb7ed79f34cb390ce818b4c84c797b1af36ee0d33332a53",
  "url": "https://osv.dev/vulnerability/CVE-2023-22847",
  "method": "structured",
  "payload": {
    "kind": "advisory",
    "title": "CVE-2023-22847",
    "summary": "Information disclosure vulnerability exists in pg_ivm versions prior to 1.5.1. 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. As a result, information in tables protected by Row-Level Security may be retrieved by a user who is not authorized to access it.",
    "evidence": "osv:CVE-2023-22847",
    "products": [],
    "severity": "medium",
    "structured": {
      "id": "CVE-2023-22847",
      "aliases": [
        "CVE-2023-22847"
      ],
      "metrics": [
        {
          "type": "CVSS_V3",
          "score": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:N/A:N"
        }
      ],
      "affected": [
        {
          "ranges": [
            {
              "repo": "https://github.com/sraoss/pg_ivm",
              "type": "GIT",
              "events": [
                {
                  "introduced": "0"
                },
                {
                  "fixed": "a81c657223261ecb565036020eeb8ffacfe938ea"
                }
              ],
              "database_specific": {
                "extracted_events": [
                  {
                    "range": [
                      {
                        "introduced": "0"
                      },
                      {
                        "fixed": "1.5.1"
                      }
                    ],
                    "source": "AFFECTED_FIELD",
                    "strategy": "VersionTextExtraction"
                  },
                  {
                    "range": [
                      {
                        "fixed": "a81c657223261ecb565036020eeb8ffacfe938ea"
                      }
                    ],
                    "source": "REFERENCES_TAG",
                    "original_tag": "v1.5.1"
                  },
                  {
                    "cpe": "cpe:2.3:a:sraoss:pg_ivm:*:*:*:*:*:postgresql:*:*",
                    "range": [
                      {
                        "introduced": "0"
                      },
                      {
                        "fixed": "1.5.1"
                      }
                    ],
                    "source": "CPE_RANGE"
                  }
                ]
              }
            }
          ],
          "versions": [
            "v1.5",
            "v1.4.1",
            "v1.4",
            "v1.3",
            "1.3",
            "v1.2",
            "v1.1",
            "v1.0",
            "v1.0-alpha"
          ],
          "database_specific": {
            "source": "https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2023-22847.json"
          }
        }
      ],
      "modified": "2026-10-28T02:30:33.580859720Z",
      "provider": "osv",
      "references": [
        "https://github.com/sraoss/pg_ivm/releases/tag/v1.5.1",
        "https://jvn.jp/en/jp/JVN19872280/",
        "https://github.com/CVEProject/cvelistV5/tree/main/cves/2023/22xxx/CVE-2023-22847.json",
        "https://nvd.nist.gov/vuln/detail/CVE-2023-22847",
        "https://github.com/sraoss/pg_ivm"
      ],
      "provider_metadata": {
        "cna_assigner": "jpcert",
        "osv_generated_from": "https://github.com/CVEProject/cvelistV5/tree/main/cves/2023/22xxx/CVE-2023-22847.json"
      }
    },
    "related_cves": [
      {
        "value": "CVE-2023-22847",
        "evidence": "/id"
      }
    ],
    "security_relevant": true,
    "severity_evidence": "/severity/0/score"
  },
  "source_id": "core-osv",
  "document_id": 500390,
  "published_at": "2023-03-07T00:00:00+00:00"
}