{"id":"CVE-2019-7548","details":"SQLAlchemy 1.2.17 has SQL Injection when the group_by parameter can be controlled.","aliases":["GHSA-38fc-9xqv-7f7q","PYSEC-2019-124"],"modified":"2026-07-08T05:53:54.634011421Z","published":"2019-02-06T21:29:01.063Z","related":["ALSA-2019:0981","ALSA-2019:0984","SUSE-SU-2019:2211-1","SUSE-SU-2019:2253-1","SUSE-SU-2019:2253-2","SUSE-SU-2019:2261-1","SUSE-SU-2019:2267-1","SUSE-SU-2019:2350-1","SUSE-SU-2019:2374-1","openSUSE-SU-2019:2039-1","openSUSE-SU-2019:2064-1","openSUSE-SU-2019:2078-1"],"database_specific":{"unresolved_ranges":[{"vendor_product":"debian:debian_linux","cpes":["cpe:2.3:o:debian:debian_linux:8.0:*:*:*:*:*:*:*","cpe:2.3:o:debian:debian_linux:9.0:*:*:*:*:*:*:*"],"extracted_events":[{"introduced":"8.0"},{"last_affected":"8.0"},{"introduced":"9.0"},{"last_affected":"9.0"}],"source":"CPE_STRING"},{"source":"CPE_STRING","vendor_product":"opensuse:backports_sle","cpes":["cpe:2.3:a:opensuse:backports_sle:15.0:-:*:*:*:*:*:*"],"extracted_events":[{"introduced":"15.0-NA"},{"last_affected":"15.0-NA"}]},{"source":"CPE_STRING","vendor_product":"opensuse:leap","cpes":["cpe:2.3:o:opensuse:leap:15.0:*:*:*:*:*:*:*","cpe:2.3:o:opensuse:leap:15.1:*:*:*:*:*:*:*"],"extracted_events":[{"introduced":"15.0"},{"last_affected":"15.0"},{"introduced":"15.1"},{"last_affected":"15.1"}]},{"extracted_events":[{"introduced":"4.2"},{"last_affected":"4.2"},{"introduced":"4.3"},{"last_affected":"4.3"}],"source":"CPE_STRING","vendor_product":"oracle:communications_operations_monitor","cpes":["cpe:2.3:a:oracle:communications_operations_monitor:4.2:*:*:*:*:*:*:*","cpe:2.3:a:oracle:communications_operations_monitor:4.3:*:*:*:*:*:*:*"]},{"cpes":["cpe:2.3:o:redhat:enterprise_linux:8.0:*:*:*:-:*:*:*"],"extracted_events":[{"introduced":"8.0"},{"last_affected":"8.0"}],"source":"CPE_STRING","vendor_product":"redhat:enterprise_linux"},{"cpes":["cpe:2.3:o:redhat:enterprise_linux_eus:8.1:*:*:*:*:*:*:*","cpe:2.3:o:redhat:enterprise_linux_eus:8.2:*:*:*:*:*:*:*","cpe:2.3:o:redhat:enterprise_linux_eus:8.4:*:*:*:*:*:*:*"],"extracted_events":[{"introduced":"8.1"},{"last_affected":"8.1"},{"introduced":"8.2"},{"last_affected":"8.2"},{"introduced":"8.4"},{"last_affected":"8.4"}],"source":"CPE_STRING","vendor_product":"redhat:enterprise_linux_eus"},{"source":"CPE_STRING","vendor_product":"redhat:enterprise_linux_server_aus","cpes":["cpe:2.3:o:redhat:enterprise_linux_server_aus:8.2:*:*:*:*:*:*:*","cpe:2.3:o:redhat:enterprise_linux_server_aus:8.4:*:*:*:*:*:*:*"],"extracted_events":[{"introduced":"8.2"},{"last_affected":"8.2"},{"introduced":"8.4"},{"last_affected":"8.4"}]},{"source":"CPE_STRING","vendor_product":"redhat:enterprise_linux_server_tus","cpes":["cpe:2.3:o:redhat:enterprise_linux_server_tus:8.2:*:*:*:*:*:*:*","cpe:2.3:o:redhat:enterprise_linux_server_tus:8.4:*:*:*:*:*:*:*"],"extracted_events":[{"introduced":"8.2"},{"last_affected":"8.2"},{"introduced":"8.4"},{"last_affected":"8.4"}]}]},"references":[{"type":"ADVISORY","url":"http://lists.opensuse.org/opensuse-security-announce/2019-08/msg00087.html"},{"type":"ADVISORY","url":"http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00010.html"},{"type":"ADVISORY","url":"http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00016.html"},{"type":"ADVISORY","url":"https://access.redhat.com/errata/RHSA-2019:0981"},{"type":"ADVISORY","url":"https://access.redhat.com/errata/RHSA-2019:0984"},{"type":"ADVISORY","url":"https://lists.debian.org/debian-lts-announce/2019/03/msg00020.html"},{"type":"ADVISORY","url":"https://lists.debian.org/debian-lts-announce/2021/11/msg00005.html"},{"type":"FIX","url":"https://github.com/sqlalchemy/sqlalchemy/issues/4481#issuecomment-461204518"},{"type":"FIX","url":"https://www.oracle.com/security-alerts/cpujan2021.html"},{"type":"EVIDENCE","url":"https://github.com/no-security/sqlalchemy_test"}],"affected":[{"ranges":[{"type":"GIT","repo":"https://github.com/sqlalchemy/sqlalchemy","events":[{"introduced":"47c245b90cd3cfe76bc0cf078f740d12bf7ba2d1"},{"last_affected":"47c245b90cd3cfe76bc0cf078f740d12bf7ba2d1"}],"database_specific":{"extracted_events":[{"introduced":"1.2.17"},{"last_affected":"1.2.17"}],"source":"CPE_STRING","cpe":"cpe:2.3:a:sqlalchemy:sqlalchemy:1.2.17:*:*:*:*:*:*:*"}}],"versions":["1.2.17","rel_1_2_17"],"database_specific":{"source":"https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2019-7548.json"}}],"schema_version":"1.7.5","severity":[{"type":"CVSS_V3","score":"CVSS:3.1/AV:L/AC:L/PR:N/UI:R/S:U/C:H/I:H/A:H"}]}