PT-2026-152105

CVE-2026-104129

·

Published

2026-11-19

·

Updated

2026-11-20

Description by

CVSS 3.1
8.1
High
MetricsAV: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.
Exploitability
Exploit
Fix
Impacts
Vendors
Affected products
Related identifiers
GHSA-V9V2-98XQ-627C
Found an issue in the description? Have something to add? Feel free to write us 👾