CVE-2023-43794 SQL Injection in nocodb
An authenticated attacker with creator access can execute arbitrary SQL queries to read database data via blind injection.
- Exploited in the wild
- Not known
- Login needed
- An administrator
- Attackable
- Over the internet
- Victim action needed
- Not needed
- Fix
- Available
What is CVE-2023-43794?
CVE-2023-43794 is a medium-severity SQL injection vulnerability in nocodb, published on 17 Oct 2023. An attacker needs administrator access to exploit it, with no action from the victim.
Official description
Nocodb is an open source Airtable alternative. Affected versions of nocodb contain a SQL injection vulnerability, that allows an authenticated attacker with creator access to query the underlying database. By supplying a specially crafted payload to the given an attacker can inject arbitrary SQL queries to be executed. Since this is a blind SQL injection, an attacker may need to use time-based payloads which would include a function to delay execution for a given number of seconds. The response time indicates, whether the result of the query execution was true or false. Depending on the result, the HTTP response will be returned after a given number of seconds, indicating TRUE, or immediately, indicating FALSE. In that way, an attacker can reveal the data present in the database. This vulnerability has been addressed in version 0.111.0. Users are advised to upgrade. There are no known workarounds for this vulnerability. This issue is also tracked as `GHSL-2023-141`.
Weakness: CWE-89
Which versions are affected by CVE-2023-43794?
2 open source packages ship an affected version, including nocodb. It affects 1 product.
| Package | Affected | Fixed in |
|---|---|---|
nocodb npm | All versions | 0.111.0 |
nocodb npm | All versions | 0.111.0 |
Products include Nocodb Nocodb.
How do I fix CVE-2023-43794?
Upgrade nocodb to 0.111.0 or later.
Use parameterised queries everywhere and never build SQL by joining strings. Upgrade affected software first; a web application firewall only buys time. More about SQL injection.
Is CVE-2023-43794 being exploited?
There is no known exploitation of CVE-2023-43794 in the wild and no public exploit code.
Other vulnerabilities in nocodb
- CVE-2022-2339 Server-Side Request Forgery (SSRF) in nocodb/nocodb
- CVE-2022-2062 Generation of Error Message Containing Sensitive Information in nocodb/nocodb
- CVE-2022-2064 Insufficient Session Expiration in nocodb/nocodb
- CVE-2022-2063 Improper Privilege Management in nocodb/nocodb
- CVE-2022-2022 Cross-site Scripting (XSS) - Stored in nocodb/nocodb
Sources
Also known as GHSA-3m5q-q39v-xf8f.