Advisory Database
  • Advisories
  • Dependency Scanning
  1. npm
  2. ›
  3. @nocobase/plugin-collection-sql
  4. ›
  5. CVE-2026-52888

CVE-2026-52888: NocoBase: Sensitive Data Exposure via SQL Blacklist Bypass

July 28, 2026

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 →

Affected versions

All versions before 2.0.62, all versions starting from 2.1.0-alpha.1 before 2.1.0-alpha.46, all versions starting from 2.1.0-beta.1 before 2.1.0-beta.45

Fixed versions

  • 2.0.62
  • 2.1.0-alpha.46
  • 2.1.0-beta.45

Solution

Upgrade to versions 2.0.62, 2.1.0-alpha.46, 2.1.0-beta.45 or above.

Impact 6.8 MEDIUM

CVSS:3.1/AV:N/AC:L/PR:H/UI:N/S:C/C:H/I:N/A:N

Learn more about CVSS

Weakness

  • CWE-184: Incomplete List of Disallowed Inputs
  • CWE-200: Exposure of Sensitive Information to an Unauthorized Actor

Source file

npm/@nocobase/plugin-collection-sql/CVE-2026-52888.yml

Spotted a mistake? Edit the file on GitLab.

  • Site Repo
  • About GitLab
  • Terms
  • Privacy Statement
  • Contact

Page generated Wed, 29 Jul 2026 00:19:47 +0000.