Medium severity · published Aug 30, 2026
CVE-2026-77454
exists/2 predicate silently dropped on limited relationships with a parent() filter in AshSql
5.9
CVSS
0.2%
EPSS
No
On KEV
Description
Incorrect Authorization vulnerability in ash-project ash_sql allows a caller to bypass a scoping or authorization filter expressed as exists/2 over a relationship that declares both a limit (or from_many?) and a parent(...)-referencing filter or sort.
AshSql.Join.related_query/3 skips the caller-supplied exists predicate for such relationships and delegates it to limit_from_many/5. When the relationship's own filter or sort references parent(...), limit_from_many/5 takes a branch that drops both the limit and the predicate, emitting a bare correlated EXISTS with no predicate. The check then matches any record that has any related row. Most severely, when the expression backs a policy (for example authorize_if expr(exists(memberships, user_id == ^actor(:id)))), the actor-scoping condition disappears and the policy passes for any actor with any related row.
This issue affects ash_sql: from 0.4.1 before 0.7.1.
Exploitation
Is it being used?
Exploit prediction (EPSS)0.2% · higher than 7% of CVEs
Exploited in the wildNo evidence yet
CISA KEVNot listed
Ransomware campaign useNot known
Affected products
Which versions
AS
ash_sql · ash-project
0.4.1 before 0.7.1; e26a63b29bd7501505fafd726f14262cdc3b6629 before 865fdd4e5e70724a23b19c048e6768c31d2209ab · source: vendor
References
NVD
https://nvd.nist.gov/vuln/detail/CVE-2026-77454
CVE.org
https://www.cve.org/CVERecord?id=CVE-2026-77454
cna.erlef.org
https://cna.erlef.org/cves/CVE-2026-77454.html
github.com
https://github.com/ash-project/ash_sql/commit/865fdd4e5e70724a23b19c048e6768c31d2209ab
github.com
https://github.com/ash-project/ash_sql/security/advisories/GHSA-8v9m-8pxv-738c
osv.dev
https://osv.dev/vulnerability/EEF-CVE-2026-77454
More from ash_sql
2.1
CVE-2026-81316
Same-named aggregates with differing filters are conflated in AshSql
2.1
CVE-2026-81318
Distinct-query aggregate drops the tenant schema prefix, leaking across tenants in AshSql
2.1
CVE-2026-78691
Unescaped backslash allows LIKE wildcard injection in AshSql string search
2.1
CVE-2026-80227
SQL string_trim removes only spaces, diverging from in-memory trimming in AshSql
