Am I affected?

type your ash_sql version to check

Description

Incorrect Authorization vulnerability in ash-project ash_sql allows a caller to receive an aggregate value computed over rows a more restrictive filter should have excluded, disclosing counts, sums, or lists across an authorization or tenancy boundary.

AshSql.Aggregate.different_queries?/2 reports two aggregate queries as different only when their filter and their sort both differ. Aggregate queries rarely carry a sort, so two aggregates that share a name but carry entirely different filters compare as identical. The colliding aggregate keeps its name and is treated as already computed, and select_aggregates returns the first-registered variant's value. The same name reaches the builder twice with different filters when actor or tenant context is stamped into each aggregate's query, so a narrowly filtered aggregate can be served the value of a previously registered broad one.

This issue affects ash_sql: from 0.1.0 before 0.7.1.

Weaknesses & attack patterns

Weakness

CWE-863 · Incorrect Authorization in catalog → MITRE ↗

Attack patterns

CAPEC-1 · Accessing Functionality Not Properly Constrained by ACLs MITRE ↗

Affected — Hex / ash_sql Hex.pm ↗ Repository ↗

0.1.0 < 0.7.1 affected
every other version: unaffected
cpe cpe:2.3:a:ash-project:ash_sql:*:*:*:*:*:*:*:*
modules · source files · routines
modules 'Elixir.AshSql.Aggregate'
source files lib/aggregate.ex
routines 'Elixir.AshSql.Aggregate':different_queries?/2 · 'Elixir.AshSql.Aggregate':add_aggregates/6

Affected — GitHub / ash-project/ash_sql Repository ↗

dd092ed < 4b95468 affected
every other version: unaffected
cpe cpe:2.3:a:ash-project:ash_sql:*:*:*:*:*:*:*:*
modules · source files · routines
modules 'Elixir.AshSql.Aggregate'
source files lib/aggregate.ex
routines 'Elixir.AshSql.Aggregate':different_queries?/2 · 'Elixir.AshSql.Aggregate':add_aggregates/6

Configurations

An application must compute an aggregate whose name also reaches the query builder under a second, differently filtered context (for example the same aggregate used both as a filter dependency and loaded, where actor or tenant scoping stamps distinct filters onto each).

References

Credits

Peter Ullrich Finder Reporter
Zach Daniel / Ash Project Remediation developer
Jonatan Männchen / EEF Coordinator

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
« All CVEs