CVE-2026-105612

PostgreSQL Anonymizer: Data-modifying CTEs bypass the read-only restriction of masked roles

Published Oct 28, 2026 CVSS 3.1 · 3.5 Low EPSS < 1% KEV · Not listed
Description
PostgreSQL Anonymizer contains a vulnerability that data-modifying CTEs to bypass the read-only restriction of masked roles. The problem is resolved in PostgreSQL Anonymizer 3.3.0 and later versions

Analysis

AI-generated

Technical impact

The PostgreSQL Anonymizer plugin contains a missing authorization flaw that allows data-modifying common table expressions (CTEs) to bypass the read‑only restriction normally enforced for masked roles. This permits an attacker who can run a DML CTE to alter or delete data that should have been protected, thereby compromising data integrity and potentially exposing sensitive information.

Affected Systems

Dalibo PostgreSQL Anonymizer versions prior to 3.3.0 are affected; the issue is fixed in version 3.3.0 and later.

Risk and Exploitability

The CVSS score of 3.5 indicates low severity, and no EPSS score is available. The vulnerability is not listed in CISA KEV. The likely attack vector is an internal database user or an attacker who has been granted a masked role that is expected to be read‑only but can execute a data‑modifying CTE, enabling unauthorized data changes.

Remediation

Vendor Workaround

None


OpenCVE Recommended Actions

  • Upgrade to PostgreSQL Anonymizer 3.3.0 or later to remediate the flaw.
  • Revoke INSERT, UPDATE and DELETE privileges from masked roles at the database level so that only SELECT operations are permitted for those roles.
  • Implement monitoring or logging to detect execution of data‑modifying CTEs by masked roles and set alerts for anomalous activity.

Generated by OpenCVE AI on October 28, 2026 at 18:54 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 contains a vulnerability that data-modifying CTEs to bypass the read-only restriction of masked roles. The problem is resolved in PostgreSQL Anonymizer 3.3.0 and later versions
Title PostgreSQL Anonymizer: Data-modifying CTEs bypass the read-only restriction of masked roles
Weaknesses CWE-862
References
Metrics cvssV3_1

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

Weaknesses

Sources

Status
PUBLISHED
Assigner
PostgreSQL
Published
Updated
Nov 5, 2026, 5:00 PM
Reserved
Oct 5, 2026, 4:26 PM
Status
Analyzed
Published
Oct 28, 2026, 6:17 PM
Modified
Nov 12, 2026, 9:03 PM