CWE-89 - Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')

Weakness Name: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')

Description: The product constructs all or part of an SQL command using externally-influenced input from an upstream component, but it does not neutralize or incorrectly neutralizes special elements that could modify the intended SQL command when it is sent to a downstream component. Without sufficient removal or quoting of SQL syntax in user-controllable inputs, the generated SQL query can cause those inputs to be interpreted as SQL instead of ordinary user data.

Common Consequences: Scope: Confidentiality, Integrity, Availability
Impact: Execute Unauthorized Code or Commands
Notes: Adversaries could execute system commands, typically by changing the SQL statement to redirect output to a file that can then be executed.
Scope: Confidentiality
Impact: Read Application Data
Notes: Since SQL databases generally hold sensitive data, loss of confidentiality is a frequent problem with SQL injection vulnerabilities.
Scope: Authentication
Impact: Gain Privileges or Assume Identity, Bypass Protection Mechanism
Notes: If poor SQL commands are used to check user names and passwords or perform other kinds of authentication, it may be possible to connect to the product as another user with no previous knowledge of the password.
Scope: Access Control
Impact: Bypass Protection Mechanism
Notes: If authorization information is held in a SQL database, it may be possible to change this information through the successful exploitation of a SQL injection vulnerability.
Scope: Integrity
Impact: Modify Application Data
Notes: Just as it may be possible to read sensitive information, it is also possible to modify or even delete this information with a SQL injection attack.