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. Dependency Scanning using SBOM also detects vulnerabilities from proprietary advisories that this site does not include. Learn more about Dependency Scanning using SBOM →