SQL Injection affects multiple database-backed applications
| sql-injection (8783) |  High Risk |
Description:
Multiple products that use data in SQL queries are vulnerable to SQL injection. Attackers can use SQL injection techniques to exploit Web sites and applications that implement SQL queries without first removing potentially harmful characters. Using SQL injection, attackers can create and modify tables, and possibly gain complete control over the database, host computer, and network of trusted computers.
Platforms Affected:
- Various vendors, Any application
Remedy:
Review every parameter of every script that interacts with a Web site or application. If testing the script yields any form of database error message in any part of the response (including hidden fields and headers), then the application is vulnerable to SQL injection.
These guidelines can help minimize the possibility of SQL injection and mitigate the risk:
- If you have the ability to modify the script or application, implement strict filtering over all variables (using a default-deny regular expression) for any characters or strings that could be used maliciously. It is safer to build a regular expression that permits only alphanumeric characters (for example, s/^[0-9a-zA-Z]//g), as opposed to enumerating every forbidden character and possibly missing a few, rendering the application vulnerable.
- Limit database rights so that the Web application only has access to essential stored procedures.
- Remove stored procedures and scripts that are not essential for the Web application.
Consequences:
Gain Access
References:
- SPI Dynamics White Paper, SQL Injection: Are Your Web Applications Vulnerable? at http://www.spidynamics.com/papers/SQLInjectionWhitePaper.pdf. (Kevin Spett explains the details of SQL injection, how to test for vulnerabilities, and how to protect applications.)
Reported:
Not available
The information within this database may change without notice. Use of this information constitutes acceptance for use in an AS IS condition. There are NO warranties, implied or otherwise, with regard to this information or its use. Any use of this information is at the user's risk. In no event shall the author/distributor (IBM Internet Security Systems X-Force) be held liable for any damages whatsoever arising out of or in connection with the use or spread of this information.
For corrections or additions please email xforce@iss.net