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
-
how create multilanguage website in php using unicode database as mysql?
by osmancarik (2 replies)
-
how to find second largest number through a query in sql
by om_java2009 (29 replies)
-
Lets Open our Eyes
by mawcot (0 replies)
-
Check this out - Free PHP Security Videos
by Arne1983 (1 replies)
-
Malaysia Web Design Projects (MWDP)
by karsin (0 replies)
Related podcasts
-
Roundup 09 - Java Plugin Architectures
Roundup 09 - Plug-in Architectures in JavaFully formatted shownotes can always be found at http://javaposse.com NetBeans pluginshttp://platform.netbeans.org/tutorials/nbm-google.html IntelliJ pluginshttp://www.jetbrains.com/idea/plugins/plugin_developers.html Hudson pluginshttp://wiki.hudson-c...
Events coming up
-
Dec
3
The Auckland PHP December meetup
Auckland, New Zealand
Topic: Magento E-Commerce platform Speaker: Robert Popovic, LERO9, Robert is the Technical Director and co-founder of LERO9. Robert attended the Electrotechnical Faculty at The University of Belgrade where he graduated with a Masters in Computer Science and Information Technology. Robert has worked exclusively in the field of web and software development throughout his career.
http://database.ittoolbox.com/browse.asp?c=DBPeerPublishing&r=%2Fpub%2FSG090202%2Epdf
This thread is for discussions of SQL Injection Attacks by Example.