Description
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.
Affected products
| Vendor | Product | Affected | Fixed |
|---|---|---|---|
| nocobase | nocobase | < 2.1.0-alpha.46 | — |
Affected packages
| Ecosystem | Package | Affected | Fixed | Record |
|---|---|---|---|---|
| npm | @nocobase/plugin-collection-sql | < 2.0.62 | 2.0.62 | GHSA-v8vm-cqh8-q87q |
| npm | @nocobase/plugin-collection-sql | >= 2.1.0-alpha.1, < 2.1.0-alpha.46 | 2.1.0-alpha.46 | GHSA-v8vm-cqh8-q87q |
| npm | @nocobase/plugin-collection-sql | >= 2.1.0-beta.1, < 2.1.0-beta.45 | 2.1.0-beta.45 | GHSA-v8vm-cqh8-q87q |