{"schemaVersion":3,"id":"CVE-2023-49736","aliases":["GHSA-jfxj-xf67-x723","BIT-superset-2023-49736","PYSEC-2026-1184"],"status":"published","duplicateOf":null,"title":null,"description":"A where_in JINJA macro allows users to specify a quote, which combined with a carefully crafted statement would allow for SQL injection in Apache Superset.This issue affects Apache Superset: before 2.1.2, from 3.0.0 before 3.0.2.\n\nUsers are recommended to upgrade to version 3.0.2, which fixes the issue.","dates":{"published":"2023-12-19T09:33:10.415Z","modified":"2025-02-13T17:18:54.638Z","reserved":null,"kevAdded":[],"kevDue":[]},"cvss":{"headline":{"score":8.8,"severity":"high","version":"3.1","versionLabel":"v3.1","source":"NVD","vector":"CVSS:3.1/AV:N/AC:L/PR:L/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":6.5,"severity":"medium","vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:H/A:N","exploitability":null,"impact":null,"computed":false},{"version":"3.1","versionLabel":"v3.1","source":"OSV · Pypi","score":6.5,"severity":"medium","vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:H/A:N","exploitability":7.2,"impact":6,"computed":true},{"version":"3.1","versionLabel":"v3.1","source":"NVD","score":8.8,"severity":"high","vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H","exploitability":null,"impact":null,"computed":false}]},"epss":{"probability":0.01188,"percentile":0.67437,"severity":"low","asOf":"2026-10-19T00:00:00.000Z","change":{"pp":0,"baselineDate":"2026-09-19T00:00:00.000Z","baselineScore":0.01188},"history":[{"date":"2026-09-14T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-15T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-16T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-17T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-18T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-19T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-20T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-21T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.01188,"percentile":0.67437}],"last30":[{"date":"2026-09-19T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-20T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-21T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.01188,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.01188,"percentile":0.67437}]},"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":"< 2.1.2","noFixRecorded":false,"fixedIn":null},{"text":"≥ 3.0.0, < 3.0.2","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 2.1.2 | ≥ 3.0.0, < 3.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":"< 2.1.2","noFixRecorded":false,"fixedIn":null},{"text":"≥ 3.0.0, < 3.0.2","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 2.1.2 | ≥ 3.0.0, < 3.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":"< 2.1.3","noFixRecorded":false,"fixedIn":null},{"text":"≥ 3.0.0, < 3.0.2","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 2.1.3 | ≥ 3.0.0, < 3.0.2","eol":null,"hubHref":null}],"affectedCount":3,"eol":{"hasEol":false,"count":0},"references":[{"url":"https://lists.apache.org/thread/1kf481bgs3451qcz6hfhobs7xvhp8n1p","label":"lists.apache.org/thread/1kf481bgs3451qcz6hfhobs7xvhp8n1p","hostname":"lists.apache.org","tags":["Vendor Advisory","WEB","Mailing List"]},{"url":"http://www.openwall.com/lists/oss-security/2023/12/19/2","label":"www.openwall.com/lists/oss-security/2023/12/19/2","hostname":"www.openwall.com","tags":["WEB","Mailing List","Third Party Advisory"]},{"url":"https://nvd.nist.gov/vuln/detail/CVE-2023-49736","label":"nvd.nist.gov/vuln/detail/CVE-2023-49736","hostname":"nvd.nist.gov","tags":["Advisory"]},{"url":"https://github.com/apache/superset/pull/25779","label":"github.com/apache/superset/pull/25779","hostname":"github.com","tags":["WEB"]},{"url":"https://github.com/apache/superset/commit/1d403dab9822a8cee6108669c53e53fad881c751","label":"github.com/apache/superset/commit/1d403dab9822a8cee6108669c53e53fad881c751","hostname":"github.com","tags":["WEB"]},{"url":"https://github.com/apache/superset/commit/34101594e284ab3acce692f41aff7759ccb4bf1d","label":"github.com/apache/superset/commit/34101594e284ab3acce692f41aff7759ccb4bf1d","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-jfxj-xf67-x723","label":"github.com/advisories/GHSA-jfxj-xf67-x723","hostname":"github.com","tags":["Advisory"]}],"lineage":{"upstream":[],"downstream":[],"duplicates":[],"related":[]},"timeline":[{"kind":"published","date":"2023-12-19T09:33:10.415Z","label":"Published","detail":"Vulnerability first disclosed.","source":null},{"kind":"modified","date":"2025-02-13T17:18:54.638Z","label":"Last modified","detail":"Vulnerability information updated.","source":null}],"risk":{"score":35,"level":"medium","profile":"Default","thresholds":{"critical":75,"high":50,"medium":25,"low":10}},"meta":{"dataAsOf":"2026-10-20T01:35:57.129Z","stale":false,"partial":false}}