{"schemaVersion":3,"id":"CVE-2024-39887","aliases":["GHSA-2q6j-vpvr-6pvj","BIT-superset-2024-39887","PYSEC-2026-1155"],"status":"published","duplicateOf":null,"title":null,"description":"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.\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.","dates":{"published":"2024-07-16T09:20:10.688Z","modified":"2025-02-13T17:53:20.299Z","reserved":null,"kevAdded":[],"kevDue":[]},"cvss":{"headline":{"score":9.8,"severity":"critical","version":"3.1","versionLabel":"v3.1","source":"NVD","vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H","computed":false,"selection":"backend-summary"},"metrics":[{"version":"3.1","versionLabel":"v3.1","source":"CVE.org","score":4.3,"severity":"medium","vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:N/A:N","exploitability":null,"impact":null,"computed":false},{"version":"4.0","versionLabel":"v4.0","source":"OSV · Pypi","score":6.9,"severity":"medium","vector":"CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:L/VI:N/VA:N/SC:N/SI:N/SA:N","exploitability":null,"impact":null,"computed":true},{"version":"3.1","versionLabel":"v3.1","source":"OSV · Pypi","score":4.3,"severity":"medium","vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:N/A:N","exploitability":7.2,"impact":2.3,"computed":true},{"version":"3.1","versionLabel":"v3.1","source":"NVD","score":9.8,"severity":"critical","vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H","exploitability":null,"impact":null,"computed":false}]},"epss":{"probability":0.04433,"percentile":0.91274,"severity":"low","asOf":"2026-10-19T00:00:00.000Z","change":{"pp":0,"baselineDate":"2026-09-19T00:00:00.000Z","baselineScore":0.04433},"history":[{"date":"2026-09-14T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-15T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-16T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-17T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-18T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-19T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-20T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-21T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.04433,"percentile":0.91274}],"last30":[{"date":"2026-09-19T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-20T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-21T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.04433,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.04433,"percentile":0.91274}]},"kev":{"state":"not-listed","entries":[],"listedCount":0,"totalCatalogs":3,"catalogs":[{"source":"cisa","label":"CISA","listed":false,"entry":null},{"source":"enisa","label":"ENISA","listed":false,"entry":null},{"source":"circl","label":"CIRCL","listed":false,"entry":null}]},"ransomware":{"state":"none-recorded","sources":[]},"exploits":[],"exploitCount":0,"weaknesses":[{"id":"CWE-89","name":"Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')","description":"The product constructs all or part of an SQL command using externally-influenced input from an upstream component, but it does not neutralize or incorrectly neutralizes special elements that could modify the intended SQL command when it is sent to a downstream component. Without sufficient removal or quoting of SQL syntax in user-controllable inputs, the generated SQL query can cause those inputs to be interpreted as SQL instead of ordinary user data.","type":"weakness","status":"Stable","abstraction":"Base","likelihoodOfExploit":"High","url":"https://cwe.mitre.org/data/definitions/89.html"}],"affected":[{"vendor":"apache software foundation","product":"apache superset","name":"Apache Superset","label":"apache superset","ecosystem":null,"cpePart":"a","purl":null,"purlType":null,"versions":[{"text":"< 4.0.2","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 4.0.2","eol":null,"hubHref":"/vendor/apache_software_foundation/apache_superset"},{"vendor":"apache","product":"superset","name":"Superset","label":"superset","ecosystem":null,"cpePart":"a","purl":null,"purlType":null,"versions":[{"text":"< 4.0.2","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 4.0.2","eol":null,"hubHref":"/vendor/apache/superset"},{"vendor":"PyPI","product":"apache-superset","name":"apache-superset","label":"apache-superset","ecosystem":"PyPI","cpePart":null,"purl":"pkg:pypi/apache-superset","purlType":"pypi","versions":[{"text":"< 4.0.2","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 4.0.2","eol":null,"hubHref":null}],"affectedCount":3,"eol":{"hasEol":false,"count":0},"references":[{"url":"https://lists.apache.org/thread/j55vm41jg3l0x6w49zrmvbf3k0ts5fqz","label":"lists.apache.org/thread/j55vm41jg3l0x6w49zrmvbf3k0ts5fqz","hostname":"lists.apache.org","tags":["Vendor Advisory","WEB","Mailing List"]},{"url":"http://www.openwall.com/lists/oss-security/2024/07/16/5","label":"www.openwall.com/lists/oss-security/2024/07/16/5","hostname":"www.openwall.com","tags":["WEB","Mailing List","Third Party Advisory"]},{"url":"https://nvd.nist.gov/vuln/detail/CVE-2024-39887","label":"nvd.nist.gov/vuln/detail/CVE-2024-39887","hostname":"nvd.nist.gov","tags":["Advisory"]},{"url":"https://github.com/apache/superset/commit/56f0103b5771d477dd106272abbd8021c9ea7506","label":"github.com/apache/superset/commit/56f0103b5771d477dd106272abbd8021c9ea7506","hostname":"github.com","tags":["WEB"]},{"url":"https://github.com/apache/superset","label":"github.com/apache/superset","hostname":"github.com","tags":["PACKAGE"]},{"url":"https://pypi.org/project/apache-superset","label":"pypi.org/project/apache-superset","hostname":"pypi.org","tags":["PACKAGE"]},{"url":"https://github.com/advisories/GHSA-2q6j-vpvr-6pvj","label":"github.com/advisories/GHSA-2q6j-vpvr-6pvj","hostname":"github.com","tags":["Advisory"]}],"lineage":{"upstream":[],"downstream":[],"duplicates":[],"related":[]},"timeline":[{"kind":"published","date":"2024-07-16T09:20:10.688Z","label":"Published","detail":"Vulnerability first disclosed.","source":null},{"kind":"modified","date":"2025-02-13T17:53:20.299Z","label":"Last modified","detail":"Vulnerability information updated.","source":null}],"risk":{"score":70,"level":"high","profile":"Default","thresholds":{"critical":75,"high":50,"medium":25,"low":10}},"meta":{"dataAsOf":"2026-10-19T15:50:13.222Z","stale":false,"partial":false}}