GHSA-8596-2jgr-ppj7

Suggest an improvement
Source
https://github.com/advisories/GHSA-8596-2jgr-ppj7
Import Source
https://github.com/github/advisory-database/blob/main/advisories/github-reviewed/2024/12/GHSA-8596-2jgr-ppj7/GHSA-8596-2jgr-ppj7.json
JSON Data
https://api.test.osv.dev/v1/vulns/GHSA-8596-2jgr-ppj7
Aliases
Published
2024-12-26T20:27:10Z
Modified
2025-10-14T21:54:10Z
Severity
  • 8.0 (High) CVSS_V3 - CVSS:3.1/AV:N/AC:L/PR:L/UI:R/S:U/C:H/I:H/A:H CVSS Calculator
  • 8.6 (High) CVSS_V4 - CVSS:4.0/AV:N/AC:L/AT:N/PR:L/UI:P/VC:H/VI:H/VA:H/SC:N/SI:N/SA:N CVSS Calculator
Summary
Amazon Redshift JDBC Driver vulnerable to SQL Injection
Details

Summary

A SQL injection in the Amazon Redshift JDBC Driver in v2.1.0.31 allows a user to gain escalated privileges via schema injection in the getSchemas, getTables, or getColumns Metadata APIs. Users should upgrade to the driver version 2.1.0.32 or revert to driver version 2.1.0.30.

Impact

A SQL injection is possible in the Amazon Redshift JDBC Driver, version 2.1.0.31, when leveraging metadata APIs to retrieve information about database schemas, tables, or columns.

Impacted versions: Amazon Redshift JDBC Driver version 2.1.0.31.

Patches

The issue described above has been addressed in the Amazon Redshift JDBC Driver, version 2.1.0.32.

The patch implemented in this version ensures that every metadata command input is sent to the Redshift server as part of a parameterized query, using either QUOTEIDENT(string) or QUOTELITERAL(string). After processing all the inputs into quoted identifiers or literals, the metadata command is composed using these inputs and then executed on the server.

Workarounds

Use the previous version of the Amazon Redshift JDBC Driver, 2.1.0.30.

References

If you have any questions or comments about this advisory we ask that you contact AWS/Amazon Security via our vulnerability reporting page [1] or directly via email to aws-security@amazon.com. Please do not create a public GitHub issue.

[1] Vulnerability reporting page: https://aws.amazon.com/security/vulnerability-reporting

Database specific 
{
    "cwe_ids": [
        "CWE-89"
    ],
    "github_reviewed": true,
    "github_reviewed_at": "2024-12-26T20:27:10Z",
    "nvd_published_at": "2024-12-24T17:15:07Z",
    "severity": "HIGH"
}
References

Affected packages

Maven / com.amazon.redshift:redshift-jdbc42

Package

Name
com.amazon.redshift:redshift-jdbc42
View open source insights on deps.dev
Purl
pkg:maven/com.amazon.redshift/redshift-jdbc42

Affected ranges

Type
ECOSYSTEM
Events
Introduced
2.1.0.31
Fixed
2.1.0.32

Affected versions

2.*
2.1.0.31

Database specific

source 
"https://github.com/github/advisory-database/blob/main/advisories/github-reviewed/2024/12/GHSA-8596-2jgr-ppj7/GHSA-8596-2jgr-ppj7.json"