Miggo Logo
Miggo Vulnerability Database
→
CVE-2024-12745

CVE-2024-12745: Amazon Redshift Python Connector vulnerable to SQL Injection

8

CVSS Score
3.1

Basic Information

CVE ID
CVE-2024-12745
GHSA ID
GHSA-8gc2-vq6m-rwjw
EPSS Score
0.03268%
CWE
CWE-89
Published
12/26/2024
Updated
12/26/2024
KEV Status
No
Technology
TechnologyPython

Technical Details

CVSS Vector
CVSS:3.1/AV:N/AC:L/PR:L/UI:R/S:U/C:H/I:H/A:H
Package NameEcosystemVulnerable VersionsFirst Patched Version
redshift_connectorpip= 2.1.42.1.5

Vulnerability Intelligence
Miggo AIMiggo AI

Miggo AIRoot Cause Analysis

The advisory explicitly names get_schemas, get_tables, and get_columns Metadata APIs as vulnerable entry points. These methods handle schema/table/column name parameters that were directly interpolated into SQL commands without proper parameterization in v2.1.4. The patch notes confirm these were fixed by adding QUOTE_IDENT/QUOTE_LITERAL sanitization, indicating they were previously building raw SQL strings with user inputs. While exact file paths aren't provided in disclosures, these methods are core metadata API functions that would logically reside in the Cursor class implementation (cursor.py) based on Python DB API patterns and Redshift connector architecture.

Vulnerable functions

Only Mi**o us*rs **n s** t*is s**tion

WAF Protection Rules

WAF Rule

### Summ*ry * SQL inj**tion in t** *m*zon R**s*i*t Pyt*on *onn**tor in v*rsion *.*.* *llows * us*r to **in *s**l*t** privil***s vi* s***m* inj**tion in t** **t_s***m*s, **t_t**l*s, or **t_*olumns M*t***t* *PIs. Us*rs s*oul* up*r*** to t** *riv*r v*rs

Reasoning

T** **visory *xpli*itly n*m*s **t_s***m*s, **t_t**l*s, *n* **t_*olumns M*t***t* *PIs *s vuln*r**l* *ntry points. T**s* m*t*o*s **n*l* s***m*/t**l*/*olumn n*m* p*r*m*t*rs t**t w*r* *ir**tly int*rpol*t** into SQL *omm*n*s wit*out prop*r p*r*m*t*riz*tio