CVE-2024-39887: Apache Superset: Improper SQL authorisation, parse not checking for specific engine functions
First published: Tue Jul 16 2024(Updated: )
An SQL Injection vulnerability in Apache Superset exists due to improper neutralization of special elements used in SQL commands. Specifically, certain engine-specific functions are not checked, which allows attackers to bypass Apache Superset's SQL authorization. To mitigate this, a new configuration key named DISALLOWED_SQL_FUNCTIONS has been introduced. This key disallows the use of the following PostgreSQL functions: version, query_to_xml, inet_server_addr, and inet_client_addr. Additional functions can be added to this list for increased protection. This issue affects Apache Superset: before 4.0.2. Users are recommended to upgrade to version 4.0.2, which fixes the issue.
Credit: security@apache.org security@apache.org
| Affected Software | Affected Version | How to fix |
|---|---|---|
| pip/apache-superset | <4.0.2 | 4.0.2 |
| Apache Superset | <4.0.2 |
Never miss a vulnerability like this again
Sign up to SecAlerts for real-time vulnerability data matched to your software, aggregated from hundreds of sources.
Reference Links
- https://lists.apache.org/thread/j55vm41jg3l0x6w49zrmvbf3k0ts5fqz
- http://www.openwall.com/lists/oss-security/2024/07/16/5
- https://nvd.nist.gov/vuln/detail/CVE-2024-39887
- https://github.com/apache/superset/commit/56f0103b5771d477dd106272abbd8021c9ea7506
- https://github.com/advisories/GHSA-2q6j-vpvr-6pvj (Advisory)
Frequently Asked Questions
What is the severity of CVE-2024-39887?
CVE-2024-39887 has been classified with a high severity rating due to its potential for SQL Injection attacks.
How do I fix CVE-2024-39887?
To mitigate CVE-2024-39887, upgrade to Apache Superset version 4.0.2 or later.
What systems are affected by CVE-2024-39887?
CVE-2024-39887 affects Apache Superset versions before 4.0.2.
How does CVE-2024-39887 impact security?
CVE-2024-39887 allows attackers to bypass SQL authorization, potentially compromising sensitive data.
What type of vulnerability is CVE-2024-39887?
CVE-2024-39887 is an SQL Injection vulnerability resulting from improper neutralization in Apache Superset.
- agent/weakness
- agent/title
- agent/type
- agent/first-publish-date
- collector/oss-sec
- source/oss-sec
- alias/CVE-2024-39887
- agent/references
- agent/description
- collector/nvd-cve
- source/NVD
- agent/author
- collector/mitre-cve
- source/MITRE
- collector/github-advisory-latest
- source/GitHub
- alias/GHSA-2q6j-vpvr-6pvj
- agent/software-canonical-lookup
- collector/github-advisory
- agent/trending
- agent/source
- agent/last-modified-date
- agent/severity
- agent/softwarecombine
- agent/tags
- collector/nvd-api
- agent/event
- package-manager/pip
- vendor/apache
- canonical/apache superset