Examining the database in SQL injection attacks
Summary: PortSwigger's research note describes how attackers exploit SQL injection by first fingerprinting the database, using provider-specific version queries to identify the type and version, such as confirming Microsoft SQL Server from a UNION attack's output. It then details how most database types expose an information schema, where querying information_schema.tables and information_schema.columns reveals table names like Products, Users and Feedback along with column data types, while Oracle equivalents are all_tables and all_tab_columns.
Bottom line: A single injectable parameter can hand an attacker your table names and column types through the information schema, turning a narrow input flaw into a full map of the data behind it.
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