<div class="container">
<h1>Security update for postgresql12</h1>
<table class="table table-striped table-bordered">
<tbody>
<tr>
<th>Announcement ID:</th>
<td>SUSE-SU-2023:2199-1</td>
</tr>
<tr>
<th>Rating:</th>
<td>important</td>
</tr>
<tr>
<th>References:</th>
<td>
<ul>
<li style="display: inline;">
<a href="https://bugzilla.suse.com/show_bug.cgi?id=1210303">#1210303</a>
</li>
<li style="display: inline;">
<a href="https://bugzilla.suse.com/show_bug.cgi?id=1211228">#1211228</a>
</li>
<li style="display: inline;">
<a href="https://bugzilla.suse.com/show_bug.cgi?id=1211229">#1211229</a>
</li>
</ul>
</td>
</tr>
<tr>
<th>
Cross-References:
</th>
<td>
<ul>
<li style="display: inline;">
<a href="https://www.suse.com/security/cve/CVE-2023-2454.html">CVE-2023-2454</a>
</li>
<li style="display: inline;">
<a href="https://www.suse.com/security/cve/CVE-2023-2455.html">CVE-2023-2455</a>
</li>
</ul>
</td>
</tr>
<tr>
<th>CVSS scores:</th>
<td>
<ul class="list-group">
<li class="list-group-item">
<span class="cvss-reference">CVE-2023-2454</span>
<span class="cvss-source">
(
SUSE
):
</span>
<span class="cvss-score">6.0</span>
<span class="cvss-vector">CVSS:3.1/AV:L/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N</span>
</li>
<li class="list-group-item">
<span class="cvss-reference">CVE-2023-2455</span>
<span class="cvss-source">
(
SUSE
):
</span>
<span class="cvss-score">7.1</span>
<span class="cvss-vector">CVSS:3.1/AV:L/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:N</span>
</li>
</ul>
</td>
</tr>
<tr>
<th>Affected Products:</th>
<td>
<ul class="list-group">
<li class="list-group-item">openSUSE Leap 15.4</li>
<li class="list-group-item">SUSE Enterprise Storage 7</li>
<li class="list-group-item">SUSE Enterprise Storage 7.1</li>
<li class="list-group-item">SUSE Linux Enterprise High Performance Computing 15 SP2</li>
<li class="list-group-item">SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2</li>
<li class="list-group-item">SUSE Linux Enterprise High Performance Computing 15 SP3</li>
<li class="list-group-item">SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3</li>
<li class="list-group-item">SUSE Linux Enterprise High Performance Computing LTSS 15 SP3</li>
<li class="list-group-item">SUSE Linux Enterprise Server 15 SP2</li>
<li class="list-group-item">SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2</li>
<li class="list-group-item">SUSE Linux Enterprise Server 15 SP3</li>
<li class="list-group-item">SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3</li>
<li class="list-group-item">SUSE Linux Enterprise Server for SAP Applications 15 SP2</li>
<li class="list-group-item">SUSE Linux Enterprise Server for SAP Applications 15 SP3</li>
</ul>
</td>
</tr>
</tbody>
</table>
<p>An update that solves two vulnerabilities and has one fix can now be installed.</p>
<h2>Description:</h2>
<p>This update for postgresql12 fixes the following issues:</p>
<p>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).</p>
<h2>Patch Instructions:</h2>
<p>
To install this SUSE Important update use the SUSE recommended
installation methods like YaST online_update or "zypper patch".<br/>
Alternatively you can run the command listed for your product:
</p>
<ul class="list-group">
<li class="list-group-item">
openSUSE Leap 15.4
<br/>
<code>zypper in -t patch openSUSE-SLE-15.4-2023-2199=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2
<br/>
<code>zypper in -t patch SUSE-SLE-Product-HPC-15-SP2-LTSS-2023-2199=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3
<br/>
<code>zypper in -t patch SUSE-SLE-Product-HPC-15-SP3-ESPOS-2023-2199=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise High Performance Computing LTSS 15 SP3
<br/>
<code>zypper in -t patch SUSE-SLE-Product-HPC-15-SP3-LTSS-2023-2199=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2
<br/>
<code>zypper in -t patch SUSE-SLE-Product-SLES-15-SP2-LTSS-2023-2199=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3
<br/>
<code>zypper in -t patch SUSE-SLE-Product-SLES-15-SP3-LTSS-2023-2199=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise Server for SAP Applications 15 SP2
<br/>
<code>zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP2-2023-2199=1</code>
</li>
<li class="list-group-item">
SUSE Linux Enterprise Server for SAP Applications 15 SP3
<br/>
<code>zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP3-2023-2199=1</code>
</li>
<li class="list-group-item">
SUSE Enterprise Storage 7.1
<br/>
<code>zypper in -t patch SUSE-Storage-7.1-2023-2199=1</code>
</li>
<li class="list-group-item">
SUSE Enterprise Storage 7
<br/>
<code>zypper in -t patch SUSE-Storage-7-2023-2199=1</code>
</li>
</ul>
<h2>Package List:</h2>
<ul>
<li>
openSUSE Leap 15.4 (aarch64 ppc64le s390x x86_64)
<ul>
<li>postgresql12-contrib-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-llvmjit-12.15-150200.8.44.1</li>
<li>postgresql12-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-contrib-12.15-150200.8.44.1</li>
<li>postgresql12-plperl-12.15-150200.8.44.1</li>
<li>postgresql12-llvmjit-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plpython-12.15-150200.8.44.1</li>
<li>postgresql12-test-12.15-150200.8.44.1</li>
<li>postgresql12-server-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-server-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plpython-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-12.15-150200.8.44.1</li>
<li>postgresql12-devel-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-llvmjit-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-pltcl-12.15-150200.8.44.1</li>
<li>postgresql12-debugsource-12.15-150200.8.44.1</li>
<li>postgresql12-server-12.15-150200.8.44.1</li>
<li>postgresql12-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plperl-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-pltcl-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-server-devel-debuginfo-12.15-150200.8.44.1</li>
</ul>
</li>
<li>
openSUSE Leap 15.4 (noarch)
<ul>
<li>postgresql12-docs-12.15-150200.8.44.1</li>
</ul>
</li>
<li>
SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (aarch64 x86_64)
<ul>
<li>postgresql12-pltcl-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-contrib-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-12.15-150200.8.44.1</li>
<li>postgresql12-plperl-12.15-150200.8.44.1</li>
<li>postgresql12-devel-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-pltcl-12.15-150200.8.44.1</li>
<li>postgresql12-debugsource-12.15-150200.8.44.1</li>
<li>postgresql12-server-12.15-150200.8.44.1</li>
<li>postgresql12-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plpython-12.15-150200.8.44.1</li>
<li>postgresql12-server-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-plperl-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-server-devel-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-contrib-12.15-150200.8.44.1</li>
<li>postgresql12-server-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plpython-debuginfo-12.15-150200.8.44.1</li>
</ul>
</li>
<li>
SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (noarch)
<ul>
<li>postgresql12-docs-12.15-150200.8.44.1</li>
</ul>
</li>
<li>
SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 (aarch64 x86_64)
<ul>
<li>postgresql12-pltcl-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-contrib-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-12.15-150200.8.44.1</li>
<li>postgresql12-plperl-12.15-150200.8.44.1</li>
<li>postgresql12-devel-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-pltcl-12.15-150200.8.44.1</li>
<li>postgresql12-debugsource-12.15-150200.8.44.1</li>
<li>postgresql12-server-12.15-150200.8.44.1</li>
<li>postgresql12-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plpython-12.15-150200.8.44.1</li>
<li>postgresql12-server-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-plperl-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-server-devel-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-contrib-12.15-150200.8.44.1</li>
<li>postgresql12-server-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plpython-debuginfo-12.15-150200.8.44.1</li>
</ul>
</li>
<li>
SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 (noarch)
<ul>
<li>postgresql12-docs-12.15-150200.8.44.1</li>
</ul>
</li>
<li>
SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (aarch64 x86_64)
<ul>
<li>postgresql12-pltcl-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-contrib-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-12.15-150200.8.44.1</li>
<li>postgresql12-plperl-12.15-150200.8.44.1</li>
<li>postgresql12-devel-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-pltcl-12.15-150200.8.44.1</li>
<li>postgresql12-debugsource-12.15-150200.8.44.1</li>
<li>postgresql12-server-12.15-150200.8.44.1</li>
<li>postgresql12-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plpython-12.15-150200.8.44.1</li>
<li>postgresql12-server-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-plperl-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-server-devel-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-contrib-12.15-150200.8.44.1</li>
<li>postgresql12-server-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plpython-debuginfo-12.15-150200.8.44.1</li>
</ul>
</li>
<li>
SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (noarch)
<ul>
<li>postgresql12-docs-12.15-150200.8.44.1</li>
</ul>
</li>
<li>
SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (aarch64 ppc64le s390x x86_64)
<ul>
<li>postgresql12-pltcl-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-contrib-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-12.15-150200.8.44.1</li>
<li>postgresql12-plperl-12.15-150200.8.44.1</li>
<li>postgresql12-devel-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-pltcl-12.15-150200.8.44.1</li>
<li>postgresql12-debugsource-12.15-150200.8.44.1</li>
<li>postgresql12-server-12.15-150200.8.44.1</li>
<li>postgresql12-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plpython-12.15-150200.8.44.1</li>
<li>postgresql12-server-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-plperl-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-server-devel-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-contrib-12.15-150200.8.44.1</li>
<li>postgresql12-server-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plpython-debuginfo-12.15-150200.8.44.1</li>
</ul>
</li>
<li>
SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (noarch)
<ul>
<li>postgresql12-docs-12.15-150200.8.44.1</li>
</ul>
</li>
<li>
SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (aarch64 ppc64le s390x x86_64)
<ul>
<li>postgresql12-pltcl-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-contrib-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-12.15-150200.8.44.1</li>
<li>postgresql12-plperl-12.15-150200.8.44.1</li>
<li>postgresql12-devel-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-pltcl-12.15-150200.8.44.1</li>
<li>postgresql12-debugsource-12.15-150200.8.44.1</li>
<li>postgresql12-server-12.15-150200.8.44.1</li>
<li>postgresql12-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plpython-12.15-150200.8.44.1</li>
<li>postgresql12-server-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-plperl-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-server-devel-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-contrib-12.15-150200.8.44.1</li>
<li>postgresql12-server-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plpython-debuginfo-12.15-150200.8.44.1</li>
</ul>
</li>
<li>
SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (noarch)
<ul>
<li>postgresql12-docs-12.15-150200.8.44.1</li>
</ul>
</li>
<li>
SUSE Linux Enterprise Server for SAP Applications 15 SP2 (ppc64le x86_64)
<ul>
<li>postgresql12-pltcl-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-contrib-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-12.15-150200.8.44.1</li>
<li>postgresql12-plperl-12.15-150200.8.44.1</li>
<li>postgresql12-devel-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-pltcl-12.15-150200.8.44.1</li>
<li>postgresql12-debugsource-12.15-150200.8.44.1</li>
<li>postgresql12-server-12.15-150200.8.44.1</li>
<li>postgresql12-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plpython-12.15-150200.8.44.1</li>
<li>postgresql12-server-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-plperl-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-server-devel-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-contrib-12.15-150200.8.44.1</li>
<li>postgresql12-server-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plpython-debuginfo-12.15-150200.8.44.1</li>
</ul>
</li>
<li>
SUSE Linux Enterprise Server for SAP Applications 15 SP2 (noarch)
<ul>
<li>postgresql12-docs-12.15-150200.8.44.1</li>
</ul>
</li>
<li>
SUSE Linux Enterprise Server for SAP Applications 15 SP3 (ppc64le x86_64)
<ul>
<li>postgresql12-pltcl-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-contrib-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-12.15-150200.8.44.1</li>
<li>postgresql12-plperl-12.15-150200.8.44.1</li>
<li>postgresql12-devel-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-pltcl-12.15-150200.8.44.1</li>
<li>postgresql12-debugsource-12.15-150200.8.44.1</li>
<li>postgresql12-server-12.15-150200.8.44.1</li>
<li>postgresql12-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plpython-12.15-150200.8.44.1</li>
<li>postgresql12-server-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-plperl-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-server-devel-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-contrib-12.15-150200.8.44.1</li>
<li>postgresql12-server-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plpython-debuginfo-12.15-150200.8.44.1</li>
</ul>
</li>
<li>
SUSE Linux Enterprise Server for SAP Applications 15 SP3 (noarch)
<ul>
<li>postgresql12-docs-12.15-150200.8.44.1</li>
</ul>
</li>
<li>
SUSE Enterprise Storage 7.1 (aarch64 x86_64)
<ul>
<li>postgresql12-pltcl-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-contrib-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-12.15-150200.8.44.1</li>
<li>postgresql12-plperl-12.15-150200.8.44.1</li>
<li>postgresql12-devel-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-pltcl-12.15-150200.8.44.1</li>
<li>postgresql12-debugsource-12.15-150200.8.44.1</li>
<li>postgresql12-server-12.15-150200.8.44.1</li>
<li>postgresql12-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plpython-12.15-150200.8.44.1</li>
<li>postgresql12-server-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-plperl-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-server-devel-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-contrib-12.15-150200.8.44.1</li>
<li>postgresql12-server-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plpython-debuginfo-12.15-150200.8.44.1</li>
</ul>
</li>
<li>
SUSE Enterprise Storage 7.1 (noarch)
<ul>
<li>postgresql12-docs-12.15-150200.8.44.1</li>
</ul>
</li>
<li>
SUSE Enterprise Storage 7 (aarch64 x86_64)
<ul>
<li>postgresql12-pltcl-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-contrib-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-12.15-150200.8.44.1</li>
<li>postgresql12-plperl-12.15-150200.8.44.1</li>
<li>postgresql12-devel-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-pltcl-12.15-150200.8.44.1</li>
<li>postgresql12-debugsource-12.15-150200.8.44.1</li>
<li>postgresql12-server-12.15-150200.8.44.1</li>
<li>postgresql12-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plpython-12.15-150200.8.44.1</li>
<li>postgresql12-server-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-plperl-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-server-devel-debuginfo-12.15-150200.8.44.1</li>
<li>postgresql12-contrib-12.15-150200.8.44.1</li>
<li>postgresql12-server-devel-12.15-150200.8.44.1</li>
<li>postgresql12-plpython-debuginfo-12.15-150200.8.44.1</li>
</ul>
</li>
<li>
SUSE Enterprise Storage 7 (noarch)
<ul>
<li>postgresql12-docs-12.15-150200.8.44.1</li>
</ul>
</li>
</ul>
<h2>References:</h2>
<ul>
<li>
<a href="https://www.suse.com/security/cve/CVE-2023-2454.html">https://www.suse.com/security/cve/CVE-2023-2454.html</a>
</li>
<li>
<a href="https://www.suse.com/security/cve/CVE-2023-2455.html">https://www.suse.com/security/cve/CVE-2023-2455.html</a>
</li>
<li>
<a href="https://bugzilla.suse.com/show_bug.cgi?id=1210303">https://bugzilla.suse.com/show_bug.cgi?id=1210303</a>
</li>
<li>
<a href="https://bugzilla.suse.com/show_bug.cgi?id=1211228">https://bugzilla.suse.com/show_bug.cgi?id=1211228</a>
</li>
<li>
<a href="https://bugzilla.suse.com/show_bug.cgi?id=1211229">https://bugzilla.suse.com/show_bug.cgi?id=1211229</a>
</li>
</ul>
</div>