{"id":"CVE-2024-24811","aliases":["EUVD-2024-0707","GHSA-r3jc-3qmm-w3pw","PYSEC-2026-489"],"status":"published","title":"Products.SQLAlchemyDA  vulnerable to unauthenticated arbitrary SQL query execution","description":"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.","severity":{"version":"3.1","score":9.8,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H","level":"critical","assessor":"cna","from":"cve"},"epss":{"day":"2026-11-11","score":0.00889,"percentile":0.59767,"model":"v2026.06.15"},"facts":{"in_kev":false,"known_exploited":false,"public_exploit":false,"fix_available":true},"cwes":["CWE-89"],"published":"2024-02-07T14:54:41Z","modified":"2026-10-28T02:30:21Z","fixes":[{"ecosystem":"PyPI","package":"products-sqlalchemyda","fixed_in":["2.2"],"sources":["ghsa","osv"]}],"affected":[{"source":"ghsa","ecosystem":"PyPI","package":"products-sqlalchemyda","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"2.2"}]}]},{"source":"osv","ecosystem":"PyPI","package":"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"]},{"source":"osv","ecosystem":"PyPI","package":"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"]}],"products":[{"vendor":"zope","product":"sqlalchemyda"},{"vendor":"zopefoundation","product":"products.sqlalchemyda"}],"references":[{"url":"https://github.com/zopefoundation/Products.SQLAlchemyDA/security/advisories/GHSA-r3jc-3qmm-w3pw","tags":["x_refsource_CONFIRM","x_transferred","Vendor Advisory","advisory","web"]},{"url":"https://github.com/zopefoundation/Products.SQLAlchemyDA/commit/e682b99f8406f20bc3f0f2c77153ed7345fd215a","tags":["x_refsource_MISC","x_transferred","Patch","fix","web"]},{"url":"https://nvd.nist.gov/vuln/detail/CVE-2024-24811","tags":["advisory"]},{"url":"https://github.com/advisories/GHSA-r3jc-3qmm-w3pw","tags":["advisory"]},{"url":"https://github.com/CVEProject/cvelistV5/tree/main/cves/2024/24xxx/CVE-2024-24811.json","tags":["advisory"]},{"url":"https://github.com/zopefoundation/Products.SQLAlchemyDA","tags":["package"]},{"url":"https://pypi.org/project/products-sqlalchemyda","tags":["package"]}],"sources":{"cve":[{"id":"CVE-2024-24811","title":"Products.SQLAlchemyDA  vulnerable to unauthenticated arbitrary SQL query execution","description":"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.","status":"published","published":"2024-02-07T14:54:41.601Z","modified":"2025-05-15T19:42:45.806Z","cvss":[{"version":"3.1","score":9.8,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H","level":"critical","assessor":"cna"}],"cwes":["CWE-89"],"updated_at":"2026-11-02T14:34:13.64024Z"}],"euvd":[{"id":"EUVD-2024-0707","description":"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.","status":"published","published":"2024-02-07T14:54:41Z","modified":"2025-05-15T19:42:45Z","cvss":[{"version":"3.1","score":9.8,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H","level":"critical"}],"updated_at":"2026-11-02T20:32:46.094311Z"}],"ghsa":[{"id":"GHSA-r3jc-3qmm-w3pw","title":"SQLAlchemyDA unauthenticated arbitrary SQL query execution","description":"### 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","status":"published","published":"2024-02-07T17:28:26Z","modified":"2024-02-14T21:35:24Z","cvss":[{"version":"3.1","score":9.8,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H","level":"critical"}],"cwes":["CWE-89"],"updated_at":"2026-11-02T14:37:38.20753Z"}],"nvd":[{"id":"CVE-2024-24811","description":"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.","status":"published","published":"2024-02-07T15:15:08.507Z","modified":"2026-06-17T07:14:56.073Z","cvss":[{"version":"3.1","score":9.8,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H","level":"critical","assessor":"secondary"},{"version":"3.1","score":9.8,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H","level":"critical","assessor":"primary"}],"cwes":["CWE-89"],"updated_at":"2026-11-02T14:09:35.738752Z"}],"osv":[{"id":"CVE-2024-24811","title":"Products.SQLAlchemyDA  vulnerable to unauthenticated arbitrary SQL query execution","description":"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.","status":"published","published":"2024-02-07T14:54:41.601Z","modified":"2026-10-28T02:30:21.512024173Z","cvss":[{"version":"3.1","score":9.8,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H","level":"critical"}],"cwes":["CWE-89"],"updated_at":"2026-11-02T15:44:38.897406Z"},{"id":"GHSA-r3jc-3qmm-w3pw","title":"SQLAlchemyDA unauthenticated arbitrary SQL query execution","description":"### 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","status":"published","published":"2024-02-07T17:28:26Z","modified":"2026-09-10T03:50:06.413628614Z","cvss":[{"version":"3.1","score":9.8,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H","level":"critical"}],"cwes":["CWE-89"],"updated_at":"2026-11-02T15:46:55.122811Z"},{"id":"PYSEC-2026-489","title":"SQLAlchemyDA unauthenticated arbitrary SQL query execution","description":"### 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","status":"published","published":"2026-06-29T11:50:40.542423Z","modified":"2026-07-01T20:23:02.176443Z","cvss":[{"version":"3.1","score":9.8,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H","level":"critical"}],"updated_at":"2026-11-02T15:52:57.671918Z"}]}}