SB20231017160 - SQL injection in NocoDB

Description

This security bulletin contains information about 1 vulnerability.

1) SQL injection (CVE-ID: CVE-2023-43794)

CWE-ID: CWE-89 - Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')

CVSSv4: CVSS:4.0/AV:N/AC:L/AT:N/PR:H/UI:N/VC:H/VI:H/VA:N/SC:N/SI:N/SA:N/E:U/U:Clear

The vulnerability allows a remote user to disclose sensitive information.

The vulnerability exists due to sql injection in the triggerList method in SqliteClient.ts when handling a crafted table_name parameter through the tableCreate endpoint. A remote privileged user can send a specially crafted request to disclose sensitive information.

The issue is a blind SQL injection that may require time-based payloads to infer query results from response timing.

Remediation

Install update from vendor's website.

References

• https://github.com/nocodb/nocodb/security/advisories/GHSA-3m5q-q39v-xf8f
• https://github.com/advisories/GHSA-3m5q-q39v-xf8f