Five Ways to Stop Mass SQL Injection Attacks
A new wave of mass SQL injection attacks seen in mid-August to hit over half a million websites, including parts of Apple’s site serves as a weighty reminder of the growing prevalence of mass injections and of SQL injections in general as a favorite means of hackers to tap into organizations’ infrastructure and data resources.
In light of these attacks, security researchers believe now is as good of a time as any to revisit some best practices necessary to prevent mass SQL injections and mitigate the risks associated with injection attacks. These practices are hardly revolutionary, but it is clear that they aren’t being implemented as widely as they need to be.
“You keep seeing the same issues come up over and over again for many years now,” says Alex Rothacker, manager of Team SHATTER, Application Security Inc.’s research arm. “Even with this Apple attack, they used a little bit more advanced attacks, but still it’s stuff that’s been talked about at Black Hat for two years now.”
1. Never trust input.
This should be one of the mantras of developers as they write Web application code. According to Jacob West, security research director for Fortify Security, organizations should “create and enforce secure coding guidelines for software developed in-house that requires SQL be constructed using parameterized queries, which prevent SQL injection attacks by differentiating code from data.”
Developers should work to ensure that inputs are sanitized before querying the database, Rothacker says. “Make sure that the data that people input into your website is exactly the data you’re looking for, so if you’re asking for a social security number, you want to make sure it is actually a social security number and there are no letters in there,” he says.
2. Implement filtering and monitoring tools.
Filtering and monitoring tools at the Web application and database levels will help block attacks and detect attack behavior in order to mitigate risk of exposure to mass SQL injection attacks.
At the application level, West says that organizations should “wear suspenders,” by implementing runtime security monitoring to defend against SQL injection attacks and vulnerabilities in production systems. Similarly, Web application firewalls can help organizations put certain behavior-based rule sets in place to block attacks before they do damage.
On the database, database activity monitoring can also filter attacks from the back end, Rothacker says. “Database activity monitoring is a really great tool against SQL injections,” he explains. “For known injection attacks, there’s always filters out there that will help alert the DBAs that something bad is going on and there’s also some pretty generic filters that look for things that are very typical in SQL injections — things like an uneven number of quotes that break up the SQL code and stuff like that.”
(more…)


