Improper Neutralization of Special Elements used in an SQL Command (‘SQL Injection’)
| Property | |
|---|---|
| Language |  |
| Severity |  |
| CWE | CWE-89: Improper Neutralization of Special Elements used in an SQL Command (‘SQL Injection’) |
| OWASP | A01:2017 - Injection |
| Confidence Level | Low |
| Impact Level | High |
| Likelihood Level | Low |
Description#
Building SQL queries in Python using string concatenation or formatting with variables in pg8000 can allow attackers to inject malicious SQL if any variable is user-controlled. Instead, always use parameterized queries or prepared statements to safely include user input in SQL statements.
Impact#
If exploited, attackers could execute arbitrary SQL commands against your database, potentially reading or modifying sensitive data, bypassing authentication, or destroying data. This can lead to data breaches, loss of data integrity, and serious security incidents impacting both users and the organization.