Attack ChainAIDerived
Hypothetical attack flow derived from CVE metadata – not a confirmed exploit chain
-
AccessObtain authenticated masked database role
-
DeliveryCall anon.hash() with large known-seed dictionary
-
ExploitCollect sufficient (seed, hash_output) pairs
-
ExecutionRun offline brute-force to recover salt
-
PersistReverse all pseudonymized column values
-
ImpactExfiltrate original sensitive data
Vulnerability Assessment
| Weakness |
CWE
OWASP Top 10:2025
A04:2025 - Cryptographic Failures
ASVS 5.0
V11 - Cryptography Irreversible hash functions
|
| Exploitation Conditions | Exploitation requires an authenticated database user holding a masked role with execute permission on anon.hash() - the standard configuration for any masked user in a PostgreSQL Anonymizer deployment, making this the default operational state rather than a special configuration. The attacker must supply arbitrary seed inputs and collect a sufficient volume of (seed, hash_output) pairs for offline brute-force; the number required depends on the salt length and underlying hash algorithm, neither of which is specified in the advisory. Limiting factors: the attacker must possess valid database credentials with a masked role assignment; the brute-force phase requires offline compute resources; and the attack is not instantaneous, requiring a sustained data-collection phase that may be observable in query logs. Deployments where masked roles are restricted exclusively to fully-trusted internal users with monitored access face substantially lower realistic risk. No non-default configuration is required - the vulnerability is present in the baseline use of the extension. |
| Impact | The CVSS 4.3 Medium score (AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:N/A:N) reflects a network-reachable, low-complexity attack requiring low privileges with confidentiality-only, partial impact. The C:L rating may understate real-world impact: recovering the salt enables reversal of all pseudonymized columns in the database, not a single record - the systemic exposure is disproportionate to the partial-impact designation. No EPSS data was supplied; no KEV listing exists; no public POC has been identified, placing this in the no-active-exploitation category at time of analysis. AC:L is justified because the collection phase (repeated anon.hash() calls) involves no special conditions beyond holding a masked role, which is the extension's baseline operational mode. The risk is most acute in deployments where masked roles are granted to semi-trusted parties such as external analysts or contractors, which is the primary stated use case for PostgreSQL Anonymizer - meaning the attacker profile is exactly the population the extension is designed to handle. Post-patch, organizations should rotate the anonymization salt, since collected pairs from before the upgrade remain usable offline against the old salt. |
| Exploit ScenarioDerived | A database analyst granted a masked role on a PostgreSQL instance running a vulnerable version of PostgreSQL Anonymizer connects over the network and invokes anon.hash() with a large dictionary of known seed values, accumulating thousands of (seed, output) pairs over multiple sessions. The attacker processes these pairs offline using brute-force or dictionary techniques to recover the salt. With the salt in hand, the attacker uses the same hash function to reverse every pseudonymized column in the database, exposing the original sensitive personal data that the extension was deployed to protect. |
Get an e-mail when this CVE is exploited, patched or re-scored. Free account.
Alert meAnalysisAIv1 – Jun 30, 2026
PostgreSQL Anonymizer's anon.hash() function exposes its internal salt to masked database users through an offline brute-force attack, undermining the core pseudonymization guarantee of the extension. Masked roles - the primary consumer of this extension - can call anon.hash() with arbitrary seed inputs and accumulate (seed, hash_output) pairs to deduce the salt offline, after which all pseudonymized values in the database become reversible. No active exploitation or public proof-of-concept has been identified; a vendor-confirmed fix is available in version 3.1.2.
RemediationAI
Upgrade to PostgreSQL Anonymizer 3.1.2 or later, the vendor-confirmed fix version per the description and GitLab issue https://gitlab.com/dalibo/postgresql_anonymizer/-/issues/649. After patching, rotate the anonymization salt immediately, since any (seed, hash_output) pairs collected by masked users prior to the upgrade remain usable offline to deduce the old salt and reverse historical pseudonymized data - rotation invalidates prior collection efforts. If immediate upgrade is not feasible, revoke or restrict direct execute permission on anon.hash() from masked roles at the PostgreSQL level using REVOKE EXECUTE ON FUNCTION anon.hash() FROM <masked_role>; note this may break masking workflows that depend on the function and should be tested in a non-production environment first. No additional vendor workarounds are documented in the available references.
Affected VersionsENISA
Affected Packages
Source: OSV (Open Source Vulnerabilities)
Affects your stack
Affects 1 package in euvd
Checking this CVE against your own stacks and servers is part of the Basic plan and up.
Technical ContextAI · show details
PostgreSQL Anonymizer is a PostgreSQL extension by Dalibo (CPE: cpe:2.3:a:dalibo:postgresql_anonymizer:*:*:*:*:*:*:*:*) that provides declarative data masking and pseudonymization by applying keyed hash functions to sensitive columns. The anon.hash() function transforms values using a salt-seeded algorithm, with the salt acting as the secret that prevents reversal. CWE-328 (Use of Weak Hash) identifies the root cause class: the hash function's design or invocation mode permits an observer to reconstruct the secret salt by analyzing sufficient input/output pairs. Because masked roles are intentionally granted query access as part of normal extension usage, the data-collection phase requires no privilege escalation - it exploits a capability that is legitimately exposed to exactly the class of user the extension is meant to restrict. Once the salt is recovered offline, the attacker can reverse every pseudonymized value in the database using the same function.
Know when PostgreSQL gets its next vulnerability
- Watch products and get an email when something new is published
- Check this CVE against your own stack and servers
- Exploit and PoC references, threat intelligence from 22 sources
No credit card · 7-day full trial
Severity by source
AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:N/A:N
Network-accessible collection phase with no complexity beyond holding a masked role (PR:L); confidentiality-only, no integrity or availability impact; scope unchanged as recovery affects same database authorization boundary.
Primary rating from Vendor (PostgreSQL).
CVSS VectorVendor: PostgreSQL
Lifecycle Timeline
1DescriptionCVE.org
PostgreSQL Anonymizer contains a vulnerability that allows unprivileged masked users to repeatedly call the anon.hash() function and collects (seed, hash_output) pairs to perform an offline brute-force attack and deduce the salt. The problem is resolved in PostgreSQL Anonymizer 3.1.2 and later versions
Threat Intelligence Overview
How this decision was reached
The engine reads each signal below and applies a fixed list of rules from top to bottom. The first rule that matches sets the recommended action – like a statement, every line is shown.
What every action level means
SSVC AssessmentENISA
Priority Score
Attack Technique
Information disclosure occurs when an application unintentionally exposes sensitive data that aids attackers in reconnaissance or directly compromises security.
More in PostgreSQL
View allPostgreSQL libpq functions PQescapeLiteral(), PQescapeIdentifier(), PQescapeString(), and PQescapeStringConn() improperl
An issue was discovered in Appsmith before 1.52. Rated critical severity (CVSS 9.8), this vulnerability is remotely expl
Argument injection vulnerability in PostgreSQL 9.2.x before 9.2.4, 9.1.x before 9.1.9, and 9.0.x before 9.0.13 allows re
Unauthenticated arbitrary file write in Splunk Enterprise (below 10.2.4 and 10.0.7) and Splunk Cloud Platform (below 10.
Unauthenticated SQL injection in Sangoma Switchvox SMB Edition 8.3 (build 104997) lets remote attackers execute arbitrar
PostgreSQL versions before 9.2.22, 9.3.18, 9.4.13, 9.5.8 and 9.6.4 are vulnerable to incorrect authentication flaw allow
The build_tablename function in pgsql.c in the PostgreSQL (aka pgsql) extension in PHP through 5.6.7 does not validate t
A vulnerability in the h2oai/h2o-3 REST API versions 3.46.0.4 allows unauthenticated remote attackers to execute arbitra
In PostgreSQL 9.3 through 11.2, the "COPY TO/FROM PROGRAM" function allows superusers and users in the 'pg_execute_serve
Unauthenticated SQL injection in Vendure Shop API allows remote attackers to execute arbitrary SQL commands against the
Parse Server is an open source http web server backend. Rated critical severity (CVSS 10.0), this vulnerability is remot
Hard-coded default PostgreSQL credentials shipped in the docker-compose.yaml of langgenius Dify through version 1.5.1 al
EUVD-2026-40349
GHSA-8ch8-93q8-mhm3
NVD
CVE.org
EPSS
Vulnrichment
Exploit-DB