Skip to content
Fencer Intel
high 7.2

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

  • maven com.appsmith:interfaces 1.99

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 Fencer

CVSS 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

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.