GHSA-2gwj-7jmv-h26r
CRITICAL
SQL Injection in Django
Published April 13, 2022Updated February 21, 2025Source: osv
Details
An issue was discovered in Django 2.2 before 2.2.28, 3.2 before 3.2.13, and 4.0 before 4.0.4. `QuerySet.annotate()`, `aggregate()`, and `extra()` methods are subject to SQL injection in column aliases via a crafted dictionary (with dictionary expansion) as the passed `**kwargs`.
Remediation
Upgrade to the fixed version using your package manager.
pip
Update django to 3.2.13 or laterpip install "django>=3.2.13"
pip
Update django to 4.0.4 or laterpip install "django>=4.0.4"
pip
Update django to 2.2.28 or laterpip install "django>=2.2.28"
After upgrading, run your dependency scanner again to confirm the vulnerability is resolved.
Affected Packages (3)
Vulnerability Classification
Common Weakness Enumeration (CWE) identifiers for this vulnerability type.
- CWE-89SQL InjectionMITRE
CVSS Score Breakdown
What the CVSS (Common Vulnerability Scoring System) 3.1 score means for each attack dimension.
Attack Vector
Network
Attack Complexity
Low
Privileges Required
None
User Interaction
None
Scope
Unchanged
Confidentiality
High
Integrity
High
Availability
High
CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H
References
- https://nvd.nist.gov/vuln/detail/CVE-2022-28346ADVISORY
- https://github.com/django/django/commit/2044dac5c6968441be6f534c4139bcf48c5c7e48WEB
- https://github.com/django/django/commit/2c09e68ec911919360d5f8502cefc312f9e03c5dWEB
- https://github.com/django/django/commit/800828887a0509ad1162d6d407e94d8de7eafc60WEB
- https://github.com/django/django/commit/93cae5cb2f9a4ef1514cf1a41f714fef08005200WEB
- https://docs.djangoproject.com/en/4.0/releases/securityWEB
- https://github.com/advisories/GHSA-2gwj-7jmv-h26rADVISORY
- https://github.com/django/djangoPACKAGE
- https://github.com/pypa/advisory-database/tree/main/vulns/django/PYSEC-2022-190.yamlWEB
- https://groups.google.com/forum/#!forum/django-announceWEB
- https://lists.debian.org/debian-lts-announce/2022/04/msg00013.htmlWEB
- https://lists.fedoraproject.org/archives/list/package-announce@lists.fedoraproject.org/message/HWY6DQWRVBALV73BPUVBXC3QIYUM24IKWEB
- https://lists.fedoraproject.org/archives/list/package-announce@lists.fedoraproject.org/message/LTZVAKU5ALQWOKFTPISE257VCVIYGFQIWEB
- https://security.netapp.com/advisory/ntap-20220609-0002WEB
- https://www.debian.org/security/2022/dsa-5254WEB
- https://www.djangoproject.com/weblog/2022/apr/11/security-releasesWEB
- http://www.openwall.com/lists/oss-security/2022/04/11/1WEB
Risk Assessment
CVSS Score
3.1
Exploitation is difficult or impact is minor. Address in your next planned update.
EPSS Score (30-day exploit probability)
1.97%
Higher than 83% of vulnerabilities
Also Known As
Check if you're affected
Scan your dependencies to see if this vulnerability affects your projects.
Scan Your Dependencies