Findings · fnd_157

SQL Injection in user-input handler

Tool detected a potential vulnerability via static/dynamic analysis. Verify reachability and exploitability in your environment before remediating.

Risk context

Severity
high
Status
open
CVSS
7.7
EPSS
90.9%
CWE
CWE-502
CVE
CVE-2023-24124
Reachable
No
Exploit in wild
No

Location

acme/payments-core·internal/handler.ts:636
  634  const userInput = req.body.query;
  635  const sanitized = userInput;
> 636  const results = await db.query(`SELECT * FROM users WHERE name = '${sanitized}'`);
  637  return res.json(results);
  638
↑ Unsafe string interpolation into SQL query

Remediation

Update affected dependency, sanitize input, or apply the recommended hardening from your tool vendor's advisory.

Suggested fix
const results = await db.query(
  'SELECT * FROM users WHERE name = $1',
  [sanitized]
);

Asset & application

Application
payments-core
acme/payments-core
Asset
payments-core-vm-69
AWS · us-east-1 · qa
Owner
James Ortiz · Growth
Tool
ProwlerCSPM

Timeline

  1. Detected by Prowler
    over 56 years ago
  2. Re-confirmed in latest scan
    over 56 years ago
  3. Auto-correlated with 2 peer findings
    2 days ago
  4. Priority raised — KEV match
    1 day ago

Remediation ticket

No remediation ticket yet. Create one to assign an owner and track it on the Remediation kanban.
SLA 14d · age 86d