SUSE-SU-2023:2207-1

Source
https://www.suse.com/support/update/announcement/2023/suse-su-20232207-1/
Import Source
https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2207-1.json
JSON Data
https://api.test.osv.dev/v1/vulns/SUSE-SU-2023:2207-1
Upstream
CVE (2)
Related
Published
2023-05-15T11:21:32Z
Modified
2026-03-11T07:24:00Z
Summary
Security update for postgresql15
Details

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).
References

Affected packages

openSUSE:Leap 15.4
postgresql15

Package

Name
postgresql15
Purl
pkg:rpm/opensuse/postgresql15&distro=openSUSE%20Leap%2015.4

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0 Unknown introduced version / All previous versions are affected
Fixed
15.3-150200.5.9.1

Ecosystem specific

{
    "binaries":  [
        {
            "libecpg6":  "15.3-150200.5.9.1",
            "libecpg6-32bit":  "15.3-150200.5.9.1",
            "libpq5":  "15.3-150200.5.9.1",
            "libpq5-32bit":  "15.3-150200.5.9.1",
            "postgresql15":  "15.3-150200.5.9.1",
            "postgresql15-contrib":  "15.3-150200.5.9.1",
            "postgresql15-devel":  "15.3-150200.5.9.1",
            "postgresql15-docs":  "15.3-150200.5.9.1",
            "postgresql15-llvmjit":  "15.3-150200.5.9.1",
            "postgresql15-llvmjit-devel":  "15.3-150200.5.9.1",
            "postgresql15-plperl":  "15.3-150200.5.9.1",
            "postgresql15-plpython":  "15.3-150200.5.9.1",
            "postgresql15-pltcl":  "15.3-150200.5.9.1",
            "postgresql15-server":  "15.3-150200.5.9.1",
            "postgresql15-server-devel":  "15.3-150200.5.9.1",
            "postgresql15-test":  "15.3-150200.5.9.1"
        }
    ]
}

Database specific

source
"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2207-1.json"
SUSE:Enterprise Storage 7
postgresql15

Package

Name
postgresql15
Purl
pkg:rpm/suse/postgresql15&distro=SUSE%20Enterprise%20Storage%207

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0 Unknown introduced version / All previous versions are affected
Fixed
15.3-150200.5.9.1

Ecosystem specific

{
    "binaries":  [
        {
            "libecpg6":  "15.3-150200.5.9.1",
            "libpq5":  "15.3-150200.5.9.1",
            "libpq5-32bit":  "15.3-150200.5.9.1"
        }
    ]
}

Database specific

source
"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2207-1.json"
SUSE:Enterprise Storage 7.1
postgresql15

Package

Name
postgresql15
Purl
pkg:rpm/suse/postgresql15&distro=SUSE%20Enterprise%20Storage%207.1

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0 Unknown introduced version / All previous versions are affected
Fixed
15.3-150200.5.9.1

Ecosystem specific

{
    "binaries":  [
        {
            "libecpg6":  "15.3-150200.5.9.1",
            "libpq5":  "15.3-150200.5.9.1",
            "postgresql15":  "15.3-150200.5.9.1",
            "postgresql15-contrib":  "15.3-150200.5.9.1",
            "postgresql15-devel":  "15.3-150200.5.9.1",
            "postgresql15-docs":  "15.3-150200.5.9.1",
            "postgresql15-plperl":  "15.3-150200.5.9.1",
            "postgresql15-plpython":  "15.3-150200.5.9.1",
            "postgresql15-pltcl":  "15.3-150200.5.9.1",
            "postgresql15-server":  "15.3-150200.5.9.1",
            "postgresql15-server-devel":  "15.3-150200.5.9.1"
        }
    ]
}

Database specific

source
"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2207-1.json"
SUSE:Linux Enterprise High Performance Computing 15 SP2-LTSS
postgresql15

Package

