Local record deletion via interpolated record IDs
Published Jun 3, 2020 · Updated Aug 4, 2024
SQL injection in WatermelonDB before 0.15.1 and 0.16.0 through 0.16.1 allows attackers to delete local iOS database records. The iOS DatabaseDriver.destroyDeletedRecords method interpolates each record ID into a DELETE IN clause instead of binding it as a parameter. Reachability requires an app that accepts invalid record IDs and uses Watermelon Sync or calls destroyDeletedRecords directly; crafted IDs can delete selected or all local records and interrupt app use.
Summary
What happened
SQL injection in WatermelonDB before 0.15.1 and 0.16.0 through 0.16.1 allows attackers to delete local iOS database records. The iOS DatabaseDriver.destroyDeletedRecords method interpolates each record ID into a DELETE IN clause instead of binding it as a parameter. Reachability requires an app that accepts invalid record IDs and uses Watermelon Sync or calls destroyDeletedRecords directly; crafted IDs can delete selected or all local records and interrupt app use.
The record
- CVE
- CVE-2020-4035
- Published
- Jun 3, 2020
- Updated
- Aug 4, 2024
- Vendor
- Nozbe
- Product
- WatermelonDB
- Classifications
- CWE-89, T1565.001
- Attack vector
- network
- Privileges
- authenticated
Timeline
How it unfolded
- Jun 3, 2020CVE publishedPublication date reported by the CVE source.
- Aug 4, 2024Record updatedLatest update available in the CVE record.
Exploitability
Present is not the same as exploitable
Compare your product and version with the public record. A matching version still requires validation against your environment.
Is a vulnerable build present?
Compare these published version ranges with your installed build and any vendor patches.
- Affected versionversion=< 0.15.1
- Affected versionversion=>= 0.16.0, < 0.16.2
What conditions does exploitation require?
What is affected?
Attacks
What attackers are doing with it
Daily unique IPs observed by Shadowserver honeypots for known exploited vulnerabilities (KEVs). Missing observations do not establish an absence of attacks.
Weakness, pattern, technique
Public exploit references
- Upstream destroyDeletedRecords SQL injection regression payloadproof of concept · demonstrated
Labels summarize the accepted research assessment. They do not indicate a test against your environment.
Technologies
Your stack
See the directory against your own environment.
Your stack
Check the software in your environment
Book a demo to see how Hinoki identifies affected software and validates exploitability in your environment.
Book a demo