{
  "document": {
    "aggregate_severity": {
      "namespace": "https://access.redhat.com/security/updates/classification/",
      "text": "Moderate"
    },
    "category": "csaf_security_advisory",
    "csaf_version": "2.0",
    "distribution": {
      "text": "Copyright \u00a9 Red Hat, Inc. All rights reserved.",
      "tlp": {
        "label": "WHITE",
        "url": "https://www.first.org/tlp/"
      }
    },
    "lang": "en",
    "notes": [
      {
        "category": "summary",
        "text": "An update for postgresql-jdbc is now available for Red Hat Enterprise Linux 9.\n\nRed Hat Product Security has rated this update as having a security impact of Moderate. A Common Vulnerability Scoring System (CVSS) base score, which gives a detailed severity rating, is available for each vulnerability from the CVE link(s) in the References section.",
        "title": "Topic"
      },
      {
        "category": "general",
        "text": "PostgreSQL is an advanced object-relational database management system. The postgresql-jdbc package includes the .jar files needed for Java programs to access a PostgreSQL database.\n\nSecurity Fix(es):\n\n* postgresql: SQL Injection in ResultSet.refreshRow() with malicious column names (CVE-2022-31197)\n\nFor more details about the security issue(s), including the impact, a CVSS score, acknowledgments, and other related information, refer to the CVE page(s) listed in the References section.",
        "title": "Details"
      },
      {
        "category": "legal_disclaimer",
        "text": "This content is licensed under the Creative Commons Attribution 4.0 International License (https://creativecommons.org/licenses/by/4.0/). If you distribute this content, or a modified version of it, you must provide attribution to Red Hat Inc. and provide a link to the original.",
        "title": "Terms of Use"
      }
    ],
    "publisher": {
      "category": "vendor",
      "contact_details": "https://access.redhat.com/security/team/contact/",
      "issuing_authority": "Red Hat Product Security is responsible for vulnerability handling across all Red Hat products and services.",
      "name": "Red Hat Product Security",
      "namespace": "https://www.redhat.com"
    },
    "references": [
      {
        "category": "self",
        "summary": "https://access.redhat.com/errata/RHSA-2023:0318",
        "url": "https://access.redhat.com/errata/RHSA-2023:0318"
      },
      {
        "category": "external",
        "summary": "https://access.redhat.com/security/updates/classification/#moderate",
        "url": "https://access.redhat.com/security/updates/classification/#moderate"
      },
      {
        "category": "external",
        "summary": "2129428",
        "url": "https://bugzilla.redhat.com/show_bug.cgi?id=2129428"
      },
      {
        "category": "self",
        "summary": "Canonical URL",
        "url": "https://security.access.redhat.com/data/csaf/v2/advisories/2023/rhsa-2023_0318.json"
      }
    ],
    "title": "Red Hat Security Advisory: postgresql-jdbc security update",
    "tracking": {
      "current_release_date": "2024-11-06T02:18:10+00:00",
      "generator": {
        "date": "2024-11-06T02:18:10+00:00",
        "engine": {
          "name": "Red Hat SDEngine",
          "version": "4.1.1"
        }
      },
      "id": "RHSA-2023:0318",
      "initial_release_date": "2023-01-23T15:27:23+00:00",
      "revision_history": [
        {
          "date": "2023-01-23T15:27:23+00:00",
          "number": "1",
          "summary": "Initial version"
        },
        {
          "date": "2023-01-23T15:27:23+00:00",
          "number": "2",
          "summary": "Last updated version"
        },
        {
          "date": "2024-11-06T02:18:10+00:00",
          "number": "3",
          "summary": "Last generated version"
        }
      ],
      "status": "final",
      "version": "3"
    }
  },
  "product_tree": {
    "branches": [
      {
        "branches": [
          {
            "branches": [
              {
                "category": "product_name",
                "name": "Red Hat Enterprise Linux AppStream (v. 9)",
                "product": {
                  "name": "Red Hat Enterprise Linux AppStream (v. 9)",
                  "product_id": "AppStream-9.1.0.Z.MAIN",
                  "product_identification_helper": {
                    "cpe": "cpe:/a:redhat:enterprise_linux:9::appstream"
                  }
                }
              }
            ],
            "category": "product_family",
            "name": "Red Hat Enterprise Linux"
          },
          {
            "branches": [
              {
                "category": "product_version",
                "name": "postgresql-jdbc-0:42.2.18-6.el9_1.src",
                "product": {
                  "name": "postgresql-jdbc-0:42.2.18-6.el9_1.src",
                  "product_id": "postgresql-jdbc-0:42.2.18-6.el9_1.src",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/redhat/postgresql-jdbc@42.2.18-6.el9_1?arch=src"
                  }
                }
              }
            ],
            "category": "architecture",
            "name": "src"
          },
          {
            "branches": [
              {
                "category": "product_version",
                "name": "postgresql-jdbc-0:42.2.18-6.el9_1.noarch",
                "product": {
                  "name": "postgresql-jdbc-0:42.2.18-6.el9_1.noarch",
                  "product_id": "postgresql-jdbc-0:42.2.18-6.el9_1.noarch",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/redhat/postgresql-jdbc@42.2.18-6.el9_1?arch=noarch"
                  }
                }
              }
            ],
            "category": "architecture",
            "name": "noarch"
          }
        ],
        "category": "vendor",
        "name": "Red Hat"
      }
    ],
    "relationships": [
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "postgresql-jdbc-0:42.2.18-6.el9_1.noarch as a component of Red Hat Enterprise Linux AppStream (v. 9)",
          "product_id": "AppStream-9.1.0.Z.MAIN:postgresql-jdbc-0:42.2.18-6.el9_1.noarch"
        },
        "product_reference": "postgresql-jdbc-0:42.2.18-6.el9_1.noarch",
        "relates_to_product_reference": "AppStream-9.1.0.Z.MAIN"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "postgresql-jdbc-0:42.2.18-6.el9_1.src as a component of Red Hat Enterprise Linux AppStream (v. 9)",
          "product_id": "AppStream-9.1.0.Z.MAIN:postgresql-jdbc-0:42.2.18-6.el9_1.src"
        },
        "product_reference": "postgresql-jdbc-0:42.2.18-6.el9_1.src",
        "relates_to_product_reference": "AppStream-9.1.0.Z.MAIN"
      }
    ]
  },
  "vulnerabilities": [
    {
      "cve": "CVE-2022-31197",
      "cwe": {
        "id": "CWE-89",
        "name": "Improper Neutralization of Special Elements used in an SQL Command (\u0027SQL Injection\u0027)"
      },
      "discovery_date": "2022-09-23T00:00:00+00:00",
      "ids": [
        {
          "system_name": "Red Hat Bugzilla ID",
          "text": "2129428"
        }
      ],
      "notes": [
        {
          "category": "description",
          "text": "A flaw was found in PostgresQL. This flaw allows an attacker to benefit from a miss escaping character and leads to a SQL injection attack due to Java.sql.ResultRow.refreshRow() implementation from PGSQL.",
          "title": "Vulnerability description"
        },
        {
          "category": "summary",
          "text": "postgresql: SQL Injection in ResultSet.refreshRow() with malicious column names",
          "title": "Vulnerability summary"
        },
        {
          "category": "other",
          "text": "User applications that do not invoke the `ResultSet.refreshRow()` method are not impacted.\nRed Hat Fuse 7 is now in Maintenance Support Phase and details about its fix should be presented soon. However, Red Hat Fuse Online (Syndesis) does will not contain the fix for this flaw.",
          "title": "Statement"
        },
        {
          "category": "general",
          "text": "The CVSS score(s) listed for this vulnerability do not reflect the associated product\u0027s status, and are included for informational purposes to better understand the severity of this vulnerability.",
          "title": "CVSS score applicability"
        }
      ],
      "product_status": {
        "fixed": [
          "AppStream-9.1.0.Z.MAIN:postgresql-jdbc-0:42.2.18-6.el9_1.noarch",
          "AppStream-9.1.0.Z.MAIN:postgresql-jdbc-0:42.2.18-6.el9_1.src"
        ]
      },
      "references": [
        {
          "category": "self",
          "summary": "Canonical URL",
          "url": "https://access.redhat.com/security/cve/CVE-2022-31197"
        },
        {
          "category": "external",
          "summary": "RHBZ#2129428",
          "url": "https://bugzilla.redhat.com/show_bug.cgi?id=2129428"
        },
        {
          "category": "external",
          "summary": "https://www.cve.org/CVERecord?id=CVE-2022-31197",
          "url": "https://www.cve.org/CVERecord?id=CVE-2022-31197"
        },
        {
          "category": "external",
          "summary": "https://nvd.nist.gov/vuln/detail/CVE-2022-31197",
          "url": "https://nvd.nist.gov/vuln/detail/CVE-2022-31197"
        },
        {
          "category": "external",
          "summary": "https://github.com/pgjdbc/pgjdbc/security/advisories/GHSA-r38f-c4h4-hqq2",
          "url": "https://github.com/pgjdbc/pgjdbc/security/advisories/GHSA-r38f-c4h4-hqq2"
        }
      ],
      "release_date": "2022-08-03T00:00:00+00:00",
      "remediations": [
        {
          "category": "vendor_fix",
          "date": "2023-01-23T15:27:23+00:00",
          "details": "For details on how to apply this update, which includes the changes described in this advisory, refer to:\n\nhttps://access.redhat.com/articles/11258\n\nIf the postgresql service is running, it will be automatically restarted after installing this update.",
          "product_ids": [
            "AppStream-9.1.0.Z.MAIN:postgresql-jdbc-0:42.2.18-6.el9_1.noarch",
            "AppStream-9.1.0.Z.MAIN:postgresql-jdbc-0:42.2.18-6.el9_1.src"
          ],
          "restart_required": {
            "category": "none"
          },
          "url": "https://access.redhat.com/errata/RHSA-2023:0318"
        }
      ],
      "scores": [
        {
          "cvss_v3": {
            "attackComplexity": "LOW",
            "attackVector": "NETWORK",
            "availabilityImpact": "HIGH",
            "baseScore": 8.0,
            "baseSeverity": "HIGH",
            "confidentialityImpact": "HIGH",
            "integrityImpact": "HIGH",
            "privilegesRequired": "LOW",
            "scope": "UNCHANGED",
            "userInteraction": "REQUIRED",
            "vectorString": "CVSS:3.1/AV:N/AC:L/PR:L/UI:R/S:U/C:H/I:H/A:H",
            "version": "3.1"
          },
          "products": [
            "AppStream-9.1.0.Z.MAIN:postgresql-jdbc-0:42.2.18-6.el9_1.noarch",
            "AppStream-9.1.0.Z.MAIN:postgresql-jdbc-0:42.2.18-6.el9_1.src"
          ]
        }
      ],
      "threats": [
        {
          "category": "impact",
          "details": "Moderate"
        }
      ],
      "title": "postgresql: SQL Injection in ResultSet.refreshRow() with malicious column names"
    }
  ]
}