{"id":"CVE-2024-39887","aliases":["GHSA-2q6j-vpvr-6pvj","BIT-superset-2024-39887","PYSEC-2026-1155"],"title":"Apache Superset vulnerable to improper SQL authorization","summary":"Apache Superset vulnerable to improper SQL authorization","severity":"medium","cvss":4.3,"cvssVector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:N/A:N","vendor":"apache-superset","product":"apache-superset","ecosystem":"pip","affected":["apache-superset < 4.0.2"],"patched":["apache-superset 4.0.2"],"published":"2024-07-16","updated":"2026-07-07","source":"OSV","sourceUrl":"https://osv.dev/vulnerability/GHSA-2q6j-vpvr-6pvj","references":[{"url":"https://nvd.nist.gov/vuln/detail/CVE-2024-39887"},{"url":"https://github.com/apache/superset/commit/56f0103b5771d477dd106272abbd8021c9ea7506"},{"url":"https://github.com/apache/superset"},{"url":"https://lists.apache.org/thread/j55vm41jg3l0x6w49zrmvbf3k0ts5fqz"},{"url":"http://www.openwall.com/lists/oss-security/2024/07/16/5"}],"tags":["osv","pip","exploit-available"],"epss":0.04433,"epssPercentile":0.90952,"ingestedAt":"2026-07-08T18:25:44.597Z","exploits":{"nuclei":["CVE-2024-39887"],"checkedAt":"2026-09-24T07:52:51.596Z"},"exploitAvailable":true,"slug":"CVE-2024-39887","body":"## Overview\n\nAn 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.\n\nThis issue affects Apache Superset: before 4.0.2.\n\nUsers are recommended to upgrade to version 4.0.2, which fixes the issue.\n\n## Affected packages\n\n- `apache-superset < 4.0.2`\n\n## Remediation\n\nUpgrade to a patched release:\n\n- `apache-superset 4.0.2`","depth":"twilight","depthScore":37,"depthScoreParts":{"impact":23.7,"likelihood":0.9,"exploitation":12,"ransomware":0},"changes":[{"seq":4726,"id":"CVE-2024-39887","ts":1788887202537,"field":"exploit_available","old":"false","new":"true"},{"seq":3609,"id":"CVE-2024-39887","ts":1788886318663,"field":"exploit_available","old":"true","new":"false"},{"seq":2463,"id":"CVE-2024-39887","ts":1788882987262,"field":"exploit_available","old":"false","new":"true"},{"seq":1492,"id":"CVE-2024-39887","ts":1788882400737,"field":"exploit_available","old":"true","new":"false"},{"seq":606,"id":"CVE-2024-39887","ts":1788881837215,"field":"exploit_available","old":"false","new":"true"}]}