@lightdash/common is vulnerable to SQL Injection
71
High Risk
When an explore or metric query is compiled, user-attribute values including the intrinsic email attribute and embed-JWT-supplied attributes are substituted into the warehouse SQL string. The helper that wraps these values in the warehouse quote character never escapes them, unlike the parameter path which routes equivalent values through the warehouse escapeString function. A low-privilege authenticated user or an embed viewer can supply a value containing a quote to break out of the string literal and inject SQL that runs against the warehouse under the project's credentials, bypassing row-level security and enabling cross-tenant data exfiltration. The fix escapes user-attribute and intrinsic values with the warehouse escape function and allow-lists identifier-context substitutions.
You are affected if you are using a version that falls within the vulnerable range and the project uses user-attribute row-level security or embedded dashboards.
@lightdash/common is vulnerable to SQL Injection in versions 0.0.1 - 0.3219.0.
Upgrade the @lightdash/common library to the patch version.
Connect your repositories to instantly see whether vulnerable or malicious packages exist in your codebase.
Free. No credit card required.

I consent to receiving marketing communications based on Aikido’s Privacy Policy.
SOC 2Compliant
ISO 27001Compliant