Web Application Penetration Test

Security Assessment Report

Client: [REDACTED] E-Commerce Platform  ·  Scope: acme-redacted.com
Report Date
2025-03-14
Engagement Type
Black Box
Testing Window
5 business days
Report Version
v1.2 (Final)
Tester
OSCP-certified
Methodology
OWASP + NIST 800-115
01 Executive Summary
1
Critical
1
High
2
Medium
3
Low
4
Info

Zero Delta Security conducted a black-box web application penetration test of the client's primary e-commerce platform between March 10–14, 2025. The engagement targeted authentication, session management, input handling, access controls, and API endpoints in scope as defined by the client.

The assessment identified 11 findings across the severity spectrum, including one Critical vulnerability (SQL Injection in the login endpoint) that would allow an unauthenticated attacker to extract the full customer database, bypass authentication entirely, and potentially escalate to remote code execution on the underlying server. This finding requires immediate remediation.

Additionally, a High-severity broken access control vulnerability allows any authenticated user to elevate privileges to an administrative role by modifying a single JWT claim. This finding was validated end-to-end and confirmed to grant full admin panel access to arbitrary user accounts.

The two Medium-severity findings — a reflected XSS in the search function and weak TLS configuration — represent meaningful risk, particularly the XSS given the platform handles payment data. The Low and Informational findings are documented for completeness and should be addressed in the normal patch cadence.

Overall security posture: Needs Immediate Attention. The Critical and High findings must be remediated before this system processes production traffic. We estimate both can be resolved within 1–2 engineering sprints with the guidance provided in Section 4.

02 Technical Findings
Critical

SQL Injection — Authentication Endpoint

ID: ZDS-001 OWASP: A03:2021 CWE: CWE-89 Endpoint: POST /api/auth/login
9.8
CVSS v3.1
Description

The login endpoint concatenates user-supplied input directly into a SQL query without parameterization. An attacker can manipulate the query structure to bypass authentication, extract arbitrary data from the database, or — on certain database configurations — write files and execute operating system commands.

Business Impact
  • Full authentication bypass — attacker logs in as any user including admins
  • Complete database extraction — all customer PII, payment tokens, and order history exposed
  • Potential RCE via xp_cmdshell or INTO OUTFILE depending on database config
  • Immediate GDPR/PCI-DSS breach notification obligations if exploited
Proof of Concept (Redacted)
HTTP Request — Authentication Bypass POST /api/auth/login HTTP/1.1 Host: ████████████████████████ Content-Type: application/json { "email": "' OR '1'='1' -- ", "password": "████████████" }
⚠ Exploitation confirmed in staging environment. Production endpoint not tested per rules of engagement.
Remediation Steps
  1. Replace all string-concatenated queries with parameterized statements or prepared statements. In Node.js/pg: use pool.query('SELECT * FROM users WHERE email = $1', [email])
  2. Audit all database query construction across the codebase — this pattern may appear in other endpoints. Run a static analysis scan (Semgrep rule sql-injection) to catch all instances.
  3. Enable Web Application Firewall (WAF) rules for SQL injection patterns as a defense-in-depth layer while remediation is in progress.
  4. After fixing, re-run penetration test on affected endpoints to validate remediation.
High

Broken Access Control — JWT Role Escalation

ID: ZDS-002 OWASP: A01:2021 CWE: CWE-285 Endpoint: All authenticated routes
8.8
CVSS v3.1
Medium

Reflected XSS — Product Search Function

ID: ZDS-003 OWASP: A03:2021 CWE: CWE-79 Endpoint: GET /search?q=
6.1
CVSS v3.1
Medium

Weak TLS Configuration — Deprecated Protocol Support

ID: ZDS-004 OWASP: A02:2021 CWE: CWE-326 Endpoint: acme-redacted.com:443
5.9
CVSS v3.1
03 Risk Matrix

Findings are plotted by Likelihood (probability of exploitation) vs Impact (business consequence if exploited). Risk score drives remediation priority independent of CVSS.

Negligible Minor Moderate Significant Catastrophic
Certain MED HIGH HIGH CRIT
ZDS-001
CRIT
Likely LOW MED HIGH
ZDS-002
CRIT CRIT
Possible INFO LOW MED
ZDS-003/004
HIGH CRIT
Unlikely INFO INFO LOW MED HIGH

↑ Likelihood axis (rows) · → Impact axis (columns)

04 Remediation Roadmap

Remediation items sequenced by risk priority. Sprint estimate assumes a 2-engineer team. Effort rating: ● = 0.5 days, ●●● = 1.5 days, ●●●●● = 3+ days.

ID Finding Priority Sprint Effort Owner
ZDS-001 SQL Injection — Auth Endpoint P1 — Immediate Sprint 1
Backend Dev
ZDS-002 JWT Role Escalation P1 — Immediate Sprint 1
Backend Dev
ZDS-003 Reflected XSS — Search P2 — High Sprint 1–2
Frontend Dev
ZDS-004 Weak TLS Configuration P2 — High Sprint 2
DevOps / Infra
ZDS-005–007 Low severity findings (3 items) P3 — Medium Sprint 3
Backend Dev
ZDS-008–011 Informational items (4 items) P4 — Low Backlog
Any dev
05 Appendix

Engagement Details

Testing Type Black Box
Start Date 2025-03-10
End Date 2025-03-14
Tester Certification OSCP, CEH
Framework OWASP + NIST 800-115
Total Scope 1 domain, 3 subdomains

Tools Used

Reconnaissance Amass, Shodan, Subfinder
Vulnerability Scanning Burp Suite Pro
SQL Injection sqlmap (manual verified)
TLS Analysis testssl.sh, SSL Labs
Auth/JWT Testing jwt_tool, Burp Decoder
Reporting Zero Delta proprietary

CVSS Scoring Reference

Critical 9.0 – 10.0
High 7.0 – 8.9
Medium 4.0 – 6.9
Low 0.1 – 3.9
Informational 0.0

Document Control

Classification CONFIDENTIAL
Distribution Client Only
Retention 3 years
Version v1.2 Final
Retest Included Yes (30 days)
Free Download

Get this report as a PDF.

Enter your email and we'll send you the full sample report in PDF format — plus a free consultation on what a ZDS engagement would uncover for your business.

No spam. No sales pressure. Unsubscribe anytime.

[✓]

Report sent.

Check your inbox — we've sent the PDF and a link to schedule your free attack surface assessment.

Ready for your own assessment?

Start with a free attack surface scan.

No commitment, no credit card. Understand your exposure in under 5 minutes.