Library tutorials & articles
SQL Injection Attacks by Example
Introduction
A customer asked that we check out his intranet site, which was used by the company's employees and customers. This was part of a larger security review, and though we'd not actually used SQL injection to penetrate a network before, we were pretty familiar with the general concepts. We were completely successful in this engagement, and wanted to recount the steps taken as an illustration.
"SQL Injection" is subset of the an unverified/unsanitized user input vulnerability ("buffer overflows" are a different subset), and the idea is to convince the application to run SQL code that was not intended. If the application is creating SQL strings naively on the fly and then running them, it's straightforward to create some real surprises.
We'll note that this was a somewhat winding road with more than one wrong turn, and others with more experience will certainly have different -- and better -- approaches. But the fact that we were successful does suggest that we were not entirely misguided.
There have been other papers on SQL injection, including some that are much more detailed, but this one shows the rationale of discovery as much as the process of exploitation.
Related articles
Related discussion
-
Using PHP and IIS to Create a Discussion Forum
by CLICSARGENT (37 replies)
-
how to find second largest number through a query in sql
by salorob (27 replies)
-
Creating form within subform in php
by nyvirya (0 replies)
-
mysql problem
by aforencich (2 replies)
-
Deleting a scheduled SQL Job
by reindeer3c (2 replies)
Related jobs
-
Open Source Stack Application Server Administrator
in Luxemburg (€35K-€55K per annum)
Events coming up
-
Oct
24
MSDN Roadshow Re-Run
London, United Kingdom
Did you miss the opportunity to attend the MSDN Roadshow 2008? If so we are doing a Roadshow rerun giving you a second chance to attend this event. Come along if you want to find out about the latest developer tools and technologies from Microsoft. The MSDN team will focus on what’s coming up next this year for .NET developers beyond Visual Studio 2008. We will also look at Silverlight, ASP.NET, ADO.NET and other future bits which involve more code and less PowerPoint. Please be aware tha...
This is a good article, but check out this article to actually automatically get a copy of the whole database.
http://database.ittoolbox.com/browse.asp?c=DBPeerPublishing&r=%2Fpub%2FSG090202%2Epdf