CVE-2024-0985

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. Versions before PostgreSQL 16.2, 15.6, 14.11, 13.14, and 12.18 are affected.
ProviderTypeBase ScoreAtk. VectorAtk. ComplexityPriv. RequiredVector
NISTNIST
8 HIGH
NETWORK
LOW
LOW
CVSS:3.1/AV:N/AC:L/PR:L/UI:R/S:U/C:H/I:H/A:H
PostgreSQLCNA
8 HIGH
CVSS:3.1/AV:N/AC:L/PR:L/UI:R/S:U/C:H/I:H/A:H
CVEADP
---
---
Base Score
CVSS 3.x
EPSS Score
Percentile: 47%
VendorProductVersion
postgresqlpostgresql
12.0 ≤
𝑥
< 12.18
postgresqlpostgresql
13.0 ≤
𝑥
< 13.14
postgresqlpostgresql
14.0 ≤
𝑥
< 14.11
postgresqlpostgresql
15.0 ≤
𝑥
< 15.6
𝑥
= Vulnerable software versions
Debian logo
Debian Releases
Debian Product
Codename
postgresql-13
bullseye
13.16-0+deb11u1
fixed
bullseye (security)
13.21-0+deb11u1
fixed
postgresql-15
bookworm
15.13-0+deb12u1
fixed
bookworm (security)
15.10-0+deb12u1
fixed
Ubuntu logo
Ubuntu Releases
Ubuntu Product
Codename
postgresql-10
plucky
dne
oracular
dne
noble
dne
mantic
dne
jammy
dne
focal
dne
bionic
needs-triage
xenial
dne
trusty
dne
postgresql-12
plucky
dne
oracular
dne
noble
dne
mantic
dne
jammy
dne
focal
Fixed 12.18-0ubuntu0.20.04.1
released
bionic
dne
xenial
dne
trusty
ignored
postgresql-14
plucky
dne
oracular
dne
noble
dne
mantic
dne
jammy
Fixed 14.11-0ubuntu0.22.04.1
released
focal
dne
bionic
dne
xenial
dne
trusty
dne
postgresql-15
plucky
dne
oracular
dne
noble
dne
mantic
Fixed 15.6-0ubuntu0.23.10.1
released
jammy
dne
focal
dne
bionic
dne
xenial
dne
trusty
dne
postgresql-16
plucky
dne
oracular
Fixed 16.2-1
released
noble
Fixed 16.2-1
released
mantic
dne
jammy
dne
focal
dne
bionic
dne
xenial
dne
trusty
dne
postgresql-9.1
plucky
dne
oracular
dne
noble
dne
mantic
dne
jammy
dne
focal
dne
bionic
dne
xenial
dne
trusty
ignored
postgresql-9.3
plucky
dne
oracular
dne
noble
dne
mantic
dne
jammy
dne
focal
dne
bionic
dne
xenial
dne
trusty
deferred
postgresql-9.5
plucky
dne
oracular
dne
noble
dne
mantic
dne
jammy
dne
focal
dne
bionic
dne
xenial
Fixed 9.5.25-0ubuntu0.16.04.1+esm7
released
trusty
dne