Lab: SQL injection UNION attack, retrieving data from other tables
Summary: This PortSwigger lab presents a SQL injection vulnerability in a product category filter, where query results are returned in the application's response, allowing a UNION attack to pull data from other tables. The database holds a separate users table with username and password columns, and the lab requires retrieving all usernames and passwords to log in as the administrator user.
Key Takeaway: The same flaw that exposes a lab's users table would hand an attacker every credential in a production database, and the path here is a single injectable filter parameter.
Read the original at PortSwigger Research ↗
- Topics
- Vulnerabilities & Patching
- Related
- Attackers Exploit UnrealIRCd Flaw That Enables Server-Level Command Injection Cyber Risks · Nov 14, 2026U.S. CISA adds Check Point and UnrealIRCd flaws to its Known Exploited Vulnerabilities catalog Cyber Risks · Nov 14, 2026PostgreSQL Patches 52 Flaws, Including 22-Year-Old Bug Enabling Authenticated RCE Cyber Risks · Nov 13, 2026