---
id: "CVE-2024-24811"
page: "https://infrastack.ai/live/CVE-2024-24811"
kind: "vulnerability"
aliases: ["CVE-2024-24811", "GHSA-r3jc-3qmm-w3pw"]
title: "SQLAlchemyDA unauthenticated arbitrary SQL query execution"
severity: "critical"
cvss: 9.8
epss: 0.00889
exploited: false
status: "open"
category: "package"
products: [{"name": "Products.SQLAlchemyDA", "fixed": ["2.2"], "affected": "< 2.2", "ecosystem": "pypi"}, {"name": "zope sqlalchemyda", "fixed": ["2.2"], "affected": "< 2.2", "ecosystem": "vendor"}]
ecosystems: ["pypi", "vendor"]
tags: ["cwe-89", "package", "plone", "python", "sqlalchemy", "zope"]
not_affected_if: []
published_at: "2024-02-07T15:15:08+00:00"
first_seen_at: "2026-11-16T16:03:22+00:00"
updated_at: "2026-11-16T16:08:50+00:00"
sources: [{"source": "ghsa", "url": "https://github.com/advisories/GHSA-r3jc-3qmm-w3pw", "first_seen_at": "2026-11-16T16:03:22+00:00"}, {"source": "nvd", "url": "https://nvd.nist.gov/vuln/detail/CVE-2024-24811", "first_seen_at": "2026-11-16T16:08:50+00:00"}]
exploit_sources: [{"type": "epss", "score": 0.00889, "url": "https://api.first.org/data/v1/epss?cve=CVE-2024-24811"}]
---

# SQLAlchemyDA unauthenticated arbitrary SQL query execution

Link for people: https://infrastack.ai/live/CVE-2024-24811 (this .md is for agents)

Products.SQLAlchemyDA, a Zope/Plone library for connecting to SQL databases, lets an unauthenticated attacker execute arbitrary SQL statements on the connected database. An attacker can read, change or delete any data the database account can reach.

_Summary, check and fix written by a model from the sources; labelled as such._

## Affected

- pypi:Products.SQLAlchemyDA affected < 2.2 fixed 2.2
- vendor:zope sqlalchemyda affected < 2.2 fixed 2.2

## How to check

- Check the installed version of Products.SQLAlchemyDA with `pip show Products.SQLAlchemyDA`
- Look for `Products.SQLAlchemyDA` in `requirements.txt`, `setup.py` or `pyproject.toml` to see the pinned version
- Confirm whether the instance exposes SQLAlchemy Z SQL Methods to unauthenticated web requests

## Fix

- Products.SQLAlchemyDA: upgrade to `2.2`

## Timeline

- 2026-11-16T16:03:22+00:00 ghsa https://github.com/advisories/GHSA-r3jc-3qmm-w3pw
- 2026-11-16T16:08:50+00:00 nvd https://nvd.nist.gov/vuln/detail/CVE-2024-24811

## Documents

- [advisory] Maintainer's advisory: api.github.com https://api.github.com/repos/zopefoundation/Products.SQLAlchemyDA/security-advisories/GHSA-r3jc-3qmm-w3pw
- [advisory] Maintainer's advisory: github.com https://github.com/zopefoundation/Products.SQLAlchemyDA/security/advisories/GHSA-r3jc-3qmm-w3pw
- [fix] Patch: github.com https://github.com/zopefoundation/Products.SQLAlchemyDA/commit/e682b99f8406f20bc3f0f2c77153ed7345fd215a

## From the sources

SQLAlchemyDA is a generic database adapter for ZSQL methods. A vulnerability found in versions prior to 2.2 allows unauthenticated execution of arbitrary SQL statements on the database to which the SQLAlchemyDA instance is connected. All users are affected. The problem has been patched in version 2.2. There is no workaround for the problem.

---

_Free to read, with fair use of about 60 pages a minute. For higher limits or API access: sales@infrastack.ai_
