{"id":"UBUNTU-CVE-2023-22794","details":"A vulnerability in ActiveRecord \u003c6.0.6.1, v6.1.7.1 and v7.0.4.1 related to the sanitization of comments. If malicious user input is passed to either the `annotate` query method, the `optimizer_hints` query method, or through the QueryLogs interface which automatically adds annotations, it may be sent to the database withinsufficient sanitization and be able to inject SQL outside of the comment.","modified":"2026-05-20T16:07:27.362435025Z","published":"2023-02-09T20:15:00Z","upstream":["CVE-2023-22794"],"references":[{"type":"REPORT","url":"https://ubuntu.com/security/CVE-2023-22794"},{"type":"REPORT","url":"https://discuss.rubyonrails.org/t/cve-2023-22794-sql-injection-vulnerability-via-activerecord-comments/82117"},{"type":"REPORT","url":"https://github.com/rails/rails/commit/048e9fc05e18c91838a44e60175e475de8b2aad5"},{"type":"REPORT","url":"https://www.cve.org/CVERecord?id=CVE-2023-22794"}],"affected":[{"package":{"name":"rails","ecosystem":"Ubuntu:Pro:16.04:LTS","purl":"pkg:deb/ubuntu/rails?arch=source&distro=esm-apps%2Fxenial"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["2:4.1.10-1","2:4.2.5-1","2:4.2.5.1-1","2:4.2.5.2-2","2:4.2.6-1","2:4.2.6-1ubuntu0.1~esm1","2:4.2.6-1ubuntu0.1~esm2"],"ecosystem_specific":{"binaries":[{"binary_name":"rails","binary_version":"2:4.2.6-1ubuntu0.1~esm2"},{"binary_name":"ruby-actionmailer","binary_version":"2:4.2.6-1ubuntu0.1~esm2"},{"binary_version":"2:4.2.6-1ubuntu0.1~esm2","binary_name":"ruby-actionpack"},{"binary_version":"2:4.2.6-1ubuntu0.1~esm2","binary_name":"ruby-actionview"},{"binary_version":"2:4.2.6-1ubuntu0.1~esm2","binary_name":"ruby-activejob"},{"binary_name":"ruby-activemodel","binary_version":"2:4.2.6-1ubuntu0.1~esm2"},{"binary_version":"2:4.2.6-1ubuntu0.1~esm2","binary_name":"ruby-activerecord"},{"binary_version":"2:4.2.6-1ubuntu0.1~esm2","binary_name":"ruby-activesupport"},{"binary_name":"ruby-rails","binary_version":"2:4.2.6-1ubuntu0.1~esm2"},{"binary_version":"2:4.2.6-1ubuntu0.1~esm2","binary_name":"ruby-railties"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2023/UBUNTU-CVE-2023-22794.json"}},{"package":{"name":"rails","ecosystem":"Ubuntu:Pro:18.04:LTS","purl":"pkg:deb/ubuntu/rails?arch=source&distro=esm-apps%2Fbionic"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["2:4.2.9-2","2:4.2.9-4","2:4.2.10-0ubuntu4","2:4.2.10-0ubuntu4+esm1","2:4.2.10-0ubuntu4+esm2"],"ecosystem_specific":{"binaries":[{"binary_name":"rails","binary_version":"2:4.2.10-0ubuntu4+esm2"},{"binary_version":"2:4.2.10-0ubuntu4+esm2","binary_name":"ruby-actionmailer"},{"binary_name":"ruby-actionpack","binary_version":"2:4.2.10-0ubuntu4+esm2"},{"binary_name":"ruby-actionview","binary_version":"2:4.2.10-0ubuntu4+esm2"},{"binary_version":"2:4.2.10-0ubuntu4+esm2","binary_name":"ruby-activejob"},{"binary_version":"2:4.2.10-0ubuntu4+esm2","binary_name":"ruby-activemodel"},{"binary_version":"2:4.2.10-0ubuntu4+esm2","binary_name":"ruby-activerecord"},{"binary_name":"ruby-activesupport","binary_version":"2:4.2.10-0ubuntu4+esm2"},{"binary_version":"2:4.2.10-0ubuntu4+esm2","binary_name":"ruby-rails"},{"binary_name":"ruby-railties","binary_version":"2:4.2.10-0ubuntu4+esm2"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2023/UBUNTU-CVE-2023-22794.json"}},{"package":{"name":"rails","ecosystem":"Ubuntu:Pro:20.04:LTS","purl":"pkg:deb/ubuntu/rails?arch=source&distro=esm-apps%2Ffocal"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["2:5.2.2.1+dfsg-1ubuntu1","2:5.2.3+dfsg-3","2:5.2.3+dfsg-3ubuntu0.1~esm1"],"ecosystem_specific":{"binaries":[{"binary_name":"rails","binary_version":"2:5.2.3+dfsg-3ubuntu0.1~esm1"},{"binary_name":"ruby-actioncable","binary_version":"2:5.2.3+dfsg-3ubuntu0.1~esm1"},{"binary_version":"2:5.2.3+dfsg-3ubuntu0.1~esm1","binary_name":"ruby-actionmailer"},{"binary_version":"2:5.2.3+dfsg-3ubuntu0.1~esm1","binary_name":"ruby-actionpack"},{"binary_name":"ruby-actionview","binary_version":"2:5.2.3+dfsg-3ubuntu0.1~esm1"},{"binary_name":"ruby-activejob","binary_version":"2:5.2.3+dfsg-3ubuntu0.1~esm1"},{"binary_version":"2:5.2.3+dfsg-3ubuntu0.1~esm1","binary_name":"ruby-activemodel"},{"binary_name":"ruby-activerecord","binary_version":"2:5.2.3+dfsg-3ubuntu0.1~esm1"},{"binary_version":"2:5.2.3+dfsg-3ubuntu0.1~esm1","binary_name":"ruby-activestorage"},{"binary_name":"ruby-activesupport","binary_version":"2:5.2.3+dfsg-3ubuntu0.1~esm1"},{"binary_version":"2:5.2.3+dfsg-3ubuntu0.1~esm1","binary_name":"ruby-rails"},{"binary_version":"2:5.2.3+dfsg-3ubuntu0.1~esm1","binary_name":"ruby-railties"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2023/UBUNTU-CVE-2023-22794.json"}},{"package":{"name":"rails","ecosystem":"Ubuntu:Pro:22.04:LTS","purl":"pkg:deb/ubuntu/rails?arch=source&distro=esm-apps%2Fjammy"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["2:6.0.3.7+dfsg-2","2:6.1.4.1+dfsg-8ubuntu2","2:6.1.4.1+dfsg-8ubuntu2+esm1"],"ecosystem_specific":{"binaries":[{"binary_name":"rails","binary_version":"2:6.1.4.1+dfsg-8ubuntu2+esm1"},{"binary_version":"2:6.1.4.1+dfsg-8ubuntu2+esm1","binary_name":"ruby-actioncable"},{"binary_name":"ruby-actionmailbox","binary_version":"2:6.1.4.1+dfsg-8ubuntu2+esm1"},{"binary_name":"ruby-actionmailer","binary_version":"2:6.1.4.1+dfsg-8ubuntu2+esm1"},{"binary_name":"ruby-actionpack","binary_version":"2:6.1.4.1+dfsg-8ubuntu2+esm1"},{"binary_name":"ruby-actiontext","binary_version":"2:6.1.4.1+dfsg-8ubuntu2+esm1"},{"binary_name":"ruby-actionview","binary_version":"2:6.1.4.1+dfsg-8ubuntu2+esm1"},{"binary_name":"ruby-activejob","binary_version":"2:6.1.4.1+dfsg-8ubuntu2+esm1"},{"binary_name":"ruby-activemodel","binary_version":"2:6.1.4.1+dfsg-8ubuntu2+esm1"},{"binary_name":"ruby-activerecord","binary_version":"2:6.1.4.1+dfsg-8ubuntu2+esm1"},{"binary_version":"2:6.1.4.1+dfsg-8ubuntu2+esm1","binary_name":"ruby-activestorage"},{"binary_name":"ruby-activesupport","binary_version":"2:6.1.4.1+dfsg-8ubuntu2+esm1"},{"binary_name":"ruby-rails","binary_version":"2:6.1.4.1+dfsg-8ubuntu2+esm1"},{"binary_name":"ruby-railties","binary_version":"2:6.1.4.1+dfsg-8ubuntu2+esm1"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2023/UBUNTU-CVE-2023-22794.json"}},{"package":{"name":"rails","ecosystem":"Ubuntu:24.04:LTS","purl":"pkg:deb/ubuntu/rails?arch=source&distro=noble"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["2:6.1.7.3+dfsg-2build1","2:6.1.7.3+dfsg-3"],"ecosystem_specific":{"binaries":[{"binary_name":"rails","binary_version":"2:6.1.7.3+dfsg-3"},{"binary_name":"ruby-actioncable","binary_version":"2:6.1.7.3+dfsg-3"},{"binary_name":"ruby-actionmailbox","binary_version":"2:6.1.7.3+dfsg-3"},{"binary_version":"2:6.1.7.3+dfsg-3","binary_name":"ruby-actionmailer"},{"binary_name":"ruby-actionpack","binary_version":"2:6.1.7.3+dfsg-3"},{"binary_name":"ruby-actiontext","binary_version":"2:6.1.7.3+dfsg-3"},{"binary_version":"2:6.1.7.3+dfsg-3","binary_name":"ruby-actionview"},{"binary_name":"ruby-activejob","binary_version":"2:6.1.7.3+dfsg-3"},{"binary_name":"ruby-activemodel","binary_version":"2:6.1.7.3+dfsg-3"},{"binary_name":"ruby-activerecord","binary_version":"2:6.1.7.3+dfsg-3"},{"binary_name":"ruby-activestorage","binary_version":"2:6.1.7.3+dfsg-3"},{"binary_version":"2:6.1.7.3+dfsg-3","binary_name":"ruby-activesupport"},{"binary_name":"ruby-rails","binary_version":"2:6.1.7.3+dfsg-3"},{"binary_name":"ruby-railties","binary_version":"2:6.1.7.3+dfsg-3"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2023/UBUNTU-CVE-2023-22794.json"}},{"package":{"name":"rails","ecosystem":"Ubuntu:25.10","purl":"pkg:deb/ubuntu/rails?arch=source&distro=questing"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["2:6.1.7.3+dfsg-7","2:7.2.2.1+dfsg-7"],"ecosystem_specific":{"binaries":[{"binary_name":"rails","binary_version":"2:7.2.2.1+dfsg-7"},{"binary_name":"ruby-actioncable","binary_version":"2:7.2.2.1+dfsg-7"},{"binary_version":"2:7.2.2.1+dfsg-7","binary_name":"ruby-actionmailbox"},{"binary_name":"ruby-actionmailer","binary_version":"2:7.2.2.1+dfsg-7"},{"binary_name":"ruby-actionpack","binary_version":"2:7.2.2.1+dfsg-7"},{"binary_name":"ruby-actiontext","binary_version":"2:7.2.2.1+dfsg-7"},{"binary_version":"2:7.2.2.1+dfsg-7","binary_name":"ruby-actionview"},{"binary_name":"ruby-activejob","binary_version":"2:7.2.2.1+dfsg-7"},{"binary_name":"ruby-activemodel","binary_version":"2:7.2.2.1+dfsg-7"},{"binary_version":"2:7.2.2.1+dfsg-7","binary_name":"ruby-activerecord"},{"binary_version":"2:7.2.2.1+dfsg-7","binary_name":"ruby-activestorage"},{"binary_name":"ruby-activesupport","binary_version":"2:7.2.2.1+dfsg-7"},{"binary_version":"2:7.2.2.1+dfsg-7","binary_name":"ruby-rails"},{"binary_name":"ruby-railties","binary_version":"2:7.2.2.1+dfsg-7"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2023/UBUNTU-CVE-2023-22794.json"}},{"package":{"name":"rails","ecosystem":"Ubuntu:26.04:LTS","purl":"pkg:deb/ubuntu/rails?arch=source&distro=resolute"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["2:7.2.2.1+dfsg-7","2:7.2.2.2+dfsg-2","2:7.2.3+dfsg-2"],"ecosystem_specific":{"binaries":[{"binary_version":"2:7.2.3+dfsg-2","binary_name":"rails"},{"binary_name":"ruby-actioncable","binary_version":"2:7.2.3+dfsg-2"},{"binary_name":"ruby-actionmailbox","binary_version":"2:7.2.3+dfsg-2"},{"binary_name":"ruby-actionmailer","binary_version":"2:7.2.3+dfsg-2"},{"binary_name":"ruby-actionpack","binary_version":"2:7.2.3+dfsg-2"},{"binary_name":"ruby-actiontext","binary_version":"2:7.2.3+dfsg-2"},{"binary_version":"2:7.2.3+dfsg-2","binary_name":"ruby-actionview"},{"binary_name":"ruby-activejob","binary_version":"2:7.2.3+dfsg-2"},{"binary_version":"2:7.2.3+dfsg-2","binary_name":"ruby-activemodel"},{"binary_version":"2:7.2.3+dfsg-2","binary_name":"ruby-activerecord"},{"binary_name":"ruby-activestorage","binary_version":"2:7.2.3+dfsg-2"},{"binary_version":"2:7.2.3+dfsg-2","binary_name":"ruby-activesupport"},{"binary_name":"ruby-rails","binary_version":"2:7.2.3+dfsg-2"},{"binary_name":"ruby-railties","binary_version":"2:7.2.3+dfsg-2"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2023/UBUNTU-CVE-2023-22794.json"}}],"schema_version":"1.7.5","severity":[{"type":"CVSS_V3","score":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H"},{"type":"Ubuntu","score":"medium"}]}