Security update for postgresql12

Announcement ID:	SUSE-SU-2023:2199-1
Rating:	important
References:	bsc#1210303 bsc#1211228 bsc#1211229
Cross-References:	CVE-2023-2454 CVE-2023-2455
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:

• https://www.suse.com/security/cve/CVE-2023-2454.html
• https://www.suse.com/security/cve/CVE-2023-2455.html
• https://bugzilla.suse.com/show_bug.cgi?id=1210303
• https://bugzilla.suse.com/show_bug.cgi?id=1211228
• https://bugzilla.suse.com/show_bug.cgi?id=1211229