#VU24846 SQL injection in Django - CVE-2020-7471

Description

The vulnerability allows a remote attacker to execute arbitrary SQL queries in database.

The vulnerability exists due to insufficient sanitization of user-supplied data 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 in Django 1.11 before 1.11.28, 2.2 before 2.2.10, and 3.0 before 3.0.3. A remote attacker can send a specially crafted request to the affected application and execute arbitrary SQL commands within the application database.

Successful exploitation of this vulnerability may allow a remote attacker to read, delete, modify data in database and gain complete control over the affected application.

Remediation

External links

• https://docs.djangoproject.com/en/3.0/releases/security/
• https://groups.google.com/forum/#!topic/django-announce/X45S86X5bZI
• https://www.djangoproject.com/weblog/2020/feb/03/security-releases/
• https://www.openwall.com/lists/oss-security/2020/02/03/1