Cyber Risks · Qualys Blog

Thwarting SQL Injection Attacks: Best Defense Practices | Qualys

Summary: SQL injection attacks rose 87% in the first quarter of the year compared with the fourth quarter of 2015, according to Akamai's State of the Internet Security Report cited by Qualys, and more than 20 million records were leaked through SQLi exploitation in the prior 18 months. The article walks through injection types - including a UNION-based attack that pulls card numbers from a credit_cards table, a DROP TABLE statement that deletes that table, blind SQLi that binary-searches the schema, time-delay attacks using BENCHMARK and WAITFOR, and a login bypass using " OR 1 = 1 --" - and notes that in 2005 CardSystems lost 40 million credit card numbers because it stored the data in plain text.

Bottom line: The CardSystems breach cost 40 million card numbers and six months of undetected exfiltration, and the article's own point is that blacklisting, escaping and hiding error messages still leave second-order SQLi open - only parameterized queries close it.

Read the original at Qualys Blog ↗

Topics
Vulnerabilities & Patching
Related