Security update for postgresql15

Announcement ID:	SUSE-SU-2023:2206-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:	SUSE Linux Enterprise High Performance Computing 12 SP2 SUSE Linux Enterprise High Performance Computing 12 SP4 SUSE Linux Enterprise High Performance Computing 12 SP5 SUSE Linux Enterprise Server 12 SP2 SUSE Linux Enterprise Server 12 SP2 BCL 12-SP2 SUSE Linux Enterprise Server 12 SP4 SUSE Linux Enterprise Server 12 SP4 ESPOS 12-SP4 SUSE Linux Enterprise Server 12 SP4 LTSS 12-SP4 SUSE Linux Enterprise Server 12 SP5 SUSE Linux Enterprise Server for SAP Applications 12 SP4 SUSE Linux Enterprise Server for SAP Applications 12 SP5 SUSE Linux Enterprise Software Development Kit 12 SP5 SUSE OpenStack Cloud 9 SUSE OpenStack Cloud Crowbar 9

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

Description:

This update for postgresql15 fixes the following issues:

Updated to version 15.3: - 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:

• SUSE OpenStack Cloud 9
  zypper in -t patch SUSE-OpenStack-Cloud-9-2023-2206=1
• SUSE OpenStack Cloud Crowbar 9
  zypper in -t patch SUSE-OpenStack-Cloud-Crowbar-9-2023-2206=1
• SUSE Linux Enterprise Server for SAP Applications 12 SP4
  zypper in -t patch SUSE-SLE-SAP-12-SP4-2023-2206=1
• SUSE Linux Enterprise Software Development Kit 12 SP5
  zypper in -t patch SUSE-SLE-SDK-12-SP5-2023-2206=1
• SUSE Linux Enterprise Server 12 SP2 BCL 12-SP2
  zypper in -t patch SUSE-SLE-SERVER-12-SP2-BCL-2023-2206=1
• SUSE Linux Enterprise Server 12 SP4 ESPOS 12-SP4
  zypper in -t patch SUSE-SLE-SERVER-12-SP4-ESPOS-2023-2206=1
• SUSE Linux Enterprise Server 12 SP4 LTSS 12-SP4
  zypper in -t patch SUSE-SLE-SERVER-12-SP4-LTSS-2023-2206=1
• SUSE Linux Enterprise High Performance Computing 12 SP5
  zypper in -t patch SUSE-SLE-SERVER-12-SP5-2023-2206=1
• SUSE Linux Enterprise Server 12 SP5
  zypper in -t patch SUSE-SLE-SERVER-12-SP5-2023-2206=1
• SUSE Linux Enterprise Server for SAP Applications 12 SP5
  zypper in -t patch SUSE-SLE-SERVER-12-SP5-2023-2206=1

Package List:

• SUSE OpenStack Cloud 9 (x86_64)
  • libpq5-15.3-3.9.1
  • libpq5-debuginfo-32bit-15.3-3.9.1
  • libpq5-debuginfo-15.3-3.9.1
  • libecpg6-15.3-3.9.1
  • libecpg6-debuginfo-15.3-3.9.1
  • libpq5-32bit-15.3-3.9.1
• SUSE OpenStack Cloud Crowbar 9 (x86_64)
  • libpq5-15.3-3.9.1
  • libpq5-debuginfo-32bit-15.3-3.9.1
  • libpq5-debuginfo-15.3-3.9.1
  • libecpg6-15.3-3.9.1
  • libecpg6-debuginfo-15.3-3.9.1
  • libpq5-32bit-15.3-3.9.1
• SUSE Linux Enterprise Server for SAP Applications 12 SP4 (ppc64le x86_64)
  • libecpg6-debuginfo-15.3-3.9.1
  • libpq5-debuginfo-15.3-3.9.1
  • libpq5-15.3-3.9.1
  • libecpg6-15.3-3.9.1
• SUSE Linux Enterprise Server for SAP Applications 12 SP4 (x86_64)
  • libpq5-debuginfo-32bit-15.3-3.9.1
  • libpq5-32bit-15.3-3.9.1
• SUSE Linux Enterprise Software Development Kit 12 SP5 (aarch64 ppc64le s390x x86_64)
  • postgresql15-devel-debuginfo-15.3-3.9.1
  • postgresql15-server-devel-15.3-3.9.1
  • postgresql15-server-devel-debuginfo-15.3-3.9.1
  • postgresql15-devel-15.3-3.9.1
• SUSE Linux Enterprise Server 12 SP2 BCL 12-SP2 (x86_64)
  • libpq5-15.3-3.9.1
  • libpq5-debuginfo-32bit-15.3-3.9.1
  • libpq5-debuginfo-15.3-3.9.1
  • libecpg6-15.3-3.9.1
  • libecpg6-debuginfo-15.3-3.9.1
  • libpq5-32bit-15.3-3.9.1
• SUSE Linux Enterprise Server 12 SP4 ESPOS 12-SP4 (aarch64 x86_64)
  • libecpg6-debuginfo-15.3-3.9.1
  • libpq5-debuginfo-15.3-3.9.1
  • libpq5-15.3-3.9.1
  • libecpg6-15.3-3.9.1
• SUSE Linux Enterprise Server 12 SP4 ESPOS 12-SP4 (x86_64)
  • libpq5-debuginfo-32bit-15.3-3.9.1
  • libpq5-32bit-15.3-3.9.1
