So just how big is the problem? The number of SQL injection attempts has gone from a few thousand a day just last year to more than half a million a day now, according to IBM's ISS X-Force. The bad guys are using automated tools to find out where SQL injection is possible, evaluating the sites for the best exploitation possibilities. These bad guys are really bad. They aren't looking to be disruptive; they're looking to steal credit card numbers and identities for profit. These are the exploits that tripped up the likes of Heartland Payment Systems and retailer TJX. And even if you aren't processing lots of credit cards, there's reason to guard against SQL injection, as the exploit also can be used as a first step to modifying your Web site to spread malware.
And how might you be exacerbating the problem? Perhaps one of the most frustrating aspects of preventing SQL injections, is that there's no single security technology you can buy that will keep your apps safe. In particular, looking to the likes of Microsoft, Oracle, and IBM to produce a database impervious to injections is wrong headed. This is an exploit that depends on lax coding and poor application design practices. If you're operating like a lot of companies, chances are that you've outsourced both the coding and design of your applications. Chances are equally good that you didn't choose your developers based on their excellent practices in code security. So unless your team is carefully reviewing the code from your contracted developer, chances are unnervingly good that your application is susceptible to SQL injections.
However, lots of apps work just fine when they have root access but not when they have more limited access. Figuring out why that is and fixing it can take time, and your resource-constrained IT staffers who are feeling pressure from line-of-business application owners may just run the app with root privilege even though they know they shouldn't. Once it's up and working, that's the sort of security lapse that could go unnoticed for months or years.
No one sets out to create an insecure application, but it's all too easy to end up with one.
Art Wittmann is director of InformationWeek Analytics, a portfolio of decision-support tools.. Write to him at [email protected].
To find out more about Art Wittmann, please visit his page.
Register to see all reports at InformationWeek Analytics.