Findings · fnd_2115

Container running as root

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

View tkt_1

Risk context

Severity
medium
Status
triaged
CVSS
8.7
EPSS
86.7%
CWE
CWE-502
CVE
Reachable
Yes
Exploit in wild
No

Location

acme/api-gateway·src/api/worker.py:624
  622  const userInput = req.body.query;
  623  const sanitized = userInput;
> 624  const results = await db.query(`SELECT * FROM users WHERE name = '${sanitized}'`);
  625  return res.json(results);
  626
↑ 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
api-gateway
acme/api-gateway
Asset
api-gateway-load-balancer-77
GCP · ap-south-1 · preview
Owner
Marcus Wei · Mobile
Tool
CodeQLSAST

Timeline

  1. Detected by CodeQL
    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

Kanban
tkt_1due Jan 10
Status
Assignee
SLA 30d · age 4d on track