Lab: SQL injection attack, listing the database contents on Oracle
Summary: PortSwigger's lab presents a SQL injection vulnerability in a product category filter, where query results are returned in the application's response and a UNION attack can retrieve data from other tables. The lab requires determining the name and columns of a table holding usernames and passwords, then retrieving its contents to log in as the administrator, noting that Oracle requires every SELECT to specify a table and that the built-in dual table can be used for this purpose.
What's compelling: The exercise turns on a single injectable filter parameter exposing a table of usernames and passwords for all users, with the administrator account as the payoff - the same path an attacker takes against any application that returns query results to the user.
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