GHSA-33wh-w4m7-c6r8

    Dashboard / Vulnerabilities / GHSA-33wh-w4m7-c6r8

    GHSA-33wh-w4m7-c6r8

    Published: 11 Aug 2022Last Modified: 8 Nov 2023

    Summary: update_by_case before 0.1.3 can be vulnerable to sql injection

    Details: 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.

    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, 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

    Affected packages

    Package

    Name: update_by_case

    Purl: pkg:gem/update_by_case

    Affected ranges

    Type: ECOSYSTEM

    Events:

    Introduced- 0
    Fixed -0.1.3

    Affected versions

    Common Vulnerability Scoring System

    Attack Vector
    Network
    Adjacent
    Local
    Physical
    Privileges Required
    None
    Low
    High
    User Interaction
    None
    Required
    Scope
    Unchanged
    Changed
    Confidentiality
    None
    Low
    High
    Integrity
    None
    Low
    High
    Availability
    None
    Low
    High
    GHSA-33wh-w4m7-c6r8 | CVE-DB