CVE-2026-110181

PostgreSQL Anonymizer: Function declared with SQL-standard syntax leak anonymized data

Published Oct 28, 2026 CVSS 3.1 · 6.5 Medium EPSS < 1% KEV · Not listed
Description
PostgreSQL Anonymizer contains a vulnerability related to anonymization functions defined using SQL-standard function bodies. PostgreSQL analyses such functions at declaration time, while Anonymizer only attempts to check them at execution time. This problem can be exploited by any user with the TEMPORARY privilege. The issue is fixed in PostgreSQL Anonymizer 3.3.0 and later versions.

Analysis

AI-generated

Technical impact

Functions created with SQL-standard bodies allow the PostgreSQL Anonymizer extension to leak anonymized data. The extension inspects these functions only during execution, while PostgreSQL itself evaluates them at declaration time. This mismatch enables an attacker to retrieve the unmasked data that should have been anonymized, leading to a loss of confidentiality for protected information. The vulnerability is classified as CWE‑693, implicating improper protection when the data were exposed.

Affected Systems

Dalibo’s PostgreSQL Anonymizer extension is affected. The issue persists in all releases prior to version 3.3.0; applying version 3.3.0 or later removes the defect. Any database that employs this extension with an older version is at risk.

Risk and Exploitability

The CVSS score of 6.5 indicates moderate severity. EPSS data are not available, but the vulnerability can be leveraged by any database user who holds the TEMPORARY privilege, which is commonly granted to database roles. The defect is not listed in the CISA KEV catalog, so there is no evidence of active exploitation in the wild. Nonetheless, because the flaw directly compromises data secrecy and is exploitable via ordinary database privileges, it warrants prompt attention.

Remediation

Vendor Workaround

Revoke TEMPORARY from PUBLIC and CREATE on all schemas from masked roles to prevent them from creating a function. Revoke EXECUTE from PUBLIC on function with SQL-standard bodies since anon fails to anonymize the data they return.


OpenCVE Recommended Actions

  • Upgrade Dalibo PostgreSQL Anonymizer to version 3.3.0 or later.
  • Revoke TEMPORARY privilege from the PUBLIC role and from any masked roles that can create functions on all schemas, thereby preventing creation of vulnerable functions.
  • Revoke EXECUTE permission from the PUBLIC role on any existing function with a SQL-standard body until it is re‑created under a safe configuration.

Generated by OpenCVE AI on October 28, 2026 at 18:22 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 related to anonymization functions defined using SQL-standard function bodies. PostgreSQL analyses such functions at declaration time, while Anonymizer only attempts to check them at execution time. This problem can be exploited by any user with the TEMPORARY privilege. The issue is fixed in PostgreSQL Anonymizer 3.3.0 and later versions.
Title PostgreSQL Anonymizer: Function declared with SQL-standard syntax leak anonymized data
Weaknesses CWE-693
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
  • CWE-693

    Protection Mechanism Failure

Sources

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