Security update for postgresql12

Announcement ID: SUSE-SU-2023:2199-1
Rating: important
References:
Cross-References:
CVSS scores:
  • CVE-2023-2454 ( SUSE ): 6.0 CVSS:3.1/AV:L/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N
  • CVE-2023-2454 ( NVD ): 7.2 CVSS:3.1/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:H
  • CVE-2023-2455 ( SUSE ): 7.1 CVSS:3.1/AV:L/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:N
  • CVE-2023-2455 ( NVD ): 5.4 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N
Affected Products:
  • openSUSE Leap 15.4
  • SUSE Enterprise Storage 7
  • SUSE Enterprise Storage 7.1
  • SUSE Linux Enterprise High Performance Computing 15 SP2
  • SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2
  • SUSE Linux Enterprise High Performance Computing 15 SP3
  • SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3
  • SUSE Linux Enterprise High Performance Computing LTSS 15 SP3
  • SUSE Linux Enterprise Server 15 SP2
  • SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2
  • SUSE Linux Enterprise Server 15 SP3
  • SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3
  • SUSE Linux Enterprise Server for SAP Applications 15 SP2
  • SUSE Linux Enterprise Server for SAP Applications 15 SP3

An update that solves two vulnerabilities and has one security fix can now be installed.

Description:

This update for postgresql12 fixes the following issues:

