CVE-2024-2338

SQL Injection in PostgreSQL Anonymizer 1.2 allows table owner to gain superuser privileges via masking rule

Published Mar 8, 2024 CVSS 3.1 · 8 High EPSS < 1% KEV · Not listed
Description
PostgreSQL Anonymizer v1.2 contains a SQL injection vulnerability that allows a user who owns a table to elevate to superuser when dynamic masking is enabled. PostgreSQL Anonymizer enables users to set security labels on tables to mask specified columns. There is a flaw that allows complex expressions to be provided as a value. This expression is then later used as it to create the masked views leading to SQL Injection. If dynamic masking is enabled, this will lead to privilege escalation to superuser after the label is created. Users that don't own a table, especially masked users cannot exploit this vulnerability. The problem is resolved in v1.3.

Remediation

Vendor Workaround

Disable dynamic masking

Tracking

Sign in to view the affected projects.

Advisories

Source ID Title
EUVD EUVD EUVD-2024-27292 PostgreSQL Anonymizer v1.2 contains a SQL injection vulnerability that allows a user who owns a table to elevate to superuser when dynamic masking is enabled. PostgreSQL Anonymizer enables users to set security labels on tables to mask specified columns. There is a flaw that allows complex expressions to be provided as a value. This expression is then later used as it to create the masked views leading to SQL Injection. If dynamic masking is enabled, this will lead to privilege escalation to superuser after the label is created. Users that don't own a table, especially masked users cannot exploit this vulnerability. The problem is resolved in v1.3.
History
Type Values Removed Values Added
First Time appeared Dalibo
Dalibo anonymizer
CPEs cpe:2.3:a:dalibo:anonymizer:1.2.0:*:*:*:*:postgresql:*:*
Vendors & Products Dalibo
Dalibo anonymizer
Weaknesses

Sources

Status
PUBLISHED
Assigner
PostgreSQL
Published
Updated
Aug 1, 2024, 7:11 PM
Reserved
Mar 8, 2024, 7:53 PM
Status
Analyzed
Published
Mar 8, 2024, 8:15 PM
Modified
Jun 17, 2026, 7:24 AM