1219679 – (CVE-2024-0985) VUL-0: CVE-2024-0985: postgresql,postgresql10,postgresql12,postgresql13,postgresql14,postgresql15,postgresql16,postgresql94,postgresql96: security restrictions of REFRESH MATERIALIZED VIEW CONCURRENTLY too weak

Bug 1219679 (CVE-2024-0985) - VUL-0: CVE-2024-0985: postgresql,postgresql10,postgresql12,postgresql13,postgresql14,postgresql15,postgresql16,postgresql94,postgresql96: security restrictions of REFRESH MATERIALIZED VIEW CONCURRENTLY too weak

Summary: VUL-0: CVE-2024-0985: postgresql,postgresql10,postgresql12,postgresql13,postg...

Status:	IN_PROGRESS

Alias:	CVE-2024-0985

Product:	SUSE Security Incidents
Classification:	Novell Products
Component:	Incidents (show other bugs)
Version:	unspecified
Hardware:	Other Other

Priority:	P3 - Medium Severity: Normal
Target Milestone:	---
Assignee:	Security Team bot
QA Contact:	Security Team bot

URL:	https://smash.suse.de/issue/393350/
Whiteboard:	CVSSv3.1:SUSE:CVE-2024-0985:8.0:(AV:N...
Keywords:

Depends on:
Blocks:

Clone This Bug

Reported:	2024-02-07 15:07 UTC by SMASH SMASH
Modified:	2024-02-20 20:36 UTC (History)
CC List:	2 users (show)

See Also:
Found By:	Security Response Team
Services Priority:
Business Priority:
Blocker:	---
Marketing QA Status:	---
IT Deployment:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description SMASH SMASH 2024-02-07 15:07:08 UTC

via reinhard directly

CRD: 2024-02-08

the next round of minor updates for PostgreSQL which is scheduled for 
tomorrow will fix the following security issue. It affects all 
upstream-supported versions, i.e. 12 through 18.

   • Tighten security restrictions within REFRESH MATERIALIZED VIEW
     CONCURRENTLY (Heikki Linnakangas)

     One step of a concurrent refresh command was run under weak
     security restrictions. If a materialized view's owner could
     persuade a superuser or other high-privileged user to perform a
     concurrent refresh on that view, the view's owner could control
     code executed with the privileges of the user running REFRESH.
     Fix things so that all user-determined code is run as the view's
     owner, as expected.

     The only known exploit for this error does not work in PostgreSQL
     16.0 and later, so it may be that v16 is not vulnerable in
     practice.

     The PostgreSQL Project thanks Pedro Gallegos for reporting this
     problem. (CVE-2024-0985)

Comment 1 Marcus Meissner 2024-02-08 14:38:42 UTC

is public now

Comment 3 OBSbugzilla Bot 2024-02-08 17:55:05 UTC

This is an autogenerated message for OBS integration:
This bug (1219679) was mentioned in
https://build.opensuse.org/request/show/1145268 Factory / postgresql16
https://build.opensuse.org/request/show/1145269 Factory / postgresql15
https://build.opensuse.org/request/show/1145270 Factory / postgresql14
https://build.opensuse.org/request/show/1145272 Factory / postgresql13
https://build.opensuse.org/request/show/1145273 Factory / postgresql12

Comment 4 Maintenance Automation 2024-02-15 20:30:01 UTC

SUSE-SU-2024:0520-1: An update that solves one vulnerability can now be installed.

Category: security (important)
Bug References: 1219679
CVE References: CVE-2024-0985
Sources used:
SUSE Linux Enterprise Software Development Kit 12 SP5 (src): postgresql15-15.6-3.22.1
SUSE Linux Enterprise High Performance Computing 12 SP5 (src): postgresql15-15.6-3.22.1
SUSE Linux Enterprise Server 12 SP5 (src): postgresql15-15.6-3.22.1
SUSE Linux Enterprise Server for SAP Applications 12 SP5 (src): postgresql15-15.6-3.22.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 5 Maintenance Automation 2024-02-16 16:30:01 UTC

SUSE-SU-2024:0523-1: An update that solves one vulnerability can now be installed.

Category: security (important)
Bug References: 1219679
CVE References: CVE-2024-0985
Sources used:
openSUSE Leap 15.5 (src): postgresql12-12.18-150200.8.57.1
SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (src): postgresql12-12.18-150200.8.57.1
SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (src): postgresql12-12.18-150200.8.57.1
SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (src): postgresql12-12.18-150200.8.57.1
SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): postgresql12-12.18-150200.8.57.1
SUSE Linux Enterprise Server for SAP Applications 15 SP2 (src): postgresql12-12.18-150200.8.57.1
SUSE Linux Enterprise Server for SAP Applications 15 SP3 (src): postgresql12-12.18-150200.8.57.1
SUSE Enterprise Storage 7.1 (src): postgresql12-12.18-150200.8.57.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 6 Maintenance Automation 2024-02-16 16:36:07 UTC

SUSE-SU-2024:0522-1: An update that solves one vulnerability can now be installed.