• SUSE Linux Enterprise Server 12 SP4 LTSS 12-SP4 (aarch64 ppc64le s390x x86_64)
  • libecpg6-debuginfo-15.3-3.9.1
  • libpq5-debuginfo-15.3-3.9.1
  • libpq5-15.3-3.9.1
  • libecpg6-15.3-3.9.1
• SUSE Linux Enterprise Server 12 SP4 LTSS 12-SP4 (s390x x86_64)
  • libpq5-debuginfo-32bit-15.3-3.9.1
  • libpq5-32bit-15.3-3.9.1
• SUSE Linux Enterprise High Performance Computing 12 SP5 (aarch64 x86_64)
  • postgresql15-contrib-15.3-3.9.1
  • libpq5-15.3-3.9.1
  • postgresql15-plperl-15.3-3.9.1
  • postgresql15-debugsource-15.3-3.9.1
  • postgresql15-pltcl-debuginfo-15.3-3.9.1
  • postgresql15-15.3-3.9.1
  • postgresql15-contrib-debuginfo-15.3-3.9.1
  • postgresql15-plpython-debuginfo-15.3-3.9.1
  • postgresql15-server-15.3-3.9.1
  • libpq5-debuginfo-15.3-3.9.1
  • postgresql15-server-debuginfo-15.3-3.9.1
  • libecpg6-15.3-3.9.1
  • libecpg6-debuginfo-15.3-3.9.1
  • postgresql15-pltcl-15.3-3.9.1
  • postgresql15-debuginfo-15.3-3.9.1
  • postgresql15-plperl-debuginfo-15.3-3.9.1
  • postgresql15-plpython-15.3-3.9.1
• SUSE Linux Enterprise High Performance Computing 12 SP5 (noarch)
  • postgresql15-docs-15.3-3.9.1
• SUSE Linux Enterprise High Performance Computing 12 SP5 (x86_64)
  • libpq5-debuginfo-32bit-15.3-3.9.1
  • libecpg6-32bit-15.3-3.9.1
  • libecpg6-debuginfo-32bit-15.3-3.9.1
  • libpq5-32bit-15.3-3.9.1
• SUSE Linux Enterprise Server 12 SP5 (aarch64 ppc64le s390x x86_64)
  • postgresql15-contrib-15.3-3.9.1
  • libpq5-15.3-3.9.1
  • postgresql15-plperl-15.3-3.9.1
  • postgresql15-debugsource-15.3-3.9.1
  • postgresql15-pltcl-debuginfo-15.3-3.9.1
  • postgresql15-15.3-3.9.1
  • postgresql15-contrib-debuginfo-15.3-3.9.1
  • postgresql15-plpython-debuginfo-15.3-3.9.1
  • postgresql15-server-15.3-3.9.1
  • libpq5-debuginfo-15.3-3.9.1
  • postgresql15-server-debuginfo-15.3-3.9.1
  • libecpg6-15.3-3.9.1
  • libecpg6-debuginfo-15.3-3.9.1
  • postgresql15-pltcl-15.3-3.9.1
  • postgresql15-debuginfo-15.3-3.9.1
  • postgresql15-plperl-debuginfo-15.3-3.9.1
  • postgresql15-plpython-15.3-3.9.1
• SUSE Linux Enterprise Server 12 SP5 (noarch)
  • postgresql15-docs-15.3-3.9.1
• SUSE Linux Enterprise Server 12 SP5 (s390x x86_64)
  • libpq5-debuginfo-32bit-15.3-3.9.1
  • libecpg6-32bit-15.3-3.9.1
  • libecpg6-debuginfo-32bit-15.3-3.9.1
  • libpq5-32bit-15.3-3.9.1
• SUSE Linux Enterprise Server for SAP Applications 12 SP5 (ppc64le x86_64)
  • postgresql15-contrib-15.3-3.9.1
  • libpq5-15.3-3.9.1
  • postgresql15-plperl-15.3-3.9.1
  • postgresql15-debugsource-15.3-3.9.1
  • postgresql15-pltcl-debuginfo-15.3-3.9.1
  • postgresql15-15.3-3.9.1
  • postgresql15-contrib-debuginfo-15.3-3.9.1
  • postgresql15-plpython-debuginfo-15.3-3.9.1
  • postgresql15-server-15.3-3.9.1
  • libpq5-debuginfo-15.3-3.9.1
  • postgresql15-server-debuginfo-15.3-3.9.1
  • libecpg6-15.3-3.9.1
  • libecpg6-debuginfo-15.3-3.9.1
  • postgresql15-pltcl-15.3-3.9.1
  • postgresql15-debuginfo-15.3-3.9.1
  • postgresql15-plperl-debuginfo-15.3-3.9.1
  • postgresql15-plpython-15.3-3.9.1
• SUSE Linux Enterprise Server for SAP Applications 12 SP5 (noarch)
  • postgresql15-docs-15.3-3.9.1
• SUSE Linux Enterprise Server for SAP Applications 12 SP5 (x86_64)
  • libpq5-debuginfo-32bit-15.3-3.9.1
  • libecpg6-32bit-15.3-3.9.1
  • libecpg6-debuginfo-32bit-15.3-3.9.1
  • libpq5-32bit-15.3-3.9.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