Name
postgresql15
Purl
pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP2-LTSS

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0 Unknown introduced version / All previous versions are affected
Fixed
15.3-150200.5.9.1

Ecosystem specific

{
    "binaries":  [
        {
            "libecpg6":  "15.3-150200.5.9.1",
            "libpq5":  "15.3-150200.5.9.1",
            "libpq5-32bit":  "15.3-150200.5.9.1"
        }
    ]
}

Database specific

source
"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2207-1.json"
SUSE:Linux Enterprise High Performance Computing 15 SP3-ESPOS
postgresql15

Package

Name
postgresql15
Purl
pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP3-ESPOS

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0 Unknown introduced version / All previous versions are affected
Fixed
15.3-150200.5.9.1

Ecosystem specific

{
    "binaries":  [
        {
            "libecpg6":  "15.3-150200.5.9.1",
            "libpq5":  "15.3-150200.5.9.1",
            "postgresql15":  "15.3-150200.5.9.1",
            "postgresql15-contrib":  "15.3-150200.5.9.1",
            "postgresql15-devel":  "15.3-150200.5.9.1",
            "postgresql15-docs":  "15.3-150200.5.9.1",
            "postgresql15-plperl":  "15.3-150200.5.9.1",
            "postgresql15-plpython":  "15.3-150200.5.9.1",
            "postgresql15-pltcl":  "15.3-150200.5.9.1",
            "postgresql15-server":  "15.3-150200.5.9.1",
            "postgresql15-server-devel":  "15.3-150200.5.9.1"
        }
    ]
}

Database specific

source
"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2207-1.json"
SUSE:Linux Enterprise High Performance Computing 15 SP3-LTSS
postgresql15

Package

Name
postgresql15
Purl
pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP3-LTSS

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0 Unknown introduced version / All previous versions are affected
Fixed
15.3-150200.5.9.1

Ecosystem specific

{
    "binaries":  [
        {
            "libecpg6":  "15.3-150200.5.9.1",
            "libpq5":  "15.3-150200.5.9.1",
            "postgresql15":  "15.3-150200.5.9.1",
            "postgresql15-contrib":  "15.3-150200.5.9.1",
            "postgresql15-devel":  "15.3-150200.5.9.1",
            "postgresql15-docs":  "15.3-150200.5.9.1",
            "postgresql15-plperl":  "15.3-150200.5.9.1",
            "postgresql15-plpython":  "15.3-150200.5.9.1",
            "postgresql15-pltcl":  "15.3-150200.5.9.1",
            "postgresql15-server":  "15.3-150200.5.9.1",
            "postgresql15-server-devel":  "15.3-150200.5.9.1"
        }
    ]
}

Database specific

source
"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2207-1.json"
SUSE:Linux Enterprise Module for Basesystem 15 SP4
postgresql15

Package

Name
postgresql15
Purl
pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Basesystem%2015%20SP4

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0 Unknown introduced version / All previous versions are affected
Fixed
15.3-150200.5.9.1

Ecosystem specific

{
    "binaries":  [
        {
            "libpq5":  "15.3-150200.5.9.1",
            "postgresql15":  "15.3-150200.5.9.1"
        }
    ]
}

Database specific

source
"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2207-1.json"
SUSE:Linux Enterprise Module for Package Hub 15 SP4
postgresql15

Package

Name
postgresql15
Purl
pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Package%20Hub%2015%20SP4

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0 Unknown introduced version / All previous versions are affected
Fixed
15.3-150200.5.9.1

Ecosystem specific

{
    "binaries":  [
        {
            "postgresql15-llvmjit":  "15.3-150200.5.9.1",
            "postgresql15-llvmjit-devel":  "15.3-150200.5.9.1",
            "postgresql15-test":  "15.3-150200.5.9.1"
        }
    ]
}

Database specific

source
"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2207-1.json"
SUSE:Linux Enterprise Module for Server Applications 15 SP4
postgresql15

Package

