{"containers":{"cna":{"affected":[{"product":"administrate","vendor":"thoughtbot","versions":[{"status":"affected","version":"< 0.13.0"}]}],"descriptions":[{"lang":"en","value":"In Administrate (rubygem) before version 0.13.0, when sorting by attributes on a dashboard, the direction parameter was not validated before being interpolated into the SQL query. This could present a SQL injection if the attacker were able to modify the `direction` parameter and bypass ActiveRecord SQL protections. Whilst this does have a high-impact, to exploit this you need access to the Administrate dashboards, which we would expect to be behind authentication. This is patched in wersion 0.13.0."}],"metrics":[{"cvssV3_1":{"attackComplexity":"HIGH","attackVector":"NETWORK","availabilityImpact":"NONE","baseScore":7.7,"baseSeverity":"HIGH","confidentialityImpact":"HIGH","integrityImpact":"HIGH","privilegesRequired":"LOW","scope":"CHANGED","userInteraction":"REQUIRED","vectorString":"CVSS:3.1/AV:N/AC:H/PR:L/UI:R/S:C/C:H/I:H/A:N","version":"3.1"}}],"problemTypes":[{"descriptions":[{"cweId":"CWE-943","description":"CWE-943: Improper Neutralization of Special Elements in Data Query Logic","lang":"en","type":"CWE"}]}],"providerMetadata":{"dateUpdated":"2020-03-13T21:05:15.000Z","orgId":"a0819718-46f1-4df5-94e2-005712e83aaa","shortName":"GitHub_M"},"references":[{"tags":["x_refsource_CONFIRM"],"url":"https://github.com/thoughtbot/administrate/security/advisories/GHSA-2p5p-m353-833w"},{"tags":["x_refsource_MISC"],"url":"https://github.com/thoughtbot/administrate/commit/3ab838b83c5f565fba50e0c6f66fe4517f98eed3"}],"source":{"advisory":"GHSA-2p5p-m353-833w","discovery":"UNKNOWN"},"title":"Sort order SQL injection in Administrate","x_legacyV4Record":{"CVE_data_meta":{"ASSIGNER":"security-advisories@github.com","ID":"CVE-2020-5257","STATE":"PUBLIC","TITLE":"Sort order SQL injection in Administrate"},"affects":{"vendor":{"vendor_data":[{"product":{"product_data":[{"product_name":"administrate","version":{"version_data":[{"version_value":"< 0.13.0"}]}}]},"vendor_name":"thoughtbot"}]}},"data_format":"MITRE","data_type":"CVE","data_version":"4.0","description":{"description_data":[{"lang":"eng","value":"In Administrate (rubygem) before version 0.13.0, when sorting by attributes on a dashboard, the direction parameter was not validated before being interpolated into the SQL query. This could present a SQL injection if the attacker were able to modify the `direction` parameter and bypass ActiveRecord SQL protections. Whilst this does have a high-impact, to exploit this you need access to the Administrate dashboards, which we would expect to be behind authentication. This is patched in wersion 0.13.0."}]},"impact":{"cvss":{"attackComplexity":"HIGH","attackVector":"NETWORK","availabilityImpact":"NONE","baseScore":7.7,"baseSeverity":"HIGH","confidentialityImpact":"HIGH","integrityImpact":"HIGH","privilegesRequired":"LOW","scope":"CHANGED","userInteraction":"REQUIRED","vectorString":"CVSS:3.1/AV:N/AC:H/PR:L/UI:R/S:C/C:H/I:H/A:N","version":"3.1"}},"problemtype":{"problemtype_data":[{"description":[{"lang":"eng","value":"CWE-943: Improper Neutralization of Special Elements in Data Query Logic"}]}]},"references":{"reference_data":[{"name":"https://github.com/thoughtbot/administrate/security/advisories/GHSA-2p5p-m353-833w","refsource":"CONFIRM","url":"https://github.com/thoughtbot/administrate/security/advisories/GHSA-2p5p-m353-833w"},{"name":"https://github.com/thoughtbot/administrate/commit/3ab838b83c5f565fba50e0c6f66fe4517f98eed3","refsource":"MISC","url":"https://github.com/thoughtbot/administrate/commit/3ab838b83c5f565fba50e0c6f66fe4517f98eed3"}]},"source":{"advisory":"GHSA-2p5p-m353-833w","discovery":"UNKNOWN"}}},"adp":[{"providerMetadata":{"orgId":"af854a3a-2127-422b-91ae-364da2661108","shortName":"CVE","dateUpdated":"2024-08-04T08:22:09.077Z"},"title":"CVE Program Container","references":[{"tags":["x_refsource_CONFIRM","x_transferred"],"url":"https://github.com/thoughtbot/administrate/security/advisories/GHSA-2p5p-m353-833w"},{"tags":["x_refsource_MISC","x_transferred"],"url":"https://github.com/thoughtbot/administrate/commit/3ab838b83c5f565fba50e0c6f66fe4517f98eed3"}]}]},"cveMetadata":{"assignerOrgId":"a0819718-46f1-4df5-94e2-005712e83aaa","assignerShortName":"GitHub_M","cveId":"CVE-2020-5257","datePublished":"2020-03-13T21:05:15.000Z","dateReserved":"2020-01-02T00:00:00.000Z","dateUpdated":"2024-08-04T08:22:09.077Z","state":"PUBLISHED"},"dataType":"CVE_RECORD","dataVersion":"5.1"}