CVE-2022-35956
update_by_case before 0.1.3 can be vulnerable to sql injection
Kaynağa göre önem derecesi
Trivy'nin kendi etiketi CRITICAL. Kritik diyenler: NVD. Daha düşük diyenler: GHSA (orta), Ruby Advisory DB (orta).
Açıklama
This Rails gem adds two methods to the ActiveRecord::Base class that allow you to update many records on a single database hit, using a case sql statement for it. 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.
Etkilenen paketler ve düzeltilmiş sürümler
| Kaynak | Paket | Düzeltildiği sürüm |
|---|---|---|
| rubygems::GitHub Security Advisory RubyGems | update_by_case | 0.1.3 |
| rubygems::Ruby Advisory Database | update_by_case | >= 0.1.3 |
Referanslar
- https://github.com/camilova/activerecord-update-by-case
- https://github.com/camilova/activerecord-update-by-case/releases/tag/v0.1.3-stable
- https://github.com/camilova/activerecord-update-by-case/security/advisories/GHSA-33wh-w4m7-c6r8
- https://github.com/rubysec/ruby-advisory-db/blob/master/gems/update_by_case/CVE-2022-35956.yml
- https://nvd.nist.gov/vuln/detail/CVE-2022-35956