Updated to version 12.15: - CVE-2023-2454: Fixed an issue where a user having permission to create a schema could hijack the privileges of a security definer function or extension script (bsc#1211228). - CVE-2023-2455: Fixed an issue that could allow a user to see or modify rows that should have been invisible (bsc#1211229). - Internal fixes (bsc#1210303).

Patch Instructions:

To install this SUSE update use the SUSE recommended installation methods like YaST online_update or "zypper patch".
Alternatively you can run the command listed for your product:

  • openSUSE Leap 15.4
    zypper in -t patch openSUSE-SLE-15.4-2023-2199=1
  • SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2
    zypper in -t patch SUSE-SLE-Product-HPC-15-SP2-LTSS-2023-2199=1
  • SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3
    zypper in -t patch SUSE-SLE-Product-HPC-15-SP3-ESPOS-2023-2199=1
  • SUSE Linux Enterprise High Performance Computing LTSS 15 SP3
    zypper in -t patch SUSE-SLE-Product-HPC-15-SP3-LTSS-2023-2199=1
  • SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2
    zypper in -t patch SUSE-SLE-Product-SLES-15-SP2-LTSS-2023-2199=1
  • SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3
    zypper in -t patch SUSE-SLE-Product-SLES-15-SP3-LTSS-2023-2199=1
  • SUSE Linux Enterprise Server for SAP Applications 15 SP2
    zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP2-2023-2199=1
  • SUSE Linux Enterprise Server for SAP Applications 15 SP3
    zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP3-2023-2199=1
  • SUSE Enterprise Storage 7.1
    zypper in -t patch SUSE-Storage-7.1-2023-2199=1
  • SUSE Enterprise Storage 7
    zypper in -t patch SUSE-Storage-7-2023-2199=1

Package List:

  • openSUSE Leap 15.4 (aarch64 ppc64le s390x x86_64)
    • postgresql12-devel-debuginfo-12.15-150200.8.44.1
    • postgresql12-server-devel-debuginfo-12.15-150200.8.44.1
    • postgresql12-server-devel-12.15-150200.8.44.1
    • postgresql12-plperl-debuginfo-12.15-150200.8.44.1
    • postgresql12-pltcl-12.15-150200.8.44.1
    • postgresql12-debugsource-12.15-150200.8.44.1
    • postgresql12-llvmjit-12.15-150200.8.44.1
    • postgresql12-test-12.15-150200.8.44.1
    • postgresql12-plpython-debuginfo-12.15-150200.8.44.1
    • postgresql12-devel-12.15-150200.8.44.1
    • postgresql12-plpython-12.15-150200.8.44.1
    • postgresql12-contrib-debuginfo-12.15-150200.8.44.1
    • postgresql12-server-12.15-150200.8.44.1
    • postgresql12-server-debuginfo-12.15-150200.8.44.1
    • postgresql12-pltcl-debuginfo-12.15-150200.8.44.1
    • postgresql12-llvmjit-devel-12.15-150200.8.44.1
    • postgresql12-12.15-150200.8.44.1
    • postgresql12-contrib-12.15-150200.8.44.1
    • postgresql12-llvmjit-debuginfo-12.15-150200.8.44.1
    • postgresql12-plperl-12.15-150200.8.44.1
    • postgresql12-debuginfo-12.15-150200.8.44.1
  • openSUSE Leap 15.4 (noarch)
    • postgresql12-docs-12.15-150200.8.44.1
  • SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (aarch64 x86_64)
    • postgresql12-devel-debuginfo-12.15-150200.8.44.1
    • postgresql12-plpython-debuginfo-12.15-150200.8.44.1
    • postgresql12-devel-12.15-150200.8.44.1
    • postgresql12-plpython-12.15-150200.8.44.1
    • postgresql12-12.15-150200.8.44.1
    • postgresql12-contrib-debuginfo-12.15-150200.8.44.1
    • postgresql12-contrib-12.15-150200.8.44.1
    • postgresql12-server-devel-12.15-150200.8.44.1
    • postgresql12-plperl-debuginfo-12.15-150200.8.44.1
    • postgresql12-plperl-12.15-150200.8.44.1
    • postgresql12-server-12.15-150200.8.44.1
    • postgresql12-pltcl-debuginfo-12.15-150200.8.44.1
    • postgresql12-pltcl-12.15-150200.8.44.1
    • postgresql12-server-debuginfo-12.15-150200.8.44.1
    • postgresql12-server-devel-debuginfo-12.15-150200.8.44.1
    • postgresql12-debuginfo-12.15-150200.8.44.1
    • postgresql12-debugsource-12.15-150200.8.44.1
  • SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (noarch)
    • postgresql12-docs-12.15-150200.8.44.1
  • SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 (aarch64 x86_64)
    • postgresql12-devel-debuginfo-12.15-150200.8.44.1
    • postgresql12-plpython-debuginfo-12.15-150200.8.44.1
    • postgresql12-devel-12.15-150200.8.44.1
    • postgresql12-plpython-12.15-150200.8.44.1
    • postgresql12-12.15-150200.8.44.1
    • postgresql12-contrib-debuginfo-12.15-150200.8.44.1
    • postgresql12-contrib-12.15-150200.8.44.1
    • postgresql12-server-devel-12.15-150200.8.44.1
    • postgresql12-plperl-debuginfo-12.15-150200.8.44.1
    • postgresql12-plperl-12.15-150200.8.44.1
    • postgresql12-server-12.15-150200.8.44.1
    • postgresql12-pltcl-debuginfo-12.15-150200.8.44.1
    • postgresql12-pltcl-12.15-150200.8.44.1
    • postgresql12-server-debuginfo-12.15-150200.8.44.1
    • postgresql12-server-devel-debuginfo-12.15-150200.8.44.1
    • postgresql12-debuginfo-12.15-150200.8.44.1
    • postgresql12-debugsource-12.15-150200.8.44.1
  • SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 (noarch)
    • postgresql12-docs-12.15-150200.8.44.1
  • SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (aarch64 x86_64)
    • postgresql12-devel-debuginfo-12.15-150200.8.44.1
    • postgresql12-plpython-debuginfo-12.15-150200.8.44.1
    • postgresql12-devel-12.15-150200.8.44.1
    • postgresql12-plpython-12.15-150200.8.44.1
    • postgresql12-12.15-150200.8.44.1
    • postgresql12-contrib-debuginfo-12.15-150200.8.44.1
    • postgresql12-contrib-12.15-150200.8.44.1
    • postgresql12-server-devel-12.15-150200.8.44.1
    • postgresql12-plperl-debuginfo-12.15-150200.8.44.1
    • postgresql12-plperl-12.15-150200.8.44.1
    • postgresql12-server-12.15-150200.8.44.1
    • postgresql12-pltcl-debuginfo-12.15-150200.8.44.1
    • postgresql12-pltcl-12.15-150200.8.44.1
    • postgresql12-server-debuginfo-12.15-150200.8.44.1
    • postgresql12-server-devel-debuginfo-12.15-150200.8.44.1
    • postgresql12-debuginfo-12.15-150200.8.44.1
    • postgresql12-debugsource-12.15-150200.8.44.1
  • SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (noarch)
    • postgresql12-docs-12.15-150200.8.44.1
  • SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (aarch64 ppc64le s390x x86_64)
    • postgresql12-devel-debuginfo-12.15-150200.8.44.1
    • postgresql12-plpython-debuginfo-12.15-150200.8.44.1
    • postgresql12-devel-12.15-150200.8.44.1
    • postgresql12-plpython-12.15-150200.8.44.1
    • postgresql12-12.15-150200.8.44.1
    • postgresql12-contrib-debuginfo-12.15-150200.8.44.1
    • postgresql12-contrib-12.15-150200.8.44.1
    • postgresql12-server-devel-12.15-150200.8.44.1
    • postgresql12-plperl-debuginfo-12.15-150200.8.44.1
    • postgresql12-plperl-12.15-150200.8.44.1
    • postgresql12-server-12.15-150200.8.44.1
    • postgresql12-pltcl-debuginfo-12.15-150200.8.44.1
    • postgresql12-pltcl-12.15-150200.8.44.1
    • postgresql12-server-debuginfo-12.15-150200.8.44.1
    • postgresql12-server-devel-debuginfo-12.15-150200.8.44.1
    • postgresql12-debuginfo-12.15-150200.8.44.1
    • postgresql12-debugsource-12.15-150200.8.44.1
  • SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (noarch)
    • postgresql12-docs-12.15-150200.8.44.1
  • SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (aarch64 ppc64le s390x x86_64)
    • postgresql12-devel-debuginfo-12.15-150200.8.44.1
    • postgresql12-plpython-debuginfo-12.15-150200.8.44.1
    • postgresql12-devel-12.15-150200.8.44.1
    • postgresql12-plpython-12.15-150200.8.44.1
    • postgresql12-12.15-150200.8.44.1
    • postgresql12-contrib-debuginfo-12.15-150200.8.44.1
    • postgresql12-contrib-12.15-150200.8.44.1
    • postgresql12-server-devel-12.15-150200.8.44.1
    • postgresql12-plperl-debuginfo-12.15-150200.8.44.1
    • postgresql12-plperl-12.15-150200.8.44.1
    • postgresql12-server-12.15-150200.8.44.1
    • postgresql12-pltcl-debuginfo-12.15-150200.8.44.1
    • postgresql12-pltcl-12.15-150200.8.44.1
    • postgresql12-server-debuginfo-12.15-150200.8.44.1
    • postgresql12-server-devel-debuginfo-12.15-150200.8.44.1
    • postgresql12-debuginfo-12.15-150200.8.44.1
    • postgresql12-debugsource-12.15-150200.8.44.1
  • SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (noarch)
    • postgresql12-docs-12.15-150200.8.44.1
  • SUSE Linux Enterprise Server for SAP Applications 15 SP2 (ppc64le x86_64)
    • postgresql12-devel-debuginfo-12.15-150200.8.44.1
    • postgresql12-plpython-debuginfo-12.15-150200.8.44.1
    • postgresql12-devel-12.15-150200.8.44.1
    • postgresql12-plpython-12.15-150200.8.44.1
    • postgresql12-12.15-150200.8.44.1
    • postgresql12-contrib-debuginfo-12.15-150200.8.44.1
    • postgresql12-contrib-12.15-150200.8.44.1
    • postgresql12-server-devel-12.15-150200.8.44.1
    • postgresql12-plperl-debuginfo-12.15-150200.8.44.1
    • postgresql12-plperl-12.15-150200.8.44.1
    • postgresql12-server-12.15-150200.8.44.1
    • postgresql12-pltcl-debuginfo-12.15-150200.8.44.1
    • postgresql12-pltcl-12.15-150200.8.44.1
    • postgresql12-server-debuginfo-12.15-150200.8.44.1
    • postgresql12-server-devel-debuginfo-12.15-150200.8.44.1
    • postgresql12-debuginfo-12.15-150200.8.44.1
    • postgresql12-debugsource-12.15-150200.8.44.1
  • SUSE Linux Enterprise Server for SAP Applications 15 SP2 (noarch)
    • postgresql12-docs-12.15-150200.8.44.1
  • SUSE Linux Enterprise Server for SAP Applications 15 SP3 (ppc64le x86_64)
    • postgresql12-devel-debuginfo-12.15-150200.8.44.1
    • postgresql12-plpython-debuginfo-12.15-150200.8.44.1
    • postgresql12-devel-12.15-150200.8.44.1
    • postgresql12-plpython-12.15-150200.8.44.1
    • postgresql12-12.15-150200.8.44.1
    • postgresql12-contrib-debuginfo-12.15-150200.8.44.1
    • postgresql12-contrib-12.15-150200.8.44.1
    • postgresql12-server-devel-12.15-150200.8.44.1
    • postgresql12-plperl-debuginfo-12.15-150200.8.44.1
    • postgresql12-plperl-12.15-150200.8.44.1
    • postgresql12-server-12.15-150200.8.44.1
    • postgresql12-pltcl-debuginfo-12.15-150200.8.44.1
    • postgresql12-pltcl-12.15-150200.8.44.1
    • postgresql12-server-debuginfo-12.15-150200.8.44.1
    • postgresql12-server-devel-debuginfo-12.15-150200.8.44.1
    • postgresql12-debuginfo-12.15-150200.8.44.1
    • postgresql12-debugsource-12.15-150200.8.44.1
  • SUSE Linux Enterprise Server for SAP Applications 15 SP3 (noarch)
    • postgresql12-docs-12.15-150200.8.44.1
  • SUSE Enterprise Storage 7.1 (aarch64 x86_64)
    • postgresql12-devel-debuginfo-12.15-150200.8.44.1
    • postgresql12-plpython-debuginfo-12.15-150200.8.44.1
    • postgresql12-devel-12.15-150200.8.44.1
    • postgresql12-plpython-12.15-150200.8.44.1
    • postgresql12-12.15-150200.8.44.1
    • postgresql12-contrib-debuginfo-12.15-150200.8.44.1
    • postgresql12-contrib-12.15-150200.8.44.1
    • postgresql12-server-devel-12.15-150200.8.44.1
    • postgresql12-plperl-debuginfo-12.15-150200.8.44.1
    • postgresql12-plperl-12.15-150200.8.44.1
    • postgresql12-server-12.15-150200.8.44.1
    • postgresql12-pltcl-debuginfo-12.15-150200.8.44.1
    • postgresql12-pltcl-12.15-150200.8.44.1
    • postgresql12-server-debuginfo-12.15-150200.8.44.1
    • postgresql12-server-devel-debuginfo-12.15-150200.8.44.1
    • postgresql12-debuginfo-12.15-150200.8.44.1
    • postgresql12-debugsource-12.15-150200.8.44.1
  • SUSE Enterprise Storage 7.1 (noarch)
    • postgresql12-docs-12.15-150200.8.44.1
  • SUSE Enterprise Storage 7 (aarch64 x86_64)
    • postgresql12-devel-debuginfo-12.15-150200.8.44.1
    • postgresql12-plpython-debuginfo-12.15-150200.8.44.1
    • postgresql12-devel-12.15-150200.8.44.1
    • postgresql12-plpython-12.15-150200.8.44.1
    • postgresql12-12.15-150200.8.44.1
    • postgresql12-contrib-debuginfo-12.15-150200.8.44.1
    • postgresql12-contrib-12.15-150200.8.44.1
    • postgresql12-server-devel-12.15-150200.8.44.1
    • postgresql12-plperl-debuginfo-12.15-150200.8.44.1
    • postgresql12-plperl-12.15-150200.8.44.1
    • postgresql12-server-12.15-150200.8.44.1
    • postgresql12-pltcl-debuginfo-12.15-150200.8.44.1
    • postgresql12-pltcl-12.15-150200.8.44.1
    • postgresql12-server-debuginfo-12.15-150200.8.44.1
    • postgresql12-server-devel-debuginfo-12.15-150200.8.44.1
    • postgresql12-debuginfo-12.15-150200.8.44.1
    • postgresql12-debugsource-12.15-150200.8.44.1
  • SUSE Enterprise Storage 7 (noarch)
    • postgresql12-docs-12.15-150200.8.44.1

References: