{"id":"GHSA-p8wx-5f39-w3x4","summary":"NocoDB: SQL Injection via Column Title in Bulk GroupBy","details":"### Summary\nAn authenticated user with column-create permission can inject SQL into the bulk groupBy\nendpoint by setting a column's title to a SQL fragment.\n\n### Details\nThe bulk groupBy path in `group-by.ts` builds three database-specific `knex.raw()`\naggregations that interpolate the request's `column_name` directly into the SQL string.\nColumn lookup in `data-table.service.ts` matches on both the sanitized `column_name`\nfield and the free-text `title`, so a title containing a SQL fragment bypasses the\npublic endpoint's existing column allowlist and reaches the query builder unescaped.\n\n### Impact\nSQL injection against the connected database with read access to any expression an\nattacker can place in a column title. Exploitation requires an authenticated session\nwith permission to create or rename columns.\n\n### Credit\nThis issue was reported by [@geo-chen](https://github.com/geo-chen).","aliases":["CVE-2026-47384"],"modified":"2026-07-20T21:30:41.089051488Z","published":"2026-06-05T16:19:59Z","database_specific":{"severity":"MODERATE","github_reviewed":true,"github_reviewed_at":"2026-06-05T16:19:59Z","nvd_published_at":"2026-06-23T21:17:00Z","cwe_ids":["CWE-89"]},"references":[{"type":"WEB","url":"https://github.com/nocodb/nocodb/security/advisories/GHSA-p8wx-5f39-w3x4"},{"type":"ADVISORY","url":"https://nvd.nist.gov/vuln/detail/CVE-2026-47384"},{"type":"PACKAGE","url":"https://github.com/nocodb/nocodb"},{"type":"WEB","url":"https://github.com/nocodb/nocodb/releases/tag/2026.05.1"}],"affected":[{"package":{"name":"nocodb","ecosystem":"npm","purl":"pkg:npm/nocodb"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"2026.05.1"}]}],"database_specific":{"last_known_affected_version_range":"\u003c= 2026.05.0","source":"https://github.com/github/advisory-database/blob/main/advisories/github-reviewed/2026/06/GHSA-p8wx-5f39-w3x4/GHSA-p8wx-5f39-w3x4.json"}}],"schema_version":"1.9.0","severity":[{"type":"CVSS_V4","score":"CVSS:4.0/AV:N/AC:L/AT:N/PR:L/UI:N/VC:L/VI:L/VA:N/SC:N/SI:N/SA:N"}]}