GHSA-8gc2-vq6m-rwjw

Source

https://github.com/advisories/GHSA-8gc2-vq6m-rwjw

Import Source

https://github.com/github/advisory-database/blob/main/advisories/github-reviewed/2024/12/GHSA-8gc2-vq6m-rwjw/GHSA-8gc2-vq6m-rwjw.json

JSON Data

https://api.osv.dev/v1/vulns/GHSA-8gc2-vq6m-rwjw

Aliases

CVE-2024-12745

Related

CGA-3v4v-rfpp-3jqp

Published

2024-12-26T20:28:09Z

Modified

2024-12-26T20:42:08.779925Z

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 Python Connector vulnerable to SQL Injection

Details

Summary

A SQL injection in the Amazon Redshift Python Connector in version 2.1.4 allows a user to gain escalated privileges via schema injection in the getschemas, gettables, or get_columns Metadata APIs. Users should upgrade to the driver version 2.1.5 or revert to driver version 2.1.3.

Impact

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

Impacted versions: Amazon Redshift Python Connector version 2.1.4.

Patches

The issue described above has been addressed in the Amazon Redshift Python Connector, version 2.1.5.

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 Python Connector, version 2.1.3.

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

{
    "nvd_published_at": "2024-12-24T17:15:08Z",
    "cwe_ids": [
        "CWE-89"
    ],
    "severity": "HIGH",
    "github_reviewed": true,
    "github_reviewed_at": "2024-12-26T20:28:09Z"
}

GHSA-8gc2-vq6m-rwjw

Summary

Impact

Patches

Workarounds

References

Affected packages

PyPI / redshift-connector

Package

Affected ranges

Affected versions

2.*