{"id":"GHSA-r3jc-3qmm-w3pw","summary":"SQLAlchemyDA unauthenticated arbitrary SQL query execution","details":"### Impact\nThe vulnerability allows unauthenticated execution of arbitrary SQL statements on the database the SQLAlchemyDA instance is connected to. All users are affected.\n\n### Patches\nThe problem has been patched in version 2.2. \n\n### Workarounds\nThere is no workaround. All users are urged to upgrade to version 2.2\n","aliases":["CVE-2024-24811","PYSEC-2026-489"],"modified":"2026-09-10T03:50:06.413628614Z","published":"2024-02-07T17:28:26Z","database_specific":{"github_reviewed_at":"2024-02-07T17:28:26Z","nvd_published_at":"2024-02-07T15:15:08Z","cwe_ids":["CWE-89"],"severity":"CRITICAL","github_reviewed":true},"references":[{"type":"WEB","url":"https://github.com/zopefoundation/Products.SQLAlchemyDA/security/advisories/GHSA-r3jc-3qmm-w3pw"},{"type":"ADVISORY","url":"https://nvd.nist.gov/vuln/detail/CVE-2024-24811"},{"type":"WEB","url":"https://github.com/zopefoundation/Products.SQLAlchemyDA/commit/e682b99f8406f20bc3f0f2c77153ed7345fd215a"},{"type":"PACKAGE","url":"https://github.com/zopefoundation/Products.SQLAlchemyDA"}],"affected":[{"package":{"name":"products-sqlalchemyda","ecosystem":"PyPI","purl":"pkg:pypi/products-sqlalchemyda"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"2.2"}]}],"versions":["0.4.0","0.4.1","0.5.0","0.5.1","0.6.0b","0.6.0b2","0.6.0b3","0.6.0b4","0.6.0b5","0.6.0b6","0.6.0b7","0.6.1b1","0.6.2b1","0.6.2b2","1.0.0","1.0.1","1.0.2","1.1.0","2.0","2.1"],"database_specific":{"source":"https://github.com/github/advisory-database/blob/main/advisories/github-reviewed/2024/02/GHSA-r3jc-3qmm-w3pw/GHSA-r3jc-3qmm-w3pw.json"}}],"schema_version":"1.9.0","severity":[{"type":"CVSS_V3","score":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H"}]}