Vulnerability · Published Mar 13, 2020 · Assigned by GitHub_M

CVE-2020-5257Sort order SQL injection in Administrate

High 7.7

In plain English

A high-severity security flaw in administrate from thoughtbot. There are no confirmed reports of exploitation so far. The chance it is exploited in the next 30 days is estimated at 0.9% (higher than 60% of all known vulnerabilities). Fixed versions are available - upgrade the affected package.

Severity (CVSS 3.1)7.7High
Exploit odds (30 days)0.9%top 40.2% of all CVEs
Exploited in the wildNo reportsnot in CISA KEV
Attack toolingNoneno public tooling known

Official description

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.

Affected packages & fixed versions

EcosystemPackageFixed inAdvisory
RubyGemsadministrate0.13.0GHSA-2p5p-m353-833w

Affected products (as reported)

VendorProductVersions
thoughtbot administrate < 0.13.0

Weakness: CWE-943 · Vector: CVSS:3.1/AV:N/AC:H/PR:L/UI:R/S:C/C:H/I:H/A:N

References