Am I affected?
Description
Improper Neutralization of Special Elements in Data Query Logic vulnerability in ash-project ash_sqlite allows an attacker who controls a get_path/2 segment to traverse into nested JSON the application never exposed, disclosing private or sensitive? embedded fields.
AshSqlite.SqlImplementation builds the SQLite json_extract path with "$." <> Enum.join(right, "."), so a single segment containing ., [, ], or $ re-interprets the JSON path (for example "private.secret" descends two levels instead of naming one key). The path is bound as a parameter, so this is confined to the JSON-path grammar rather than SQL. Any endpoint that lets user input reach a get_path segment (a common pick-a-field pattern) can read nested values it never meant to expose.
This issue affects ash_sqlite: from 0.1.2-rc.0 before 0.2.18.
Weaknesses & attack patterns
Weakness
CWE-943
·
Improper Neutralization of Special Elements in Data Query Logic
in catalog →
MITRE ↗
Attack patterns
CAPEC-676
·
NoSQL Injection
MITRE ↗
Affected — Hex / ash_sqlite Hex.pm ↗ Repository ↗
modules · source files · routines
Affected — GitHub / ash-project/ash_sqlite Repository ↗
modules · source files · routines
Configurations
An application must let untrusted input reach a get_path/2 path segment over a JSON/map column (for example a public calculation or filter argument that selects a key).
References
Credits
CVSS breakdown
CVSS:4.0/AV:L/AC:L/AT:P/PR:N/UI:N/VC:L/VI:N/VA:N/SC:N/SI:N/SA:N