Skip to main content

Privilege Dropping / Lowering Errors

CVE-2024-0985

Severity High
Score 8/10

Summary

Late privilege drop in `REFRESH MATERIALIZED VIEW CONCURRENTLY` in PostgreSQL allows an object creator to execute arbitrary SQL functions as the command issuer. The command intends to run SQL functions as the owner of the materialized view, enabling safe refresh of untrusted materialized views. The victim is a superuser or member of one of the attacker's roles. The attack requires luring the victim into running `REFRESH MATERIALIZED VIEW CONCURRENTLY` on the attacker's materialized view. This issue affects PostgreSQL versions prior to 12.18, 13.x prior to 13.14, 14.x prior to 14.11, 15.x prior to 15.6 and 16.x prior to 16.2.

  • LOW
  • NETWORK
  • HIGH
  • UNCHANGED
  • REQUIRED
  • LOW
  • HIGH
  • HIGH

CWE-271 - Privilege Dropping / Lowering Errors

The software does not drop privileges before passing control of a resource to an actor that does not have those privileges.

Advisory Timeline

  • Published