{
"id": "GHSA-hmr4-m2h5-33qx",
"aliases": [
"CVE-2020-7471"
],
"details": "Django 1.11 before 1.11.28, 2.2 before 2.2.10, and 3.0 before 3.0.3 allows SQL Injection if untrusted data is used as a StringAgg delimiter (e.g., in Django applications that offer downloads of data as a series of rows with a user-specified column delimiter). By passing a suitably crafted delimiter to a contrib.postgres.aggregates.StringAgg instance, it was possible to break escaping and inject malicious SQL.",
"summary": "SQL injection in Django",
"affected": [
{
"ranges": [
{
"type": "ECOSYSTEM",
"events": [
{
"introduced": "0"
},
{
"fixed": "1.11.28"
}
]
}
],
"package": {
"name": "Django",
"ecosystem": "PyPI"
}
},
{
"ranges": [
{
"type": "ECOSYSTEM",
"events": [
{
"introduced": "2.0"
},
{
"fixed": "2.2.10"
}
]
}
],
"package": {
"name": "Django",
"ecosystem": "PyPI"
}
},
{
"ranges": [
{
"type": "ECOSYSTEM",
"events": [
{
"introduced": "3.0"
},
{
"fixed": "3.0.3"
}
]
}
],
"package": {
"name": "Django",
"ecosystem": "PyPI"
}
}
],
"modified": "2024-09-20T15:03:11Z",
"severity": [
{
"type": "CVSS_V3",
"score": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H"
},
{
"type": "CVSS_V4",
"score": "CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:H/VI:H/VA:H/SC:N/SI:N/SA:N"
}
],
"published": "2020-02-11T21:03:20Z",
"references": [
{
"url": "https://nvd.nist.gov/vuln/detail/CVE-2020-7471",
"type": "ADVISORY"
},
{
"url": "https://github.com/django/django/commit/001b0634cd309e372edb6d7d95d083d02b8e37bd",
"type": "WEB"
},
{
"url": "https://github.com/django/django/commit/505826b469b16ab36693360da9e11fd13213421b",
"type": "WEB"
},
{
"url": "https://github.com/django/django/commit/c67a368c16e4680b324b4f385398d638db4d8147",
"type": "WEB"
},
{
"url": "https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136",
"type": "WEB"
},
{
"url": "https://www.openwall.com/lists/oss-security/2020/02/03/1",
"type": "WEB"
},
{
"url": "https://www.djangoproject.com/weblog/2020/feb/03/security-releases",
"type": "WEB"
},
{
"url": "https://www.debian.org/security/2020/dsa-4629",
"type": "WEB"
},
{
"url": "https://usn.ubuntu.com/4264-1",
"type": "WEB"
},
{
"url": "https://security.netapp.com/advisory/ntap-20200221-0006",
"type": "WEB"
},
{
"url": "https://security.gentoo.org/glsa/202004-17",
"type": "WEB"
},
{
"url": "https://seclists.org/bugtraq/2020/Feb/30",
"type": "WEB"
},
{
"url": "https://lists.fedoraproject.org/archives/list/[email protected] /message/4A2AP4T7RKPBCLTI2NNQG3T6MINDUUMZ",
"type": "WEB"
},
{
"url": "https://groups.google.com/forum/#!topic/django-announce/X45S86X5bZI",
"type": "WEB"
},
{
"url": "https://github.com/pypa/advisory-database/tree/main/vulns/django/PYSEC-2020-35.yaml",
"type": "WEB"
},
{
"url": "https://github.com/django/django",
"type": "PACKAGE"
},
{
"url": "https://github.com/advisories/GHSA-hmr4-m2h5-33qx",
"type": "ADVISORY"
},
{
"url": "https://docs.djangoproject.com/en/3.0/releases/security",
"type": "WEB"
},
{
"url": "http://www.openwall.com/lists/oss-security/2020/02/03/1",
"type": "WEB"
}
],
"schema_version": "1.4.0",
"database_specific": {
"cwe_ids": [
"CWE-89"
],
"severity": "CRITICAL",
"github_reviewed": true,
"nvd_published_at": null,
"github_reviewed_at": "2020-02-05T15:07:21Z"
}
}