{"id":"CVE-2019-7164","details":"SQLAlchemy through 1.2.17 and 1.3.x through 1.3.0b2 allows SQL Injection via the order_by parameter.","aliases":["GHSA-887w-45rq-vxgf","PYSEC-2019-123"],"modified":"2026-03-20T11:00:19.726691Z","published":"2019-02-20T00:29:00.197Z","related":["ALSA-2019:0981","ALSA-2019:0984","MGASA-2019-0350","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","openSUSE-SU-2024:11211-1","openSUSE-SU-2024:12915-1"],"references":[{"type":"ADVISORY","url":"https://lists.debian.org/debian-lts-announce/2019/03/msg00020.html"},{"type":"ADVISORY","url":"http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00010.html"},{"type":"ADVISORY","url":"https://lists.debian.org/debian-lts-announce/2021/11/msg00005.html"},{"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/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":"FIX","url":"https://www.oracle.com/security-alerts/cpujan2021.html"},{"type":"EVIDENCE","url":"https://github.com/sqlalchemy/sqlalchemy/issues/4481"}],"affected":[{"ranges":[{"type":"GIT","repo":"https://github.com/sqlalchemy/sqlalchemy","events":[{"introduced":"0"},{"last_affected":"47c245b90cd3cfe76bc0cf078f740d12bf7ba2d1"}],"database_specific":{"versions":[{"introduced":"0"},{"last_affected":"1.2.17"}]}}],"versions":["origin","rel_0_1_0","rel_0_1_1","rel_0_1_2","rel_0_1_3","rel_0_1_4","rel_0_1_5","rel_0_1_6","rel_0_1_7","rel_0_2_0","rel_0_2_1","rel_0_2_2","rel_0_2_3","rel_0_2_4","rel_0_2_5","rel_0_2_6","rel_0_2_7","rel_0_2_8","rel_0_3_0","rel_0_3_1","rel_0_3_10","rel_0_3_2","rel_0_3_3","rel_0_3_4","rel_0_3_5","rel_0_3_6","rel_0_3_7","rel_0_3_8","rel_0_3_9","rel_0_4_0","rel_0_4_1","rel_0_4_2","rel_0_4_2a","rel_0_4_2b","rel_0_4_2p3","rel_0_4_3","rel_0_4_4","rel_0_4_5","rel_0_4beta1","rel_0_4beta2","rel_0_4beta3","rel_0_4beta4","rel_0_4beta6","rel_0_5_0","rel_0_5_1","rel_0_5_2","rel_0_5_3","rel_0_5_4","rel_0_5_4p1","rel_0_5_4p2","rel_0_5_5","rel_0_5beta1","rel_0_5beta2","rel_0_5beta3","rel_0_5rc1","rel_0_5rc2","rel_0_5rc3","rel_0_5rc4","rel_0_6_0","rel_0_6_1","rel_0_6_2","rel_0_6_3","rel_0_6_4","rel_0_6_5","rel_0_6beta1","rel_0_6beta2","rel_0_6beta3","rel_0_7_0","rel_0_7_1","rel_0_7_2","rel_0_7_3","rel_0_7_4","rel_0_7_5","rel_0_7_6","rel_0_7b1","rel_0_7b2","rel_0_7b3","rel_0_7b4","rel_0_8_0","rel_0_8_0b1","rel_0_8_0b2","rel_0_8_1","rel_0_9_0","rel_0_9_0b1","rel_0_9_1","rel_0_9_2","rel_0_9_3","rel_0_9_4","rel_1_0_0","rel_1_0_0_b3","rel_1_0_0b1","rel_1_0_0b2","rel_1_0_0b4","rel_1_0_0b5","rel_1_0_1","rel_1_0_2","rel_1_0_3","rel_1_0_4","rel_1_0_5","rel_1_0_6","rel_1_0_7","rel_1_0_8","rel_1_1_0","rel_1_1_0b2","rel_1_1_0b3","rel_1_1_1","rel_1_1_2","rel_1_1_3","rel_1_1_4","rel_1_1_5","rel_1_1_6","rel_1_2_0","rel_1_2_0b1","rel_1_2_0b2","rel_1_2_1","rel_1_2_10","rel_1_2_11","rel_1_2_12","rel_1_2_13","rel_1_2_14","rel_1_2_15","rel_1_2_16","rel_1_2_17","rel_1_2_2","rel_1_2_3","rel_1_2_4","rel_1_2_5","rel_1_2_6","rel_1_2_7","rel_1_2_8","rel_1_2_9"],"database_specific":{"unresolved_ranges":[{"events":[{"introduced":"0"},{"last_affected":"1.3.0-beta1"}]},{"events":[{"introduced":"0"},{"last_affected":"1.3.0-beta2"}]},{"events":[{"introduced":"0"},{"last_affected":"8.0"}]},{"events":[{"introduced":"0"},{"last_affected":"9.0"}]},{"events":[{"introduced":"0"},{"last_affected":"15.0-NA"}]},{"events":[{"introduced":"0"},{"last_affected":"15.0"}]},{"events":[{"introduced":"0"},{"last_affected":"15.1"}]},{"events":[{"introduced":"0"},{"last_affected":"8.0"}]},{"events":[{"introduced":"0"},{"last_affected":"8.1"}]},{"events":[{"introduced":"0"},{"last_affected":"8.2"}]},{"events":[{"introduced":"0"},{"last_affected":"8.4"}]},{"events":[{"introduced":"0"},{"last_affected":"8.2"}]},{"events":[{"introduced":"0"},{"last_affected":"8.4"}]},{"events":[{"introduced":"0"},{"last_affected":"8.2"}]},{"events":[{"introduced":"0"},{"last_affected":"8.4"}]},{"events":[{"introduced":"0"},{"last_affected":"4.2"}]},{"events":[{"introduced":"0"},{"last_affected":"4.3"}]}],"source":"https://storage.googleapis.com/osv-test-cve-osv-conversion/osv-output/CVE-2019-7164.json"}}],"schema_version":"1.7.5","severity":[{"type":"CVSS_V3","score":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H"}]}