Advisory Database
  • Advisories
  • Dependency Scanning
  1. pypi
  2. ›
  3. piccolo
  4. ›
  5. CVE-2023-47128

CVE-2023-47128: piccolo SQL Injection via named transaction savepoints

November 12, 2023 (updated October 9, 2024)

The handling of named transaction savepoints in all database implementations is vulnerable to SQL Injection as user provided input is passed directly to connection.execute(...) via f-strings.

References

  • github.com/advisories/GHSA-xq59-7jf3-rjc6
  • github.com/piccolo-orm/piccolo
  • github.com/piccolo-orm/piccolo/commit/82679eb8cd1449cf31d87c9914a072e70168b6eb
  • github.com/piccolo-orm/piccolo/security/advisories/GHSA-xq59-7jf3-rjc6
  • github.com/pypa/advisory-database/tree/main/vulns/piccolo/PYSEC-2023-241.yaml
  • nvd.nist.gov/vuln/detail/CVE-2023-47128

Code Behaviors & Features

Detect and mitigate CVE-2023-47128 with GitLab Dependency Scanning

Secure your software supply chain by verifying that all open source dependencies used in your projects contain no disclosed vulnerabilities. Learn more about Dependency Scanning →

Affected versions

All versions before 1.1.1

Fixed versions

  • 1.1.1

Solution

Upgrade to version 1.1.1 or above.

Impact 9.1 CRITICAL

CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:N

Learn more about CVSS

Weakness

  • CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')

Source file

pypi/piccolo/CVE-2023-47128.yml

Spotted a mistake? Edit the file on GitLab.

  • Site Repo
  • About GitLab
  • Terms
  • Privacy Statement
  • Contact

Page generated Tue, 13 May 2025 00:16:19 +0000.