SCA: security update for com.amazon.redshift:redshift-jdbc42 (GHSA-x3wm-hffr-chwm)

critical Tenable Self-Hosted Container Security Plugin ID 420266

Description

There are packages installed that are affected by a vulnerability referenced in the following CVE:

- 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. Prior to version 2.1.0.28, 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 Redshift JDBC driver, and is inherited
code from Postgres JDBC driver. Users who do not override default settings to utilize this unsupported
query mode are not affected. This issue is patched in driver version 2.1.0.28. 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.) (CVE-2024-32888)

See Also

https://github.com/advisories/GHSA-x3wm-hffr-chwm

Plugin Details

Severity: Critical

ID: 420266

Version: Revision 1.12

Type: Local

Family: SCA Checks

Published: 1/23/2025

Updated: 7/2/2026

Supported Sensors: Tenable Cloud Security, Tenable Self-Hosted Container Security

Risk Information

VPR

Risk Factor: Medium

Score: 5

Percentile: 94.4

Vendor

Vendor Severity: Critical

CVSS v2

Risk Factor: Critical

Base Score: 10

Temporal Score: 7.4

Vector: CVSS2#AV:N/AC:L/Au:N/C:C/I:C/A:C

CVSS Score Source: CVE-2024-32888

CVSS v3

Risk Factor: Critical

Base Score: 10

Temporal Score: 8.7

Vector: CVSS:3.0/AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:H/A:H

Temporal Vector: CVSS:3.0/E:U/RL:O/RC:C

Vulnerability Information

Exploit Ease: No known exploits are available

Patch Publication Date: 5/15/2024

Vulnerability Publication Date: 5/15/2024

Reference Information

CVE: CVE-2024-32888

cwe: CWE-89