CVE-2026-61821: CWE-862: Missing Authorization in pgpartman pg_partman
pg_partman is a PostgreSQL extension that manages partitioned tables by time or ID. Prior to 5.5.0, drop_partition_id() and drop_partition_time() use part_config.retention_schema as the target for ALTER TABLE SET SCHEMA and accept any nonempty schema name. A role with partman_user access can select a target schema where the role lacks the normal CREATE privilege, and the background worker performs the relocation with pg_partman_bgw.role privileges, which default to PostgreSQL superuser, bypassing the authorization check that a normal ALTER TABLE SET SCHEMA operation would enforce. This permits unauthorized relocation of retained child tables between schemas. This issue is fixed in version 5.5.0.
AI Analysis
Technical Summary
The vulnerability CVE-2026-61821 affects pg_partman, a PostgreSQL extension for managing partitioned tables. Before version 5.5.0, the functions drop_partition_id() and drop_partition_time() use the part_config.retention_schema as the target schema for ALTER TABLE SET SCHEMA operations. These functions accept any nonempty schema name, and a role with partman_user access can specify a schema where it lacks CREATE privileges. The background worker then performs the schema relocation using pg_partman_bgw.role privileges, which default to PostgreSQL superuser. This bypasses the usual authorization checks, enabling unauthorized relocation of retained child tables between schemas. The vulnerability is addressed in version 5.5.0.
Potential Impact
An attacker with partman_user role privileges can relocate retained child tables to arbitrary schemas without having the required CREATE privileges on those schemas. This bypass of authorization checks can lead to unauthorized data manipulation or access control violations. The CVSS 3.1 score is 8.5 (high), reflecting network attack vector, low attack complexity, required privileges, no user interaction, scope change, high confidentiality impact, low integrity impact, and no availability impact.
Mitigation Recommendations
Upgrade pg_partman to version 5.5.0 or later, where this authorization bypass vulnerability is fixed. No other mitigations are indicated by the vendor advisory. Patch status is confirmed fixed in 5.5.0.
CVE-2026-61821: CWE-862: Missing Authorization in pgpartman pg_partman
Description
pg_partman is a PostgreSQL extension that manages partitioned tables by time or ID. Prior to 5.5.0, drop_partition_id() and drop_partition_time() use part_config.retention_schema as the target for ALTER TABLE SET SCHEMA and accept any nonempty schema name. A role with partman_user access can select a target schema where the role lacks the normal CREATE privilege, and the background worker performs the relocation with pg_partman_bgw.role privileges, which default to PostgreSQL superuser, bypassing the authorization check that a normal ALTER TABLE SET SCHEMA operation would enforce. This permits unauthorized relocation of retained child tables between schemas. This issue is fixed in version 5.5.0.
CVSS v3.1
Score 8.5high
Affected software
pgpartman
pg_partman
pkg:github/pgpartman/pg_partmanRun on your own infrastructure? Check whether these packages are installed with threat-finder — our free open-source scanner.
Weaknesses
AI-Powered Analysis
Machine-generated threat intelligence
Technical Analysis
The vulnerability CVE-2026-61821 affects pg_partman, a PostgreSQL extension for managing partitioned tables. Before version 5.5.0, the functions drop_partition_id() and drop_partition_time() use the part_config.retention_schema as the target schema for ALTER TABLE SET SCHEMA operations. These functions accept any nonempty schema name, and a role with partman_user access can specify a schema where it lacks CREATE privileges. The background worker then performs the schema relocation using pg_partman_bgw.role privileges, which default to PostgreSQL superuser. This bypasses the usual authorization checks, enabling unauthorized relocation of retained child tables between schemas. The vulnerability is addressed in version 5.5.0.
Potential Impact
An attacker with partman_user role privileges can relocate retained child tables to arbitrary schemas without having the required CREATE privileges on those schemas. This bypass of authorization checks can lead to unauthorized data manipulation or access control violations. The CVSS 3.1 score is 8.5 (high), reflecting network attack vector, low attack complexity, required privileges, no user interaction, scope change, high confidentiality impact, low integrity impact, and no availability impact.
Mitigation Recommendations
Upgrade pg_partman to version 5.5.0 or later, where this authorization bypass vulnerability is fixed. No other mitigations are indicated by the vendor advisory. Patch status is confirmed fixed in 5.5.0.
Technical Details
- Data Version
- 5.2
- Assigner Short Name
- GitHub_M
- Date Reserved
- 2026-07-10T20:17:57.992Z
- Cvss Version
- 3.1
- State
- PUBLISHED
Threat ID: 6aad98c355bf5e2cf57b8897
Added to database: 09/18/2026, 20:02:11 UTC
Last enriched: 09/18/2026, 20:17:20 UTC
Last updated: 09/19/2026, 01:09:18 UTC
Views: 7
Community Reviews
0 reviewsCrowdsource mitigation strategies, share intel context, and vote on the most helpful responses. Sign in to add your voice and help keep defenders ahead.
Want to contribute mitigation steps or threat intel context? Sign in or create an account to join the community discussion.
Actions
Updates to AI analysis require Pro Console access. Upgrade inside Console → Billing.
Need more coverage?
Upgrade to Pro Console for AI refresh and higher limits.
For incident response and remediation, OffSeq services can help resolve threats faster.
Latest Threats
Check if your credentials are on the dark web
Instant breach scanning across billions of leaked records. Free tier available.