Name
postgresql15
Purl
pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Server%20Applications%2015%20SP4

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0 Unknown introduced version / All previous versions are affected
Fixed
15.3-150200.5.9.1

Ecosystem specific

{
    "binaries":  [
        {
            "libecpg6":  "15.3-150200.5.9.1",
            "postgresql15":  "15.3-150200.5.9.1",
            "postgresql15-contrib":  "15.3-150200.5.9.1",
            "postgresql15-devel":  "15.3-150200.5.9.1",
            "postgresql15-docs":  "15.3-150200.5.9.1",
            "postgresql15-plperl":  "15.3-150200.5.9.1",
            "postgresql15-plpython":  "15.3-150200.5.9.1",
            "postgresql15-pltcl":  "15.3-150200.5.9.1",
            "postgresql15-server":  "15.3-150200.5.9.1",
            "postgresql15-server-devel":  "15.3-150200.5.9.1"
        }
    ]
}

Database specific

source
"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2207-1.json"
SUSE:Linux Enterprise Real Time 15 SP3
postgresql15

Package

Name
postgresql15
Purl
pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Real%20Time%2015%20SP3

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0 Unknown introduced version / All previous versions are affected
Fixed
15.3-150200.5.9.1

Ecosystem specific

{
    "binaries":  [
        {
            "libecpg6":  "15.3-150200.5.9.1",
            "libpq5":  "15.3-150200.5.9.1",
            "postgresql15":  "15.3-150200.5.9.1",
            "postgresql15-contrib":  "15.3-150200.5.9.1",
            "postgresql15-devel":  "15.3-150200.5.9.1",
            "postgresql15-docs":  "15.3-150200.5.9.1",
            "postgresql15-plperl":  "15.3-150200.5.9.1",
            "postgresql15-plpython":  "15.3-150200.5.9.1",
            "postgresql15-pltcl":  "15.3-150200.5.9.1",
            "postgresql15-server":  "15.3-150200.5.9.1",
            "postgresql15-server-devel":  "15.3-150200.5.9.1"
        }
    ]
}

Database specific

source
"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2207-1.json"
SUSE:Linux Enterprise Server 15 SP2-LTSS
postgresql15

Package

Name
postgresql15
Purl
pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Server%2015%20SP2-LTSS

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0 Unknown introduced version / All previous versions are affected
Fixed
15.3-150200.5.9.1

Ecosystem specific

{
    "binaries":  [
        {
            "libecpg6":  "15.3-150200.5.9.1",
            "libpq5":  "15.3-150200.5.9.1",
            "libpq5-32bit":  "15.3-150200.5.9.1"
        }
    ]
}

Database specific

source
"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2207-1.json"
SUSE:Linux Enterprise Server 15 SP3-LTSS
postgresql15

Package

Name
postgresql15
Purl
pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Server%2015%20SP3-LTSS

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0 Unknown introduced version / All previous versions are affected
Fixed
15.3-150200.5.9.1

Ecosystem specific

{
    "binaries":  [
        {
            "libecpg6":  "15.3-150200.5.9.1",
            "libpq5":  "15.3-150200.5.9.1",
            "postgresql15":  "15.3-150200.5.9.1",
            "postgresql15-contrib":  "15.3-150200.5.9.1",
            "postgresql15-devel":  "15.3-150200.5.9.1",
            "postgresql15-docs":  "15.3-150200.5.9.1",
            "postgresql15-plperl":  "15.3-150200.5.9.1",
            "postgresql15-plpython":  "15.3-150200.5.9.1",
            "postgresql15-pltcl":  "15.3-150200.5.9.1",
            "postgresql15-server":  "15.3-150200.5.9.1",
            "postgresql15-server-devel":  "15.3-150200.5.9.1"
        }
    ]
}

Database specific

source
"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2207-1.json"
SUSE:Linux Enterprise Server for SAP Applications 15 SP2
postgresql15