Category: security (important)
Bug References: 1219679
CVE References: CVE-2024-0985
Sources used:
SUSE Linux Enterprise Server for SAP Applications 15 SP3 (src): postgresql13-13.14-150200.5.53.1
SUSE Linux Enterprise Server for SAP Applications 15 SP4 (src): postgresql13-13.14-150200.5.53.1
SUSE Enterprise Storage 7.1 (src): postgresql13-13.14-150200.5.53.1
openSUSE Leap 15.5 (src): postgresql13-13.14-150200.5.53.1
SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (src): postgresql13-13.14-150200.5.53.1
SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (src): postgresql13-13.14-150200.5.53.1
SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4 (src): postgresql13-13.14-150200.5.53.1
SUSE Linux Enterprise High Performance Computing LTSS 15 SP4 (src): postgresql13-13.14-150200.5.53.1
SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (src): postgresql13-13.14-150200.5.53.1
SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): postgresql13-13.14-150200.5.53.1
SUSE Linux Enterprise Server 15 SP4 LTSS 15-SP4 (src): postgresql13-13.14-150200.5.53.1
Galera for Ericsson 15 SP5 (src): postgresql13-13.14-150200.5.53.1
SUSE Linux Enterprise Server for SAP Applications 15 SP2 (src): postgresql13-13.14-150200.5.53.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 7 Maintenance Automation 2024-02-20 16:30:01 UTC

SUSE-SU-2024:0546-1: An update that solves one vulnerability can now be installed.

Category: security (important)
Bug References: 1219679
CVE References: CVE-2024-0985
Sources used:
SUSE Linux Enterprise Software Development Kit 12 SP5 (src): postgresql16-16.2-3.10.1
SUSE Linux Enterprise High Performance Computing 12 SP5 (src): postgresql16-16.2-3.10.1
SUSE Linux Enterprise Server 12 SP5 (src): postgresql16-16.2-3.10.1
SUSE Linux Enterprise Server for SAP Applications 12 SP5 (src): postgresql16-16.2-3.10.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 8 Maintenance Automation 2024-02-20 16:30:09 UTC

SUSE-SU-2024:0542-1: An update that solves one vulnerability can now be installed.

Category: security (important)
Bug References: 1219679
CVE References: CVE-2024-0985
Sources used:
SUSE Linux Enterprise Software Development Kit 12 SP5 (src): postgresql12-12.18-3.52.1
SUSE Linux Enterprise High Performance Computing 12 SP5 (src): postgresql12-12.18-3.52.1
SUSE Linux Enterprise Server 12 SP5 (src): postgresql12-12.18-3.52.1
SUSE Linux Enterprise Server for SAP Applications 12 SP5 (src): postgresql12-12.18-3.52.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 9 Maintenance Automation 2024-02-20 20:36:26 UTC

SUSE-SU-2024:0552-1: An update that solves one vulnerability can now be installed.

Category: security (important)
Bug References: 1219679
CVE References: CVE-2024-0985
Sources used:
SUSE Linux Enterprise Server for SAP Applications 15 SP2 (src): postgresql14-14.11-150200.5.39.1
SUSE Linux Enterprise Server for SAP Applications 15 SP3 (src): postgresql14-14.11-150200.5.39.1
SUSE Linux Enterprise Server for SAP Applications 15 SP4 (src): postgresql14-14.11-150200.5.39.1
SUSE Manager Proxy 4.3 (src): postgresql14-14.11-150200.5.39.1
SUSE Manager Retail Branch Server 4.3 (src): postgresql14-14.11-150200.5.39.1
SUSE Manager Server 4.3 (src): postgresql14-14.11-150200.5.39.1
SUSE Enterprise Storage 7.1 (src): postgresql14-14.11-150200.5.39.1
openSUSE Leap 15.5 (src): postgresql14-14.11-150200.5.39.1
Legacy Module 15-SP5 (src): postgresql14-14.11-150200.5.39.1
SUSE Package Hub 15 15-SP5 (src): postgresql14-14.11-150200.5.39.1
SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (src): postgresql14-14.11-150200.5.39.1
SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (src): postgresql14-14.11-150200.5.39.1
SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4 (src): postgresql14-14.11-150200.5.39.1
SUSE Linux Enterprise High Performance Computing LTSS 15 SP4 (src): postgresql14-14.11-150200.5.39.1
SUSE Linux Enterprise Desktop 15 SP4 LTSS 15-SP4 (src): postgresql14-14.11-150200.5.39.1
SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (src): postgresql14-14.11-150200.5.39.1
SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): postgresql14-14.11-150200.5.39.1
SUSE Linux Enterprise Server 15 SP4 LTSS 15-SP4 (src): postgresql14-14.11-150200.5.39.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 10 Maintenance Automation 2024-02-20 20:36:29 UTC

SUSE-SU-2024:0551-1: An update that solves one vulnerability can now be installed.

