CVE-2026-77454— exists/2 predicate silently dropped on limited relationships with a parent() filter in AshSql
Quick assessment
Affected
ash-project ash_sql
Exploitation
No confirmed in-the-wild exploitation; assess based on exposure
Recommended action
Check the vendor advisory and references for a fixed version. If immediate upgrade is impossible, restrict exposure and increase monitoring.
ash-project 的 ash_sql 中存在一个授权不当（Incorrect Authorization）漏洞，允许调用者绕过以 形式表达的范围限定或授权过滤器，该过滤器作用于同时声明了 （或 ）以及引用 的过滤器或排序的关系上。 ash_sql 中的 函数 会跳过调用者提供的 谓词，并将其委托给 。当关系自身的过滤器或排序引用 时， 会走一个分支，该分支同时丢弃了 和谓词，最终生成一个没有任何谓词的、裸的相关子句 。这导致该检查会匹配任何拥有至少一行关联记录的记录。 影响最为严重的情形是，当该表达式支撑某个
Possible ATT&CK Techniques 1 AI
T1210 · Exploitation of Remote Services
Get alerts for future matching vulnerabilities
Log in to subscribe
I. Basic Information for CVE-2026-77454
Vulnerability Information
Have questions about the vulnerability? See if Shenlong's analysis helps!
View Shenlong Deep Dive ↗
Although we use advanced large model technology, its output may still contain inaccurate or outdated information.Shenlong tries to ensure data accuracy, but please verify and judge based on the actual situation.
Vulnerability Title
exists/2 predicate silently dropped on limited relationships with a parent() filter in AshSql
Source: CVE Program / CVE List V5
Vulnerability 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.
Source: CVE Program / CVE List V5
CVSS Information
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
Source: CVE Program / CVE List V5
Vulnerability Type
授权机制不正确
Source: CVE Program / CVE List V5
Affected Products
| Vendor | Product | Affected Versions | CPE | Subscribe |
|---|---|---|---|---|
| ash-project | ash_sql | 0.4.1 ~ 0.7.1 |
cpe:2.3:a:ash-project:ash_sql:*:*:*:*:*:*:*:*
|
|
| ash-project | ash_sql | e26a63b29bd7501505fafd726f14262cdc3b6629 ~ 865fdd4e5e70724a23b19c048e6768c31d2209ab |
cpe:2.3:a:ash-project:ash_sql:*:*:*:*:*:*:*:*
|
|
II. Public POCs for CVE-2026-77454
| # | POC Description | Source Link | Shenlong Link |
|---|
AI-Generated POC
Premium
No public POC found.
Login to generate AI POCIII. Intelligence Information for CVE-2026-77454
请登录查看更多情报信息。
Other References for CVE-2026-77454 (4)
-
https://github.com/ash-project/ash_sql/security/advisories/GHSA-8v9m-8pxv-738c vendor-advisory related
Same Patch Batch · ash-project · 2026-08-30 · 11 CVEs total
| CVE-2026-75847 | 5.9 MEDIUM | Sensitive attribute values stored in a non-sensitive public changes map in AshPaperTrail |
| CVE-2026-77970 | 5.9 MEDIUM | Sensitive fields nested in embedded values are not redacted in AshPaperTrail versions |
| CVE-2026-78038 | 5.9 MEDIUM | Job argument injection via :args overrides primary_key and tenant in AshOban |
| CVE-2026-78228 | 5.9 MEDIUM | Unbounded handle_error recursion enables denial of service in AshOban triggers |
| CVE-2026-77831 | 2.1 LOW | Algorithmic-complexity denial of service in AshPaperTrail full-diff list tracking |
| CVE-2026-77846 | 2.1 LOW | JSON path injection via unescaped get_path segments in AshSqlite |
| CVE-2026-81318 | 2.1 LOW | Distinct-query aggregate drops the tenant schema prefix, leaking across tenants in AshSql |
| CVE-2026-78691 | 2.1 LOW | Unescaped backslash allows LIKE wildcard injection in AshSql string search |
| CVE-2026-80227 | 2.1 LOW | SQL string_trim removes only spaces, diverging from in-memory trimming in AshSql |
| CVE-2026-81316 | 2.1 LOW | Same-named aggregates with differing filters are conflated in AshSql |
IV. Related Vulnerabilities
Same product: ash_sql
-
CVE-2026-81316
Same-named aggregates with differing filters are conflated i -
CVE-2026-81318
Distinct-query aggregate drops the tenant schema prefix, lea -
CVE-2026-78691
Unescaped backslash allows LIKE wildcard injection in AshSql -
CVE-2026-80227
SQL string_trim removes only spaces, diverging from in-memor
Same vendor: ash-project
-
CVE-2026-81316
Same-named aggregates with differing filters are conflated i -
CVE-2026-81318
Distinct-query aggregate drops the tenant schema prefix, lea -
CVE-2026-78691
Unescaped backslash allows LIKE wildcard injection in AshSql -
CVE-2026-80227
SQL string_trim removes only spaces, diverging from in-memor -
CVE-2026-78228
Unbounded handle_error recursion enables denial of service i
Same weakness: CWE-863
-
CVE-2026-82634
Frappe Framework Development Branch Incorrect Authorization -
CVE-2026-81316
Same-named aggregates with differing filters are conflated i -
CVE-2026-81318
Distinct-query aggregate drops the tenant schema prefix, lea -
CVE-2026-82463
pac4j-core before 6.5.6 Authorization Bypass via Reversed Pr -
CVE-2026-62904
Microsoft Edge (Chromium-based) Information Disclosure Vulne
V. Comments for CVE-2026-77454
No comments yet