NocoBase: Sensitive Data Exposure via SQL Blacklist Bypass
nocobase
Affected versions
| Product | Affected | Fixed in |
|---|---|---|
| @nocobase/plugin-collection-sql npm |
|
|
nocobase
| Product | Affected | Fixed in |
|---|---|---|
| @nocobase/plugin-collection-sql npm |
|
|
NocoBase is an AI-powered no-code/low-code platform for building business applications and enterprise solutions. In 2.0.59 and earlier, NocoBase @nocobase/plugin-collection-sql used the checkSQL() function in packages/plugins/@nocobase/plugin-collection-sql/src/server/utils.ts with an incomplete keyword blacklist that did not restrict PostgreSQL system catalog tables such as pg_shadow, pg_roles, and pg_stat_activity, allowing an admin-role user to read password hashes and database metadata through the SQL Collection feature. This vulnerability is fixed in 2.1.0-alpha.46.
From the CVE record · GitHub_M
The SQL Collection plugin’s checkSQL() function does not block access to PostgreSQL system catalog tables. An authenticated admin-role user can use the SQL Collection feature to read password hashes and database metadata.
Teams running the npm package @nocobase/plugin-collection-sql should check versions below 2.0.62, 2.1.0-alpha.1 through before 2.1.0-alpha.46, and 2.1.0-beta.1 through before 2.1.0-beta.45.