Bug 1219679 (CVE-2024-0985)

Summary: VUL-0: CVE-2024-0985: postgresql,postgresql10,postgresql12,postgresql13,postgresql14,postgresql15,postgresql16,postgresql94,postgresql96: security restrictions of REFRESH MATERIALIZED VIEW CONCURRENTLY too weak
Product: [Novell Products] SUSE Security Incidents Reporter: SMASH SMASH <smash_bz>
Component: IncidentsAssignee: Security Team bot <security-team>
Status: IN_PROGRESS --- QA Contact: Security Team bot <security-team>
Severity: Normal    
Priority: P3 - Medium CC: max, meissner
Version: unspecified   
Target Milestone: ---   
Hardware: Other   
OS: Other   
URL: https://smash.suse.de/issue/393350/
Whiteboard: CVSSv3.1:SUSE:CVE-2024-0985:8.0:(AV:N/AC:L/PR:L/UI:R/S:U/C:H/I:H/A:H)
Found By: Security Response Team Services Priority:
Business Priority: Blocker: ---
Marketing QA Status: --- IT Deployment: ---

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.