CVE-2024-49750

Snowflake Connector for Python exposed sensitive data in DEBUG logs.

• CVSS 5.5
• CWE-532
• Information Leakage
• Remote

The Snowflake Connector for Python provides an interface for developing Python applications that can connect to Snowflake and perform all standard operations. Prior to version 3.12.3, when the logging level was set by the user to DEBUG, the Connector could have logged Duo passcodes (when specified via the `passcode` parameter) and Azure SAS tokens. Additionally, the SecretDetector logging formatter, if enabled, contained bugs which caused it to not fully redact JWT tokens and certain private key formats. Snowflake released version 3.12.3 of the Snowflake Connector for Python, which fixes the issue. In addition to upgrading, users should review their logs for any potentially sensitive information that may have been captured.

CVE

CVE-2024-49750

CWE

CWE-532

CVSS base score

5.5

Published

2024-10-24

OWASP

A03 Sensitive Data Exposure

Orthogonal defect classification

Checking

Code defect classification

Missing Check

Category

Information Leakage

Subcategory

Insecure Handling of Sensitive Data

Accessibility scope

Remote

Impact

Information Disclosure

Affected component

Snowflake Co

Fixed by upgrading

Yes

Solution

Upgrade to version 3.12.3 of the Snowflake Connector for Python and review logs for sensitive information.

import logging
from snowflake.connector import connect

logging.basicConfig(level=logging.DEBUG)
logger = logging.getLogger('snowflake.connector')

user = 'your_username'
password = 'your_password'
account = 'your_account'
passcode = 'your_duo_passcode'

conn = connect(
    user=user,
    password=password,
    account=account,
    passcode=passcode
)

cursor = conn.cursor()
try:
    cursor.execute("SELECT CURRENT_VERSION()")
    print(cursor.fetchone())
finally:
    cursor.close()
    conn.close()

import logging
from snowflake.connector import connect
import os

logging.basicConfig(level=logging.DEBUG)
logger = logging.getLogger('snowflake.connector')

user = os.getenv('SNOWFLAKE_USER')
password = os.getenv('SNOWFLAKE_PASSWORD')
account = os.getenv('SNOWFLAKE_ACCOUNT')
passcode = os.getenv('SNOWFLAKE_PASSCODE')

if not all([user, password, account, passcode]):
    logger.error("Missing environment variables for Snowflake credentials.")
    exit(1)

conn = connect(
    user=user,
    password=password,
    account=account,
    passcode=passcode
)

cursor = conn.cursor()
try:
    cursor.execute("SELECT CURRENT_VERSION()")
    print(cursor.fetchone())
finally:
    cursor.close()
    conn.close()

passcode = 'DuoPasscode123'  # Example of a Duo passcode that could be logged

@misc{vaitp:cve202449750,
  title        = {{Snowflake Connector for Python exposed sensitive data in DEBUG logs.}},
  author       = {Bogaerts, Fr\'ed\'eric and Ivaki, Naghmeh and Fonseca, Jos\'e},
  year         = {2024},
  note         = {VAITP Python Vulnerability Dataset, entry CVE-2024-49750},
  howpublished = {\url{https://netpack.pt/vaitp/vulnerability/CVE-2024-49750/}}
}