Category: security (important)
Bug References: 1219679
CVE References: CVE-2024-0985
Sources used:
openSUSE Leap 15.5 (src): postgresql15-15.6-150200.5.22.1
Basesystem Module 15-SP5 (src): postgresql15-15.6-150200.5.22.1
Server Applications Module 15-SP5 (src): postgresql15-15.6-150200.5.22.1
SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (src): postgresql15-15.6-150200.5.22.1
SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4 (src): postgresql15-15.6-150200.5.22.1
SUSE Linux Enterprise High Performance Computing LTSS 15 SP4 (src): postgresql15-15.6-150200.5.22.1
SUSE Linux Enterprise Desktop 15 SP4 LTSS 15-SP4 (src): postgresql15-15.6-150200.5.22.1
SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): postgresql15-15.6-150200.5.22.1
SUSE Linux Enterprise Server 15 SP4 LTSS 15-SP4 (src): postgresql15-15.6-150200.5.22.1
SUSE Linux Enterprise Server for SAP Applications 15 SP3 (src): postgresql15-15.6-150200.5.22.1
SUSE Linux Enterprise Server for SAP Applications 15 SP4 (src): postgresql15-15.6-150200.5.22.1
SUSE Manager Proxy 4.3 (src): postgresql15-15.6-150200.5.22.1
SUSE Manager Retail Branch Server 4.3 (src): postgresql15-15.6-150200.5.22.1
SUSE Manager Server 4.3 (src): postgresql15-15.6-150200.5.22.1
SUSE Enterprise Storage 7.1 (src): postgresql15-15.6-150200.5.22.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 11 Maintenance Automation 2024-02-20 20:36:31 UTC

SUSE-SU-2024:0550-1: An update that solves one vulnerability can now be installed.

Category: security (important)
Bug References: 1219679
CVE References: CVE-2024-0985
Sources used:
SUSE Linux Enterprise Server for SAP Applications 15 SP3 (src): postgresql16-16.2-150200.5.10.1
SUSE Linux Enterprise Server for SAP Applications 15 SP4 (src): postgresql16-16.2-150200.5.10.1
SUSE Manager Proxy 4.3 (src): postgresql16-16.2-150200.5.10.1
SUSE Manager Retail Branch Server 4.3 (src): postgresql16-16.2-150200.5.10.1
SUSE Manager Server 4.3 (src): postgresql16-16.2-150200.5.10.1
SUSE Enterprise Storage 7.1 (src): postgresql16-16.2-150200.5.10.1
openSUSE Leap 15.5 (src): postgresql16-16.2-150200.5.10.1, postgresql16-mini-16.2-150200.5.10.1
Basesystem Module 15-SP5 (src): postgresql16-16.2-150200.5.10.1
SUSE Package Hub 15 15-SP5 (src): postgresql16-16.2-150200.5.10.1
Server Applications Module 15-SP5 (src): postgresql16-16.2-150200.5.10.1
SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (src): postgresql16-16.2-150200.5.10.1
SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (src): postgresql16-16.2-150200.5.10.1
SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4 (src): postgresql16-16.2-150200.5.10.1
SUSE Linux Enterprise High Performance Computing LTSS 15 SP4 (src): postgresql16-16.2-150200.5.10.1
SUSE Linux Enterprise Desktop 15 SP4 LTSS 15-SP4 (src): postgresql16-16.2-150200.5.10.1
SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (src): postgresql16-16.2-150200.5.10.1
SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): postgresql16-16.2-150200.5.10.1
SUSE Linux Enterprise Server 15 SP4 LTSS 15-SP4 (src): postgresql16-16.2-150200.5.10.1
SUSE Linux Enterprise Server for SAP Applications 15 SP2 (src): postgresql16-16.2-150200.5.10.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 12 Maintenance Automation 2024-02-20 20:36:42 UTC

SUSE-SU-2024:0541-1: An update that solves one vulnerability can now be installed.

Category: security (important)
Bug References: 1219679
CVE References: CVE-2024-0985
Sources used:
SUSE Linux Enterprise Software Development Kit 12 SP5 (src): postgresql13-13.14-3.46.1
SUSE Linux Enterprise High Performance Computing 12 SP5 (src): postgresql13-13.14-3.46.1
SUSE Linux Enterprise Server 12 SP5 (src): postgresql13-13.14-3.46.1
SUSE Linux Enterprise Server for SAP Applications 12 SP5 (src): postgresql13-13.14-3.46.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 13 Maintenance Automation 2024-02-20 20:36:44 UTC

SUSE-SU-2024:0540-1: An update that solves one vulnerability can now be installed.

Category: security (important)
Bug References: 1219679
CVE References: CVE-2024-0985
Sources used:
SUSE Linux Enterprise Software Development Kit 12 SP5 (src): postgresql14-14.11-3.36.1
SUSE Linux Enterprise High Performance Computing 12 SP5 (src): postgresql14-14.11-3.36.1
SUSE Linux Enterprise Server 12 SP5 (src): postgresql14-14.11-3.36.1
SUSE Linux Enterprise Server for SAP Applications 12 SP5 (src): postgresql14-14.11-3.36.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.