CVE-2023-22794

A vulnerability in ActiveRecord <6.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.

CVSS v3 8.8 HIGH

8.8^/10

CVSS v3 : HIGH

Vector :

Exploitability : 2.8 / Impact : 5.9

Attack Vector NETWORK

Attack Complexity LOW

Privileges Required LOW

User Interaction NONE

Confidentiality Impact HIGH

Integrity Impact HIGH

Availability Impact HIGH

Scope UNCHANGED

References

Link	Resource
https://discuss.rubyonrails.org/t/cve-2023-22794-sql-injection-vulnerability-via-activerecord-comments/82117	Exploit Patch Vendor Advisory
https://security.netapp.com/advisory/ntap-20240202-0008/
https://www.debian.org/security/2023/dsa-5372
https://discuss.rubyonrails.org/t/cve-2023-22794-sql-injection-vulnerability-via-activerecord-comments/82117	Exploit Patch Vendor Advisory
https://security.netapp.com/advisory/ntap-20240202-0008/
https://www.debian.org/security/2023/dsa-5372

Configurations

Configuration 1 (hide)

OR	cpe:2.3:a:activerecord_project:activerecord::::::ruby::*
	cpe:2.3:a:activerecord_project:activerecord::::::ruby::*
	cpe:2.3:a:activerecord_project:activerecord::::::ruby::*

History

23 Oct 2026, 23:10

Type	Values Removed	Values Added
Summary		(es) Una vulnerabilidad en ActiveRecord anterior a 6.0.6.1, v6.1.7.1 y v7.0.4.1 relacionada con la sanitización de comentarios. Si una entrada de usuario maliciosa se pasa al método de consulta annotate, al método de consulta optimizer_hints, o a través de la interfaz QueryLogs que añade anotaciones automáticamente, puede ser enviada a la base de datos con sanitización insuficiente y ser capaz de inyectar SQL fuera del comentario.

Information

Published : 2023-02-09 20:15

Updated : 2026-10-23 23:10

NVD link : CVE-2023-22794

Mitre link : CVE-2023-22794

CVE.ORG link : CVE-2023-22794

JSON object : View

Products Affected

activerecord_project

activerecord

CWE

CWE-89

Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')

{"id": "CVE-2023-22794", "cveTags": [], "metrics": {"cvssMetricV31": [{"type": "Primary", "source": "nvd@nist.gov", "cvssData": {"scope": "UNCHANGED", "version": "3.1", "baseScore": 8.8, "attackVector": "NETWORK", "baseSeverity": "HIGH", "vectorString": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H", "integrityImpact": "HIGH", "userInteraction": "NONE", "attackComplexity": "LOW", "availabilityImpact": "HIGH", "privilegesRequired": "LOW", "confidentialityImpact": "HIGH"}, "impactScore": 5.9, "exploitabilityScore": 2.8}]}, "affected": [{"source": "support@hackerone.com", "affectedData": [{"vendor": "n/a", "product": "https://github.com/rails/rails", "versions": [{"status": "affected", "version": "6.0.6.1, 6.1.7.1, 7.0.4.1"}]}]}], "published": "2023-02-09T20:15:11.353", "references": [{"url": "https://discuss.rubyonrails.org/t/cve-2023-22794-sql-injection-vulnerability-via-activerecord-comments/82117", "tags": ["Exploit", "Patch", "Vendor Advisory"], "source": "support@hackerone.com"}, {"url": "https://security.netapp.com/advisory/ntap-20240202-0008/", "source": "support@hackerone.com"}, {"url": "https://www.debian.org/security/2023/dsa-5372", "source": "support@hackerone.com"}, {"url": "https://discuss.rubyonrails.org/t/cve-2023-22794-sql-injection-vulnerability-via-activerecord-comments/82117", "tags": ["Exploit", "Patch", "Vendor Advisory"], "source": "af854a3a-2127-422b-91ae-364da2661108"}, {"url": "https://security.netapp.com/advisory/ntap-20240202-0008/", "source": "af854a3a-2127-422b-91ae-364da2661108"}, {"url": "https://www.debian.org/security/2023/dsa-5372", "source": "af854a3a-2127-422b-91ae-364da2661108"}], "vulnStatus": "Modified", "weaknesses": [{"type": "Secondary", "source": "support@hackerone.com", "description": [{"lang": "en", "value": "CWE-89"}]}, {"type": "Primary", "source": "nvd@nist.gov", "description": [{"lang": "en", "value": "CWE-89"}]}], "descriptions": [{"lang": "en", "value": "A vulnerability in ActiveRecord <6.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."}, {"lang": "es", "value": "Una vulnerabilidad en ActiveRecord anterior a 6.0.6.1, v6.1.7.1 y v7.0.4.1 relacionada con la sanitizaci\u00f3n de comentarios. Si una entrada de usuario maliciosa se pasa al m\u00e9todo de consulta annotate, al m\u00e9todo de consulta optimizer_hints, o a trav\u00e9s de la interfaz QueryLogs que a\u00f1ade anotaciones autom\u00e1ticamente, puede ser enviada a la base de datos con sanitizaci\u00f3n insuficiente y ser capaz de inyectar SQL fuera del comentario."}], "lastModified": "2026-10-23T23:10:00.157", "configurations": [{"nodes": [{"negate": false, "cpeMatch": [{"criteria": "cpe:2.3:a:activerecord_project:activerecord:*:*:*:*:*:ruby:*:*", "vulnerable": true, "matchCriteriaId": "3B0AF7DB-45EB-4310-8409-90350D1AFF02", "versionEndExcluding": "6.0.6.1", "versionStartIncluding": "6.0.0"}, {"criteria": "cpe:2.3:a:activerecord_project:activerecord:*:*:*:*:*:ruby:*:*", "vulnerable": true, "matchCriteriaId": "0D94371F-6A6F-4D40-97A1-3B08C75E3AFB", "versionEndExcluding": "6.1.7.1", "versionStartIncluding": "6.1.0"}, {"criteria": "cpe:2.3:a:activerecord_project:activerecord:*:*:*:*:*:ruby:*:*", "vulnerable": true, "matchCriteriaId": "EDE689E3-57CB-4121-9EE3-1857079325E6", "versionEndExcluding": "7.0.4.1", "versionStartIncluding": "7.0.0"}], "operator": "OR"}]}], "sourceIdentifier": "support@hackerone.com"}