# CVE-2024-39887: Apache Superset: Improper SQL authorisation, parse not checking for specific engine functions

- Exploited (CISA KEV): no
- Published: 2024-07-16
- CVSS: 4.3 MEDIUM (v3.1)
- EPSS: 4.4% (91th percentile)
- CWE: CWE-89

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.

## Edge WAF coverage (claimed by vendors, not measured)

| Vendor | Status | First rule | Days after publication |
|---|---|---|---|
| Cloudflare | Before feed history | — | — |
| AWS | No public claim | — | — |
| Microsoft Azure | No public claim | — | — |
| Google Cloud | No public claim | — | — |
| Fastly | Before feed history | — | — |
| F5 | Rule published | 2025-04-28 | 286 |
| Akamai | No public source | — | — |
| OWASP CRS | No public claim | — | — |

### F5

- 2025-04-28 · new · rule 200102157
  > Added: signature 200102157 "Apache Superset SQL Injection (1)" (SQL-Injection, risk High), systems: Other Web Server. References: CVE-2024-39887.
  Source: https://docs.cloud.f5.com/docs-v2/platform/changelogs/security-details-changelog
- 2025-04-28 · new · rule 200102158
  > Added: signature 200102158 "Apache Superset SQL Injection (2)" (SQL-Injection, risk High), systems: Other Web Server. References: CVE-2024-39887.
  Source: https://docs.cloud.f5.com/docs-v2/platform/changelogs/security-details-changelog
- 2025-05-22 · new · rule 200102157
  > Added: signature 200102157 "Apache Superset SQL Injection (1)" (SQL-Injection, risk High), systems: Other Web Server. References: CVE-2024-39887.
  Source: https://docs.cloud.f5.com/docs-v2/platform/changelogs/security-details-changelog
- 2025-05-22 · new · rule 200102158
  > Added: signature 200102158 "Apache Superset SQL Injection (2)" (SQL-Injection, risk High), systems: Other Web Server. References: CVE-2024-39887.
  Source: https://docs.cloud.f5.com/docs-v2/platform/changelogs/security-details-changelog

## Our test (measured)

- OWASP Core Rule Set 4.25.0, paranoia level 1, anomaly threshold 5, default CRS settings: partial (1 of 3 requests blocked), template CVE-2024-39887, 2026-11-02
- OWASP Core Rule Set 4.25.0, paranoia level 2, anomaly threshold 5, default CRS settings: partial (1 of 3 requests blocked), template CVE-2024-39887, 2026-11-02

"No public claim" means no vendor statement names this CVE; "Before feed history" means the CVE is older than the vendor feed. In both cases generic rules may still block it.

HTML: https://cve.vigilbase.com/cve/CVE-2024-39887 · JSON: https://cve.vigilbase.com/api/v1/cves/CVE-2024-39887