GHSA-h8cj-hpmg-636v json
appsmith has SQL Injection in FilterDataService via Unsafe DROP TABLE Execution
published 6mo ago modified 6mo ago
- cvss
- 7.2
- version 3.1, GitHub
- cisa kev
- Not listed
- not in CISA's catalog
- epss
- —
- no score, EPSS covers CVEs only
- public exploits
- 0
- none known
Summary
### Summary A SQL injection vulnerability exists in `FilterDataServiceCE.java` where the `dropTable` method constructs a SQL `DROP TABLE` statement using string concatenation with the table name. If the table name is derived from user input, this allows for arbitrary SQL command execution.
### Details The vulnerability is located in `app/server/appsmith-interfaces/src/main/java/com/appsmith/external/services/ce/FilterDataServiceCE.java`.
Line 627 in `dropTable` method: ```java public void dropTable(String tableName) { String dropTableQuery = "DROP TABLE " + tableName + ";"; executeDbQuery(dropTableQuery); } ```
The `tableName` argument is concatenated directly into the SQL string without validation or escaping.
### PoC If `dropTable` is exposed to user input (e.g., via a utility API that accepts a table name to clean up), an attacker could provide a value like: `valid_table; DROP TABLE users; --`
The resulting query would be: `DROP TABLE valid_table; DROP TABLE users; --;`
This would delete the intended table and then delete the `users` table (or execute any other injected SQL).
### Impact * **Type:** SQL Injection * **Impact:** Data Loss (Drop Table), potentially Data Exfiltration or Modification depending on database permissions. * **Who is impacted:** Appsmith server instances.
Patch / fix
Is GHSA-h8cj-hpmg-636v in your dependencies? Fencer shows which of your repositories are affected as soon as an advisory lands, and opens the fix as a pull request.
Check with FencerCVSS scores
| assigned by | version | score | vector |
|---|---|---|---|
| GitHub | 3.1 | 7.2 | CVSS:3.1/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:H |
Affected packages
| ecosystem | package | affected | fixed in |
|---|---|---|---|
| maven | com.appsmith:interfaces | <1.99 |
1.99 |
Classification
- Weakness
-
- CWE-89 Improper Neutralization of Special Elements used in an SQL Command
References
Sources
- GitHub Advisory GHSA-h8cj-hpmg-636v
Fencer Intel keeps one entry per vulnerability: the CVE id wins, then GHSA, and records that alias each other are merged, except that two CVEs always keep separate entries. The same data is available as JSON.