{
  "schema_version": "1.4.0",
  "id": "GHSA-hg4c-rgvm-964g",
  "modified": "2024-10-21T20:20:55Z",
  "published": "2018-08-15T20:02:53Z",
  "aliases": [
    "CVE-2016-8640"
  ],
  "summary": "SQL Injection in pycsw",
  "details": "A SQL injection vulnerability in pycsw all versions before 2.0.2, 1.10.5 and 1.8.6 that leads to read and extract of any data from any table in the pycsw database that the database user has access to. Also on PostgreSQL (at least) it is possible to perform updates/inserts/deletes and database modifications to any table the database user has access to.",
  "severity": [
    {
      "type": "CVSS_V3",
      "score": "CVSS:3.0/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:N"
    },
    {
      "type": "CVSS_V4",
      "score": "CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:H/VI:H/VA:N/SC:N/SI:N/SA:N"
    }
  ],
  "affected": [
    {
      "package": {
        "ecosystem": "PyPI",
        "name": "pycsw"
      },
      "ranges": [
        {
          "type": "ECOSYSTEM",
          "events": [
            {
              "introduced": "2.0.0"
            },
            {
              "fixed": "2.0.2"
            }
          ]
        }
      ]
    },
    {
      "package": {
        "ecosystem": "PyPI",
        "name": "pycsw"
      },
      "ranges": [
        {
          "type": "ECOSYSTEM",
          "events": [
            {
              "introduced": "0"
            },
            {
              "fixed": "1.8.6"
            }
          ]
        }
      ]
    },
    {
      "package": {
        "ecosystem": "PyPI",
        "name": "pycsw"
      },
      "ranges": [
        {
          "type": "ECOSYSTEM",
          "events": [
            {
              "introduced": "1.10.0"
            },
            {
              "fixed": "1.10.5"
            }
          ]
        }
      ]
    }
  ],
  "references": [
    {
      "type": "ADVISORY",
      "url": "https://nvd.nist.gov/vuln/detail/CVE-2016-8640"
    },
    {
      "type": "WEB",
      "url": "https://github.com/geopython/pycsw/pull/474/files"
    },
    {
      "type": "WEB",
      "url": "https://github.com/geopython/pycsw/commit/522873e5ce48bb9cbd4e7e8168ca881ce709c222"
    },
    {
      "type": "WEB",
      "url": "https://github.com/geopython/pycsw/commit/69546e13527c82e4f9191769215490381ad511b2"
    },
    {
      "type": "WEB",
      "url": "https://github.com/geopython/pycsw/commit/daaf09b4b920708a415be3c7f446739661ba3753"
    },
    {
      "type": "ADVISORY",
      "url": "https://github.com/advisories/GHSA-hg4c-rgvm-964g"
    },
    {
      "type": "PACKAGE",
      "url": "https://github.com/geopython/pycsw"
    },
    {
      "type": "WEB",
      "url": "https://github.com/pypa/advisory-database/tree/main/vulns/pycsw/PYSEC-2018-98.yaml"
    },
    {
      "type": "WEB",
      "url": "https://patch-diff.githubusercontent.com/raw/geopython/pycsw/pull/474.patch"
    },
    {
      "type": "WEB",
      "url": "http://seclists.org/oss-sec/2016/q4/406"
    }
  ],
  "database_specific": {
    "cwe_ids": [
      "CWE-89"
    ],
    "severity": "CRITICAL",
    "github_reviewed": true,
    "github_reviewed_at": "2020-06-16T21:40:01Z",
    "nvd_published_at": null
  }
}