CVE-2020-7471

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.

CVSS v3.0 9.8 CRITICAL
CVSS v2.0 7.5 HIGH

9.8^/10

CVSS v3.0 : CRITICAL

V3 Legend

Vector :

Exploitability : 3.9 / Impact : 5.9

Attack Vector NETWORK

Attack Complexity LOW

Privileges Required NONE

User Interaction NONE

Confidentiality Impact HIGH

Integrity Impact HIGH

Availability Impact HIGH

Scope UNCHANGED

7.5^/10

CVSS v2.0 : HIGH

V2 Legend

Vector : AV:N/AC:L/Au:N/C:P/I:P/A:P

Exploitability : 10.0 / Impact : 6.4

Access Vector NETWORK

Access Complexity LOW

Authentication NONE

Confidentiality Impact PARTIAL

Integrity Impact PARTIAL

Availability Impact PARTIAL

References

Link	Resource
https://www.openwall.com/lists/oss-security/2020/02/03/1	Mailing List Third Party Advisory
https://docs.djangoproject.com/en/3.0/releases/security/	Vendor Advisory
https://groups.google.com/forum/#!topic/django-announce/X45S86X5bZI	Mailing List Third Party Advisory
https://www.djangoproject.com/weblog/2020/feb/03/security-releases/	Vendor Advisory
http://www.openwall.com/lists/oss-security/2020/02/03/1	Mailing List Third Party Advisory
https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136	Patch Third Party Advisory
https://usn.ubuntu.com/4264-1/
https://seclists.org/bugtraq/2020/Feb/30
https://www.debian.org/security/2020/dsa-4629
https://security.netapp.com/advisory/ntap-20200221-0006/
https://security.gentoo.org/glsa/202004-17
https://lists.fedoraproject.org/archives/list/package-announce@lists.fedoraproject.org/message/4A2AP4T7RKPBCLTI2NNQG3T6MINDUUMZ/

Configurations

Configuration 1 (hide)

OR	cpe:2.3:a:djangoproject:django::::::::
	cpe:2.3:a:djangoproject:django::::::::
	cpe:2.3:a:djangoproject:django::::::::

Information

Published : 2020-02-03 04:15

Updated : 2020-06-18 20:15

NVD link : CVE-2020-7471

Mitre link : CVE-2020-7471

JSON object : View

CWE

CWE-89

Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')

Products Affected

djangoproject

django

{"cve": {"data_type": "CVE", "references": {"reference_data": [{"url": "https://www.openwall.com/lists/oss-security/2020/02/03/1", "name": "https://www.openwall.com/lists/oss-security/2020/02/03/1", "tags": ["Mailing List", "Third Party Advisory"], "refsource": "CONFIRM"}, {"url": "https://docs.djangoproject.com/en/3.0/releases/security/", "name": "https://docs.djangoproject.com/en/3.0/releases/security/", "tags": ["Vendor Advisory"], "refsource": "CONFIRM"}, {"url": "https://groups.google.com/forum/#!topic/django-announce/X45S86X5bZI", "name": "https://groups.google.com/forum/#!topic/django-announce/X45S86X5bZI", "tags": ["Mailing List", "Third Party Advisory"], "refsource": "CONFIRM"}, {"url": "https://www.djangoproject.com/weblog/2020/feb/03/security-releases/", "name": "https://www.djangoproject.com/weblog/2020/feb/03/security-releases/", "tags": ["Vendor Advisory"], "refsource": "CONFIRM"}, {"url": "http://www.openwall.com/lists/oss-security/2020/02/03/1", "name": "[oss-security] 20200203 Django 3.0.3, 2.2.10 and 1.11.28: CVE-2020-7471: Potential SQL injection via ``StringAgg(delimiter)``", "tags": ["Mailing List", "Third Party Advisory"], "refsource": "MLIST"}, {"url": "https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136", "name": "https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136", "tags": ["Patch", "Third Party Advisory"], "refsource": "CONFIRM"}, {"url": "https://usn.ubuntu.com/4264-1/", "name": "USN-4264-1", "tags": [], "refsource": "UBUNTU"}, {"url": "https://seclists.org/bugtraq/2020/Feb/30", "name": "20200219 [SECURITY] [DSA 4629-1] python-django security update", "tags": [], "refsource": "BUGTRAQ"}, {"url": "https://www.debian.org/security/2020/dsa-4629", "name": "DSA-4629", "tags": [], "refsource": "DEBIAN"}, {"url": "https://security.netapp.com/advisory/ntap-20200221-0006/", "name": "https://security.netapp.com/advisory/ntap-20200221-0006/", "tags": [], "refsource": "CONFIRM"}, {"url": "https://security.gentoo.org/glsa/202004-17", "name": "GLSA-202004-17", "tags": [], "refsource": "GENTOO"}, {"url": "https://lists.fedoraproject.org/archives/list/package-announce@lists.fedoraproject.org/message/4A2AP4T7RKPBCLTI2NNQG3T6MINDUUMZ/", "name": "FEDORA-2020-c2639662af", "tags": [], "refsource": "FEDORA"}]}, "data_format": "MITRE", "description": {"description_data": [{"lang": "en", "value": "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."}]}, "problemtype": {"problemtype_data": [{"description": [{"lang": "en", "value": "CWE-89"}]}]}, "data_version": "4.0", "CVE_data_meta": {"ID": "CVE-2020-7471", "ASSIGNER": "cve@mitre.org"}}, "impact": {"baseMetricV2": {"cvssV2": {"version": "2.0", "baseScore": 7.5, "accessVector": "NETWORK", "vectorString": "AV:N/AC:L/Au:N/C:P/I:P/A:P", "authentication": "NONE", "integrityImpact": "PARTIAL", "accessComplexity": "LOW", "availabilityImpact": "PARTIAL", "confidentialityImpact": "PARTIAL"}, "severity": "HIGH", "acInsufInfo": false, "impactScore": 6.4, "obtainAllPrivilege": false, "exploitabilityScore": 10.0, "obtainUserPrivilege": false, "obtainOtherPrivilege": false, "userInteractionRequired": false}, "baseMetricV3": {"cvssV3": {"scope": "UNCHANGED", "version": "3.1", "baseScore": 9.8, "attackVector": "NETWORK", "baseSeverity": "CRITICAL", "vectorString": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H", "integrityImpact": "HIGH", "userInteraction": "NONE", "attackComplexity": "LOW", "availabilityImpact": "HIGH", "privilegesRequired": "NONE", "confidentialityImpact": "HIGH"}, "impactScore": 5.9, "exploitabilityScore": 3.9}}, "publishedDate": "2020-02-03T12:15Z", "configurations": {"nodes": [{"children": [], "operator": "OR", "cpe_match": [{"cpe23Uri": "cpe:2.3:a:djangoproject:django:*:*:*:*:*:*:*:*", "cpe_name": [], "vulnerable": true, "versionEndExcluding": "1.11.28", "versionStartIncluding": "1.11"}, {"cpe23Uri": "cpe:2.3:a:djangoproject:django:*:*:*:*:*:*:*:*", "cpe_name": [], "vulnerable": true, "versionEndExcluding": "2.2.10", "versionStartIncluding": "2.2"}, {"cpe23Uri": "cpe:2.3:a:djangoproject:django:*:*:*:*:*:*:*:*", "cpe_name": [], "vulnerable": true, "versionEndExcluding": "3.0.3", "versionStartIncluding": "3.0"}]}], "CVE_data_version": "4.0"}, "lastModifiedDate": "2020-06-19T03:15Z"}

9.8 /10