Advisory

GHSA-8fxg-mr34-jqr8

Also known as: CVE-2023-50718

Summary

NocoDB SQL Injection vulnerability

Details

Summary
---
An authenticated attacker with create access could conduct a SQL Injection attack on MySQL DB using unescaped table_name.

Details
---
SQL Injection vulnerability occurs in VitessClient.ts.

async columnList(args: any = {}) {
    const func = this.columnList.name;
    const result = new Result();
    log.api(`${func}:args:`, args);

    try {
      args.databaseName = this.connectionConfig.connection.database;

      const response = await this.sqlClient.raw(
        `select *, table_name as tn from information_schema.columns where table_name = '${args.tn}' ORDER by ordinal_position`,
      );

The variable ${args.tn} refers to the table name entered by the user.
A malicious attacker can escape the existing query by including a special character (') in the table name and insert and execute a new arbitrary SQL query.

Impact
---
This vulnerability may result in leakage of sensitive data in the database.

Severity

Medium Basis: The source's own band: MODERATE

Dates

Published
2024-05-13 16:46 UTC
Modified
2026-09-10 03:50 UTC

Affected packages and fixes

nocodb

npm · All systems

Affected

  • introduced 0, fixed 0.202.10 (semver)

Fixed versions

0.202.10

Fix

Fix commands are the export's own generic commands. Ojuju never runs them. Check them against your setup first.

Check your own computer: guard packages check

View this record on OSV.dev

Source

Source: GitHub Advisory Database (reviewed advisories) · CC BY 4.0

Sources & licences