جزئیات آسیب‌پذیری

pg_partman is a PostgreSQL extension that manages partitioned tables by time or ID. Prior to 5.5.0, create_partition_time() reads the writable part_config.time_encoder text value and interpolates it without identifier quoting into a dynamically executed SELECT statement. A role with the documented partman_user INSERT and UPDATE privileges can store SQL rather than a function name. When pg_partman_bgw later creates a child partition for a text- or UUID-keyed set, the worker executes the stored SQL with pg_partman_bgw.role privileges, which default to PostgreSQL superuser. The persistent configuration row can repeatedly restore elevated access on later maintenance ticks, and successful exploitation can permit database-wide compromise and operating-system command execution as the PostgreSQL service account. This issue is fixed in version 5.5.0.

• https://github.com/pgpartman/pg_partman/security/advisories/GHSA-742w-3j7c-qwvp x_refsource_CONFIRM
• https://github.com/pgpartman/pg_partman/commit/ba9405542acf24dd881845b935cab8b165854361 x_refsource_MISC
• https://github.com/pgpartman/pg_partman/releases/tag/v5.5.0 x_refsource_MISC