Advisory

UBUNTU-CVE-2024-0985

Also known as: CVE-2024-0985

Summary

The record has no summary.

Details

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.

Severity

High Basis: CVSS v3 score 8, vector CVSS:3.1/AV:N/AC:L/PR:L/UI:R/S:U/C:H/I:H/A:H

Dates

Published
2024-02-08 13:15 UTC
Modified
2026-04-22 14:36 UTC

Affected packages and fixes

postgresql-12

Debian packages (deb) · Ubuntu 20.04

Affected

  • introduced 0, fixed 12.18-0ubuntu0.20.04.1 (ecosystem)

Fixed versions

12.18-0ubuntu0.20.04.1

Fix

  • Fixed version 12.18-0ubuntu0.20.04.1
    sudo apt-get update && sudo apt-get upgrade

This command upgrades the distribution's packages. Compare the fixed version with the version you have installed.

postgresql-14

Debian packages (deb) · Ubuntu 22.04

Affected

  • introduced 0, fixed 14.11-0ubuntu0.22.04.1 (ecosystem)

Fixed versions

14.11-0ubuntu0.22.04.1

Fix

  • Fixed version 14.11-0ubuntu0.22.04.1
    sudo apt-get update && sudo apt-get upgrade

This command upgrades the distribution's packages. Compare the fixed version with the version you have installed.

postgresql-16

Debian packages (deb) · Ubuntu 24.04

Affected

  • introduced 0, fixed 16.2-1 (ecosystem)

Fixed versions

16.2-1

Fix

  • Fixed version 16.2-1
    sudo apt-get update && sudo apt-get upgrade

This command upgrades the distribution's packages. Compare the fixed version with the version you have installed.

Fix commands are the export's own generic commands. Ojuju never runs them. Check them against your setup first.

Check your own computer: guard packages check

View this record on OSV.dev

Source

Source: Ubuntu Security Notices · CC BY-SA 4.0

Sources & licences