{
    "dataType": "CVE_RECORD",
    "dataVersion": "5.2",
    "cveMetadata": {
        "cveId": "CVE-2026-77454",
        "assignerOrgId": "6b3ad84c-e1a6-4bf7-a703-f496b71e49db",
        "state": "PUBLISHED",
        "assignerShortName": "EEF",
        "dateReserved": "2026-08-30T04:45:01.559Z",
        "datePublished": "2026-08-30T12:01:23.862Z",
        "dateUpdated": "2026-08-30T12:01:23.862Z"
    },
    "containers": {
        "cna": {
            "affected": [
                {
                    "collectionURL": "https://repo.hex.pm",
                    "cpes": [
                        "cpe:2.3:a:ash-project:ash_sql:*:*:*:*:*:*:*:*"
                    ],
                    "defaultStatus": "unaffected",
                    "modules": [
                        "'Elixir.AshSql.Join'"
                    ],
                    "packageName": "ash_sql",
                    "packageURL": "pkg:hex/ash_sql",
                    "product": "ash_sql",
                    "programFiles": [
                        "lib/join.ex"
                    ],
                    "programRoutines": [
                        {
                            "name": "'Elixir.AshSql.Join':related_query/3"
                        },
                        {
                            "name": "'Elixir.AshSql.Join':limit_from_many/5"
                        }
                    ],
                    "repo": "https://github.com/ash-project/ash_sql",
                    "vendor": "ash-project",
                    "versions": [
                        {
                            "lessThan": "0.7.1",
                            "status": "affected",
                            "version": "0.4.1",
                            "versionType": "semver"
                        }
                    ]
                },
                {
                    "collectionURL": "https://github.com",
                    "cpes": [
                        "cpe:2.3:a:ash-project:ash_sql:*:*:*:*:*:*:*:*"
                    ],
                    "defaultStatus": "unaffected",
                    "modules": [
                        "'Elixir.AshSql.Join'"
                    ],
                    "packageName": "ash-project/ash_sql",
                    "packageURL": "pkg:github/ash-project/ash_sql",
                    "product": "ash_sql",
                    "programFiles": [
                        "lib/join.ex"
                    ],
                    "programRoutines": [
                        {
                            "name": "'Elixir.AshSql.Join':related_query/3"
                        },
                        {
                            "name": "'Elixir.AshSql.Join':limit_from_many/5"
                        }
                    ],
                    "repo": "https://github.com/ash-project/ash_sql",
                    "vendor": "ash-project",
                    "versions": [
                        {
                            "lessThan": "865fdd4e5e70724a23b19c048e6768c31d2209ab",
                            "status": "affected",
                            "version": "e26a63b29bd7501505fafd726f14262cdc3b6629",
                            "versionType": "git"
                        }
                    ]
                }
            ],
            "configurations": [
                {
                    "lang": "en",
                    "supportingMedia": [
                        {
                            "base64": false,
                            "type": "text/html",
                            "value": "<p>An application must use <code>exists/2</code> (in a filter or a policy) over a relationship that declares both a limit or <code>from_many?</code> and a filter or sort that references <code>parent(...)</code>. The predicate supplied to <code>exists/2</code> is the one that is dropped.</p>"
                        },
                        {
                            "base64": false,
                            "type": "text/markdown",
                            "value": "An application must use `exists/2` (in a filter or a policy) over a relationship that declares both a limit or `from_many?` and a filter or sort that references `parent(...)`. The predicate supplied to `exists/2` is the one that is dropped."
                        }
                    ],
                    "value": "An application must use exists/2 (in a filter or a policy) over a relationship that declares both a limit or from_many? and a filter or sort that references parent(...). The predicate supplied to exists/2 is the one that is dropped."
                }
            ],
            "cpeApplicability": [
                {
                    "nodes": [
                        {
                            "cpeMatch": [
                                {
                                    "criteria": "cpe:2.3:a:ash-project:ash_sql:*:*:*:*:*:*:*:*",
                                    "versionEndExcluding": "0.7.1",
                                    "versionStartIncluding": "0.4.1",
                                    "vulnerable": true
                                }
                            ],
                            "negate": false,
                            "operator": "OR"
                        }
                    ],
                    "operator": "AND"
                }
            ],
            "credits": [
                {
                    "lang": "en",
                    "type": "finder",
                    "value": "Peter Ullrich"
                },
                {
                    "lang": "en",
                    "type": "reporter",
                    "value": "Peter Ullrich"
                },
                {
                    "lang": "en",
                    "type": "remediation developer",
                    "value": "Zach Daniel / Ash Project"
                },
                {
                    "lang": "en",
                    "type": "coordinator",
                    "value": "Jonatan Männchen / EEF"
                }
            ],
            "descriptions": [
                {
                    "lang": "en",
                    "supportingMedia": [
                        {
                            "base64": false,
                            "type": "text/html",
                            "value": "<p>Incorrect Authorization vulnerability in ash-project ash_sql allows a caller to bypass a scoping or authorization filter expressed as <code>exists/2</code> over a relationship that declares both a limit (or <code>from_many?</code>) and a <code>parent(...)</code>-referencing filter or sort.</p>\n<p><code>AshSql.Join.related_query/3</code> skips the caller-supplied <code>exists</code> predicate for such relationships and delegates it to <code>limit_from_many/5</code>. When the relationship's own filter or sort references <code>parent(...)</code>, <code>limit_from_many/5</code> takes a branch that drops both the limit and the predicate, emitting a bare correlated <code>EXISTS</code> with no predicate. The check then matches any record that has any related row. Most severely, when the expression backs a policy (for example <code>authorize_if expr(exists(memberships, user_id == ^actor(:id)))</code>), the actor-scoping condition disappears and the policy passes for any actor with any related row.</p>\n<p>This issue affects ash_sql: from 0.4.1 before 0.7.1.</p>"
                        },
                        {
                            "base64": false,
                            "type": "text/markdown",
                            "value": "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.\n\n`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.\n\nThis issue affects ash_sql: from 0.4.1 before 0.7.1."
                        }
                    ],
                    "value": "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.\n\nAshSql.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.\n\nThis issue affects ash_sql: from 0.4.1 before 0.7.1."
                }
            ],
            "impacts": [
                {
                    "capecId": "CAPEC-1",
                    "descriptions": [
                        {
                            "lang": "en",
                            "value": "CAPEC-1 Accessing Functionality Not Properly Constrained by ACLs"
                        }
                    ]
                }
            ],
            "metrics": [
                {
                    "cvssV4_0": {
                        "Automatable": "NOT_DEFINED",
                        "Recovery": "NOT_DEFINED",
                        "Safety": "NOT_DEFINED",
                        "attackComplexity": "LOW",
                        "attackRequirements": "PRESENT",
                        "attackVector": "LOCAL",
                        "baseScore": 5.9,
                        "baseSeverity": "MEDIUM",
                        "privilegesRequired": "NONE",
                        "providerUrgency": "NOT_DEFINED",
                        "subAvailabilityImpact": "NONE",
                        "subConfidentialityImpact": "NONE",
                        "subIntegrityImpact": "NONE",
                        "userInteraction": "NONE",
                        "valueDensity": "NOT_DEFINED",
                        "vectorString": "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",
                        "version": "4.0",
                        "vulnAvailabilityImpact": "NONE",
                        "vulnConfidentialityImpact": "HIGH",
                        "vulnIntegrityImpact": "LOW",
                        "vulnerabilityResponseEffort": "NOT_DEFINED"
                    },
                    "format": "CVSS",
                    "scenarios": [
                        {
                            "lang": "en",
                            "value": "GENERAL"
                        }
                    ]
                }
            ],
            "problemTypes": [
                {
                    "descriptions": [
                        {
                            "cweId": "CWE-863",
                            "description": "CWE-863 Incorrect Authorization",
                            "lang": "en",
                            "type": "CWE"
                        }
                    ]
                }
            ],
            "providerMetadata": {
                "orgId": "6b3ad84c-e1a6-4bf7-a703-f496b71e49db",
                "shortName": "EEF",
                "dateUpdated": "2026-08-30T12:01:23.862Z"
            },
            "references": [
                {
                    "tags": [
                        "vendor-advisory",
                        "related"
                    ],
                    "url": "https://github.com/ash-project/ash_sql/security/advisories/GHSA-8v9m-8pxv-738c"
                },
                {
                    "tags": [
                        "related"
                    ],
                    "url": "https://cna.erlef.org/cves/CVE-2026-77454.html"
                },
                {
                    "tags": [
                        "related"
                    ],
                    "url": "https://osv.dev/vulnerability/EEF-CVE-2026-77454"
                },
                {
                    "tags": [
                        "patch"
                    ],
                    "url": "https://github.com/ash-project/ash_sql/commit/865fdd4e5e70724a23b19c048e6768c31d2209ab"
                }
            ],
            "source": {
                "discovery": "EXTERNAL"
            },
            "title": "exists/2 predicate silently dropped on limited relationships with a parent() filter in AshSql"
        }
    }
}