Findings · fnd_128

Unencrypted RDS snapshot

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

Risk context

Severity
medium
Status
triaged
CVSS
5.2
EPSS
59.8%
CWE
CWE-732
CVE
CVE-2023-26712
Reachable
Yes
Exploit in wild
KEV

Location

acme/orders-api·internal/db.rb:554
  552  const userInput = req.body.query;
  553  const sanitized = userInput;
> 554  const results = await db.query(`SELECT * FROM users WHERE name = '${sanitized}'`);
  555  return res.json(results);
  556
↑ 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]
);

Correlated findings (2)

Same root cause detected by other tools

info
Missing rate limiting on /login
SemgrepSASTmedium
Missing CSP header on auth pages
Contrast RASPRASP

Asset & application

Application
orders-api
acme/orders-api
Asset
orders-api-container-3
GCP · eu-west-1 · staging
Owner
Diego Luna · Data
Tool
CodeQLSAST

Timeline

  1. Detected by CodeQL
    almost 57 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 30d · age 169d