Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')
CVE-2024-32888
Summary
The Amazon JDBC Driver for Redshift is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in the Java Platform, Enterprise Editions. In versions prior to 2.1.0.27, SQL injection is possible when using the non-default connection property 'preferQueryMode=simple' in combination with application code which has a vulnerable SQL that negates a parameter value. There is no vulnerability in the driver when using the default, extended query mode. Note that 'preferQueryMode' is not a supported parameter in the Redshift JDBC driver, and is inherited code from the Postgres JDBC driver. Users who do not override default settings to utilize this unsupported query mode are not affected. As a workaround, do not use the connection property 'preferQueryMode=simple'. (NOTE: Those who do not explicitly specify a query mode use the default of extended query mode and are not affected by this issue.)
- LOW
- NETWORK
- HIGH
- CHANGED
- NONE
- NONE
- HIGH
- HIGH
CWE-89 - SQL Injection
Structured Query Language (SQL) injection attacks are one of the most common types of vulnerabilities. They exploit weaknesses in vulnerable applications to gain unauthorized access to backend databases. This often occurs when an attacker enters unexpected SQL syntax in an input field. The resulting SQL statement behaves in the background in an unintended manner, which allows the possibility of unauthorized data retrieval, data modification, execution of database administration operations, and execution of commands on the operating system.
References
Advisory Timeline
- Published
