CVE-2026-105620

PostgreSQL Anonymizer: A masked role reads the authentic data of masked tables through a masking rule with a sub-query

Published Oct 28, 2026 CVSS 3.1 · 6.5 Medium EPSS < 1% KEV · Not listed
Description
PostgreSQL Anonymizer doesn't mask data returned by a sub-query in a rule. The problem is resolved in PostgreSQL Anonymizer 3.3.0 and later versions.

Analysis

AI-generated

Technical impact

The PostgreSQL Anonymizer module fails to mask data that is retrieved through a sub‑query within a masking rule. As a result, a role that is intended only to receive anonymised data can read the original, authentic data, violating confidentiality. This flaw is a classic case of missing authorization control and is listed as CWE-862.

Affected Systems

The vulnerability affects the Dalibo PostgreSQL Anonymizer extension for PostgreSQL. Versions released before 3.3.0 do not filter sub‑query results in masking rules. The issue is resolved in PostgreSQL Anonymizer 3.3.0 and any later releases.

Risk and Exploitability

The CVSS score of 6.5 indicates moderate severity. No EPSS score is available, and the flaw is not listed in the CISA KEV catalog, suggesting limited public exploitation data. Affected users typically need database access and the ability to query masked tables; thus the attack requires legitimate database privileges or the ability to modify mask rules. Because the flaw leaks authentic data to a role that should receive only anonymised values, the impact is significant for confidentiality but depends on the privilege level of the attacker.

Remediation

Vendor Workaround

None


OpenCVE Recommended Actions

  • Upgrade PostgreSQL Anonymizer to version 3.3.0 or newer.
  • Redesign any masking rules that use sub‑queries, or remove sub‑query usage entirely.
  • Apply least‑privilege principles to roles that can create or modify mask rules, limiting their ability to craft sub‑query‑based masking logic.

Generated by OpenCVE AI on October 28, 2026 at 18:23 UTC.

Tracking

Sign in to view the affected projects.

Advisories

No advisories available
History
Type Values Removed Values Added
CPEs cpe:2.3:a:dalibo:postgresql_anonymizer:*:*:*:*:*:postgresql:*:*
Type Values Removed Values Added
Metrics ssvc

{'options': {'Automatable': 'no', 'Exploitation': 'none', 'Technical Impact': 'partial'}, 'version': '2.0.3'}

Type Values Removed Values Added
First Time appeared Dalibo
Dalibo postgresql Anonymizer
Vendors & Products Dalibo
Dalibo postgresql Anonymizer
Type Values Removed Values Added
Description PostgreSQL Anonymizer doesn't mask data returned by a sub-query in a rule. The problem is resolved in PostgreSQL Anonymizer 3.3.0 and later versions.
Title PostgreSQL Anonymizer: A masked role reads the authentic data of masked tables through a masking rule with a sub-query
Weaknesses CWE-862
References
Metrics cvssV3_1

{'score': 6.5, 'vector': 'CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N'}

Weaknesses

Sources

Status
PUBLISHED
Assigner
PostgreSQL
Published
Updated
Nov 5, 2026, 4:52 PM
Reserved
Oct 5, 2026, 4:26 PM
Status
Analyzed
Published
Oct 28, 2026, 6:17 PM
Modified
Nov 12, 2026, 8:54 PM