{"containers":{"cna":{"affected":[{"product":"activerecord-update-by-case","vendor":"camilova","versions":[{"status":"affected","version":"< 0.1.3"}]}],"descriptions":[{"lang":"en","value":"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."}],"metrics":[{"cvssV3_1":{"attackComplexity":"HIGH","attackVector":"NETWORK","availabilityImpact":"LOW","baseScore":5.8,"baseSeverity":"MEDIUM","confidentialityImpact":"LOW","integrityImpact":"LOW","privilegesRequired":"NONE","scope":"CHANGED","userInteraction":"REQUIRED","vectorString":"CVSS:3.1/AV:N/AC:H/PR:N/UI:R/S:C/C:L/I:L/A:L","version":"3.1"}}],"problemTypes":[{"descriptions":[{"cweId":"CWE-89","description":"CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')","lang":"en","type":"CWE"}]}],"providerMetadata":{"dateUpdated":"2022-08-12T20:50:08.000Z","orgId":"a0819718-46f1-4df5-94e2-005712e83aaa","shortName":"GitHub_M"},"references":[{"tags":["x_refsource_CONFIRM"],"url":"https://github.com/camilova/activerecord-update-by-case/security/advisories/GHSA-33wh-w4m7-c6r8"},{"tags":["x_refsource_MISC"],"url":"https://github.com/camilova/activerecord-update-by-case/releases/tag/v0.1.3-stable"}],"source":{"advisory":"GHSA-33wh-w4m7-c6r8","discovery":"UNKNOWN"},"title":"update_by_case before 0.1.3 vulnerable to sql injection","x_legacyV4Record":{"CVE_data_meta":{"ASSIGNER":"security-advisories@github.com","ID":"CVE-2022-35956","STATE":"PUBLIC","TITLE":"update_by_case before 0.1.3 vulnerable to sql injection"},"affects":{"vendor":{"vendor_data":[{"product":{"product_data":[{"product_name":"activerecord-update-by-case","version":{"version_data":[{"version_value":"< 0.1.3"}]}}]},"vendor_name":"camilova"}]}},"data_format":"MITRE","data_type":"CVE","data_version":"4.0","description":{"description_data":[{"lang":"eng","value":"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."}]},"impact":{"cvss":{"attackComplexity":"HIGH","attackVector":"NETWORK","availabilityImpact":"LOW","baseScore":5.8,"baseSeverity":"MEDIUM","confidentialityImpact":"LOW","integrityImpact":"LOW","privilegesRequired":"NONE","scope":"CHANGED","userInteraction":"REQUIRED","vectorString":"CVSS:3.1/AV:N/AC:H/PR:N/UI:R/S:C/C:L/I:L/A:L","version":"3.1"}},"problemtype":{"problemtype_data":[{"description":[{"lang":"eng","value":"CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')"}]}]},"references":{"reference_data":[{"name":"https://github.com/camilova/activerecord-update-by-case/security/advisories/GHSA-33wh-w4m7-c6r8","refsource":"CONFIRM","url":"https://github.com/camilova/activerecord-update-by-case/security/advisories/GHSA-33wh-w4m7-c6r8"},{"name":"https://github.com/camilova/activerecord-update-by-case/releases/tag/v0.1.3-stable","refsource":"MISC","url":"https://github.com/camilova/activerecord-update-by-case/releases/tag/v0.1.3-stable"}]},"source":{"advisory":"GHSA-33wh-w4m7-c6r8","discovery":"UNKNOWN"}}},"adp":[{"providerMetadata":{"orgId":"af854a3a-2127-422b-91ae-364da2661108","shortName":"CVE","dateUpdated":"2024-08-03T09:51:59.642Z"},"title":"CVE Program Container","references":[{"tags":["x_refsource_CONFIRM","x_transferred"],"url":"https://github.com/camilova/activerecord-update-by-case/security/advisories/GHSA-33wh-w4m7-c6r8"},{"tags":["x_refsource_MISC","x_transferred"],"url":"https://github.com/camilova/activerecord-update-by-case/releases/tag/v0.1.3-stable"}]},{"metrics":[{"other":{"type":"ssvc","content":{"timestamp":"2025-04-23T14:02:15.260626Z","id":"CVE-2022-35956","options":[{"Exploitation":"none"},{"Automatable":"no"},{"Technical Impact":"partial"}],"role":"CISA Coordinator","version":"2.0.3"}}}],"title":"CISA ADP Vulnrichment","providerMetadata":{"orgId":"134c704f-9b21-4f2e-91b3-4a467353bcc0","shortName":"CISA-ADP","dateUpdated":"2025-04-23T17:50:56.051Z"}}]},"cveMetadata":{"assignerOrgId":"a0819718-46f1-4df5-94e2-005712e83aaa","assignerShortName":"GitHub_M","cveId":"CVE-2022-35956","datePublished":"2022-08-12T20:50:08.000Z","dateReserved":"2022-07-15T00:00:00.000Z","dateUpdated":"2025-04-23T17:50:56.051Z","state":"PUBLISHED"},"dataType":"CVE_RECORD","dataVersion":"5.1"}