CVE-2023-34233: Snowflake connector python Snowflake Python Connector Vulnerable To Vulnerability
HIGHCVE-2023-34233 is a HIGH (CVSS 7.3) snowflake python connector vulnerable to vulnerability (CWE-77: Improper Neutralization of Special Elements used in a Command ('Command Injection')) affecting Snowflake connector python libraries in the PyPI ecosystem. The issue involves snowflake python connector vulnerable to command injection. Remediation is available by upgrading affected packages to version 3.0.2.
CVE-2023-34233 at a Glance
Security Impact
CVSS: 7.3
The security impact metrics below are parsed directly from the CVSS v3.1 vector string (CVSS:3.1/AV:N/AC:L/PR:L/UI:R/S:U/C:H/I:H/A:N).
How to Fix CVE-2023-34233
To remediate this vulnerability, upgrade all affected Snowflake connector python dependencies to a patched release. Both direct and transitive dependencies should be checked, as frameworks or security libraries may pull in vulnerable versions transitively.
pip install snowflake-connector-python>=3.0.2
Run the following command in your project directory to verify that all resolved dependencies use the patched release:
pip show snowflake-connector-python
How to Check if You Are Affected
To determine whether your Python environment is affected by CVE-2023-34233, inspect your installed packages using pip:
pip show snowflake-connector-python
Analyze the terminal output to locate any version of Snowflake connector python in your dependency tree. If any resolved version matches the vulnerable ranges listed in the table below (for example, versions earlier than 3.0.2), your application is affected.
Note: The pip show snowflake-connector-python command checks currently installed packages in your active Python environment.
Technical Details
Vulnerability Mechanism & Technical Analysis
This vulnerability is classified under CWE-77: Improper Neutralization of Special Elements used in a Command ('Command Injection'), where the product constructs all or part of a command using externally-influenced input from an upstream component, but it does not neutralize or incorrectly neutralizes special elements that could modify the intended command when it is sent to a downstream component. In Snowflake connector python, software state validation or input boundaries are circumvented during processing. Review the official source advisory statement below for specific affected components, classes, and reproduction details.
Source Advisory Statement
CVE-2023-34233 Affected Snowflake connector python Versions
1 component(s)| Product / Package | Ecosystem | Affected Versions | Fixed Version |
|---|---|---|---|
|
snowflake-connector-python
|
PyPI |
< 3.0.2
|
3.0.2
|
References
Frequently Asked Questions
What is CVE-2023-34233?
Which Snowflake connector python versions are affected?
What version fixes CVE-2023-34233?
Is snowflake-connector-python affected?
What is the CVSS score of CVE-2023-34233?
What CWE is associated with CVE-2023-34233?
How can I check PyPI dependencies for CVE-2023-34233?
Machine-readable OSV JSON
OSV v1.5 Schema
{
"schema_version" : "1.4.0",
"id" : "GHSA-5w5m-pfw9-c8fp",
"modified" : "2024-10-28T14:29:10Z",
"published" : "2023-06-09T22:53:14Z",
"aliases" : [ "CVE-2023-34233" ],
"summary" : "Snowflake Python Connector vulnerable to Command Injection",
"details" : "### Issue\nSnowflake was informed via our bug bounty program of a command injection vulnerability in the Snowflake Python connector via SSO browser URL authentication. \n\n### Impacted driver package: \nsnowflake-connector-python\n\n### Impacted version range: \nbefore [Version 3.0.2](https://community.snowflake.com/s/article/Snowflake-Connector-for-Python-Release-Notes)\n\n### Attack Scenario\nIn order to exploit the potential for command injection, an attacker would need to be successful in (1) establishing a malicious resource and (2) redirecting users to utilize the resource. The attacker could set up a malicious, publicly accessible server which responds to the SSO URL with an attack payload. If the attacker then tricked a user into visiting the maliciously crafted connection URL, the user’s local machine would render the malicious payload, leading to a remote code execution. \n\nThis attack scenario can be mitigated through URL whitelisting as well as common anti-phishing resources. \n\n### Solution\nOn March 23rd, 2023, Snowflake merged a patch that fixed a command injection vulnerability in the Snowflake Python connector via SSO browser URL authentication. The vulnerability affected the Snowflake Python connector before Version 3.0.2. We strongly recommend users upgrade to Version 3.0.2 as soon as possible via the following resources: [Snowflake Python Connector](https://docs.snowflake.com/en/developer-guide/python-connector/python-connector)\n\n### Additional Information\nIf you discover a security vulnerability in one of our products or websites, please report the issue to HackerOne. For more information, please see our [Vulnerability Disclosure Policy](https://hackerone.com/snowflake?type=team).",
"severity" : [ {
"type" : "CVSS_V3",
"score" : "CVSS:3.1/AV:N/AC:L/PR:L/UI:R/S:U/C:H/I:H/A:N"
}, {
"type" : "CVSS_V4",
"score" : "CVSS:4.0/AV:N/AC:L/AT:N/PR:L/UI:P/VC:H/VI:H/VA:N/SC:N/SI:N/SA:N"
} ],
"affected" : [ {
"package" : {
"ecosystem" : "PyPI",
"name" : "snowflake-connector-python"
},
"ranges" : [ {
"type" : "ECOSYSTEM",
"events" : [ {
"introduced" : "0"
}, {
"fixed" : "3.0.2"
} ]
} ]
} ],
"references" : [ {
"type" : "WEB",
"url" : "https://github.com/snowflakedb/snowflake-connector-python/security/advisories/GHSA-5w5m-pfw9-c8fp"
}, {
"type" : "ADVISORY",
"url" : "https://nvd.nist.gov/vuln/detail/CVE-2023-34233"
}, {
"type" : "WEB",
"url" : "https://github.com/snowflakedb/snowflake-connector-python/pull/1480"
}, {
"type" : "WEB",
"url" : "https://github.com/snowflakedb/snowflake-connector-python/commit/1cdbd3b1403c5ef520d7f4d9614fe35165e101ac"
}, {
"type" : "WEB",
"url" : "https://github.com/pypa/advisory-database/tree/main/vulns/snowflake-connector-python/PYSEC-2023-88.yaml"
}, {
"type" : "PACKAGE",
"url" : "https://github.com/snowflakedb/snowflake-connector-python"
} ],
"database_specific" : {
"cwe_ids" : [ "CWE-77" ],
"severity" : "HIGH",
"github_reviewed" : true,
"github_reviewed_at" : "2023-06-09T22:53:14Z",
"nvd_published_at" : "2023-06-08T21:15:17Z"
}
}