Skip to content

Apache Superset's SQL Alchemy connector vulnerable to SQL Injection

Moderate severity GitHub Reviewed Published Jan 16, 2023 to the GitHub Advisory Database • Updated Jan 24, 2023

Package

pip apache-superset (pip)

Affected versions

<= 1.5.2
= 2.0.0

Patched versions

None

Description

A vulnerability in the SQL Alchemy connector of Apache Superset allows an authenticated user with read access to a specific database to add subqueries to the WHERE and HAVING fields referencing tables on the same database that the user should not have access to, despite the user having the feature flag "ALLOW_ADHOC_SUBQUERY" disabled (default value). This issue affects Apache Superset version 1.5.2 and prior versions and version 2.0.0.

References

Published by the National Vulnerability Database Jan 16, 2023
Published to the GitHub Advisory Database Jan 16, 2023
Reviewed Jan 20, 2023
Last updated Jan 24, 2023

Severity

Moderate

CVSS overall score

This score calculates overall vulnerability severity from 0 to 10 and is based on the Common Vulnerability Scoring System (CVSS).
/ 10

CVSS v3 base metrics

Attack vector
Network
Attack complexity
Low
Privileges required
Low
User interaction
None
Scope
Unchanged
Confidentiality
Low
Integrity
Low
Availability
None

CVSS v3 base metrics

Attack vector: More severe the more the remote (logically and physically) an attacker can be in order to exploit the vulnerability.
Attack complexity: More severe for the least complex attacks.
Privileges required: More severe if no privileges are required.
User interaction: More severe when no user interaction is required.
Scope: More severe when a scope change occurs, e.g. one vulnerable component impacts resources in components beyond its security scope.
Confidentiality: More severe when loss of data confidentiality is highest, measuring the level of data access available to an unauthorized user.
Integrity: More severe when loss of data integrity is the highest, measuring the consequence of data modification possible by an unauthorized user.
Availability: More severe when the loss of impacted component availability is highest.
CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N

EPSS score

0.066%
(30th percentile)

Weaknesses

CVE ID

CVE-2022-41703

GHSA ID

GHSA-cxvp-3frm-3876

Source code

Loading Checking history
See something to contribute? Suggest improvements for this vulnerability.