120 likes | 304 Views
Remote Web Application Disassembly with ODBC error messages. Welcome!. David Litchfiel d. (dlitchfield@atstake.com). SUMMARY. 1. Basic Issue. 2. Web Application Disassembly. 3. Temporary Stored Procedures. 4. Risk Prevention. What is SQL ?. Structured Query Language.
E N D
Welcome! David Litchfield (dlitchfield@atstake.com)
SUMMARY 1. Basic Issue 2. Web Application Disassembly 3. Temporary Stored Procedures 4. Risk Prevention
What is SQL ? Structured Query Language Database Server Strings Select * from tbl where name=‘string’
Web Servers ASP & IIS Feeds Into a SQL Server
Strings & Single Quotes SELECT * FROM TBL WHERE NAME = ‘FOO’ SELECT * FROM TBL WHERE NAME = ‘FO’O’ SELECT * FROM TBL WHERE NAME = ‘FO’ SELECT * FROM TBL2 --O’
Web Application Disassembly Structure of the database - Table names - Columns - Data Types
Let’s Start Single Quote Group By Compute Sum
Creating a Log in Account ‘ insert into tblusers (username,password) values (‘foo’,’bar’) ACCOUNT CREATION SUCCESSFUL
Temporary Stored Procedures XP_CMDSHELL CREATE PROC MS00-048 EXECUTE
Risk Prevention Replace IIS App Properties
QUESTIONS ? Thank You