PT-2026-152105
CVE-2026-104129
·
Published
2026-11-19
·
Updated
2026-11-20
Description by
CVSS 3.1
8.1
HighMetricsAV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:N
Name of the Vulnerable Software and Affected Versions
pREST versions prior to 2.4.0
Description
An issue exists in the way the
groupby parameter is handled by the GroupByClause in adapters/postgres/postgres.go. The application uses a weak isSafeSQLExpression check for this branch instead of a stricter single-field validator. This check only validates the outer function name against an allowlist, which permits nested subqueries, trailing UNION syntax, and inner pg functions. Because controllers/crud.go concatenates the GROUP BY expression while only parameterizing WHERE values, an attacker can inject SQL structure into the clause. Default configurations allow unauthenticated access, though restricted installations may require low-privilege table reader permissions. This can lead to data extraction via UNION-based techniques or a denial of service using delay-producing functions.Recommendations
Update pREST to version 2.4.0.
As a temporary mitigation, avoid using the
groupby parameter in API requests. Found an issue in the description? Have something to add? Feel free to write us 👾