Package

Name
postgresql15
Purl
pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2015%20SP2

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0 Unknown introduced version / All previous versions are affected
Fixed
15.3-150200.5.9.1

Ecosystem specific

{
    "binaries":  [
        {
            "libecpg6":  "15.3-150200.5.9.1",
            "libpq5":  "15.3-150200.5.9.1",
            "libpq5-32bit":  "15.3-150200.5.9.1"
        }
    ]
}

Database specific

source
"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2207-1.json"
SUSE:Linux Enterprise Server for SAP Applications 15 SP3
postgresql15

Package

Name
postgresql15
Purl
pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2015%20SP3

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0 Unknown introduced version / All previous versions are affected
Fixed
15.3-150200.5.9.1

Ecosystem specific

{
    "binaries":  [
        {
            "libecpg6":  "15.3-150200.5.9.1",
            "libpq5":  "15.3-150200.5.9.1",
            "postgresql15":  "15.3-150200.5.9.1",
            "postgresql15-contrib":  "15.3-150200.5.9.1",
            "postgresql15-devel":  "15.3-150200.5.9.1",
            "postgresql15-docs":  "15.3-150200.5.9.1",
            "postgresql15-plperl":  "15.3-150200.5.9.1",
            "postgresql15-plpython":  "15.3-150200.5.9.1",
            "postgresql15-pltcl":  "15.3-150200.5.9.1",
            "postgresql15-server":  "15.3-150200.5.9.1",
            "postgresql15-server-devel":  "15.3-150200.5.9.1"
        }
    ]
}

Database specific

source
"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2207-1.json"
SUSE:Manager Proxy 4.2
postgresql15

Package

Name
postgresql15
Purl
pkg:rpm/suse/postgresql15&distro=SUSE%20Manager%20Proxy%204.2

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0 Unknown introduced version / All previous versions are affected
Fixed
15.3-150200.5.9.1

Ecosystem specific

{
    "binaries":  [
        {
            "libecpg6":  "15.3-150200.5.9.1",
            "libpq5":  "15.3-150200.5.9.1",
            "postgresql15":  "15.3-150200.5.9.1",
            "postgresql15-contrib":  "15.3-150200.5.9.1",
            "postgresql15-devel":  "15.3-150200.5.9.1",
            "postgresql15-docs":  "15.3-150200.5.9.1",
            "postgresql15-plperl":  "15.3-150200.5.9.1",
            "postgresql15-plpython":  "15.3-150200.5.9.1",
            "postgresql15-pltcl":  "15.3-150200.5.9.1",
            "postgresql15-server":  "15.3-150200.5.9.1",
            "postgresql15-server-devel":  "15.3-150200.5.9.1"
        }
    ]
}

Database specific

source
"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2207-1.json"
SUSE:Manager Server 4.2
postgresql15

Package

Name
postgresql15
Purl
pkg:rpm/suse/postgresql15&distro=SUSE%20Manager%20Server%204.2

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0 Unknown introduced version / All previous versions are affected
Fixed
15.3-150200.5.9.1

Ecosystem specific

{
    "binaries":  [
        {
            "libecpg6":  "15.3-150200.5.9.1",
            "libpq5":  "15.3-150200.5.9.1",
            "postgresql15":  "15.3-150200.5.9.1",
            "postgresql15-contrib":  "15.3-150200.5.9.1",
            "postgresql15-devel":  "15.3-150200.5.9.1",
            "postgresql15-docs":  "15.3-150200.5.9.1",
            "postgresql15-plperl":  "15.3-150200.5.9.1",
            "postgresql15-plpython":  "15.3-150200.5.9.1",
            "postgresql15-pltcl":  "15.3-150200.5.9.1",
            "postgresql15-server":  "15.3-150200.5.9.1",
            "postgresql15-server-devel":  "15.3-150200.5.9.1"
        }
    ]
}

Database specific

source
"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2207-1.json"