CVE-2026-52888: NocoBase: Sensitive Data Exposure via SQL Blacklist Bypass
The checkSQL() function in plugin-collection-sql implements a keyword-based blacklist to prevent dangerous SQL queries from being executed through the SQL Collection feature. However, the blacklist is incomplete: it only checks for a subset of dangerous PostgreSQL system functions and does not restrict access to sensitive system catalog tables such as pg_shadow, pg_roles, or pg_stat_activity.
An authenticated user with the admin role can exploit this to dump PostgreSQL password hashes (pg_shadow), read all NocoBase user credentials (hashed passwords from the users table), and enumerate the full database schema — all data that admin users should never be able to access through the application interface.
References
- github.com/advisories/GHSA-v8vm-cqh8-q87q
- github.com/nocobase/nocobase/commit/4aecb60d151a9002004dcf984f63d62f17a6cb45
- github.com/nocobase/nocobase/commit/87c548969ce9258dd7f0d9571c9453ae10bc3fc4
- github.com/nocobase/nocobase/pull/9683
- github.com/nocobase/nocobase/releases/tag/v2.0.62
- github.com/nocobase/nocobase/releases/tag/v2.1.0-alpha.46
- github.com/nocobase/nocobase/security/advisories/GHSA-v8vm-cqh8-q87q
- nvd.nist.gov/vuln/detail/CVE-2026-52888
Code Behaviors & Features
Detect and mitigate CVE-2026-52888 with GitLab Dependency Scanning
Secure your software supply chain by verifying that all open source dependencies used in your projects contain no disclosed vulnerabilities. Learn more about Dependency Scanning →