camilova/activerecord-update-by-case · Security
update_by_case before 0.1.3 can be vulnerable to sql injection
- GHSA ID
- GHSA-33wh-w4m7-c6r8
- CVE ID
- CVE-2022-35956
- Severity
- medium
- Published
- Updated
- CVSS
- 5.8 · CVSS:3.1/AV:N/AC:H/PR:N/UI:R/S:C/C:L/I:L/A:L
- CVSS v3
- 5.8 · CVSS:3.1/AV:N/AC:H/PR:N/UI:R/S:C/C:L/I:L/A:L
Description
Before version 0.1.3 update_by_case gem used custom sql strings, and it was not sanitized, making it vulnerable to sql injection. Upgrade to version >= 0.1.3 that uses Arel instead to construct the resulting sql statement, with sanitized sql.
CWEs
- CWE-89 · Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')
References
- https://github.com/camilova/activerecord-update-by-case/security/advisories/GHSA-33wh-w4m7-c6r8 ↗
- https://nvd.nist.gov/vuln/detail/CVE-2022-35956 ↗
- https://github.com/camilova/activerecord-update-by-case/releases/tag/v0.1.3-stable ↗
- https://github.com/rubysec/ruby-advisory-db/blob/master/gems/update_by_case/CVE-2022-35956.yml ↗
- https://github.com/advisories/GHSA-33wh-w4m7-c6r8 ↗