{"id":"SUSE-SU-2023:2205-1","summary":"Security update for postgresql14","details":"This update for postgresql14 fixes the following issues:\n\nUpdated to version 14.8:\n  - CVE-2023-2454: Fixed an issue where a user having permission to\n    create a schema could hijack the privileges of a security definer\n    function or extension script (bsc#1211228).\n  - CVE-2023-2455: Fixed an issue that could allow a user to see or\n    modify rows that should have been invisible (bsc#1211229).\n  - Internal fixes (bsc#1210303).\n","modified":"2026-02-04T04:12:16.998676Z","published":"2023-05-15T11:15:53Z","related":["CVE-2023-2454","CVE-2023-2455"],"upstream":["CVE-2023-2454","CVE-2023-2455"],"references":[{"type":"ADVISORY","url":"https://www.suse.com/support/update/announcement/2023/suse-su-20232205-1/"},{"type":"REPORT","url":"https://bugzilla.suse.com/1210303"},{"type":"REPORT","url":"https://bugzilla.suse.com/1211228"},{"type":"REPORT","url":"https://bugzilla.suse.com/1211229"},{"type":"WEB","url":"https://www.suse.com/security/cve/CVE-2023-2454"},{"type":"WEB","url":"https://www.suse.com/security/cve/CVE-2023-2455"}],"affected":[{"package":{"name":"postgresql14","ecosystem":"SUSE:Linux Enterprise Module for Basesystem 15 SP4","purl":"pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Basesystem%2015%20SP4"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"14.8-150200.5.26.1"}]}],"ecosystem_specific":{"binaries":[{"postgresql14":"14.8-150200.5.26.1"}]},"database_specific":{"source":"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2205-1.json"}},{"package":{"name":"postgresql14","ecosystem":"SUSE:Linux Enterprise Module for Package Hub 15 SP4","purl":"pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Package%20Hub%2015%20SP4"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"14.8-150200.5.26.1"}]}],"ecosystem_specific":{"binaries":[{"postgresql14-llvmjit-devel":"14.8-150200.5.26.1","postgresql14-llvmjit":"14.8-150200.5.26.1","postgresql14-test":"14.8-150200.5.26.1"}]},"database_specific":{"source":"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2205-1.json"}},{"package":{"name":"postgresql14","ecosystem":"SUSE:Linux Enterprise Module for Server Applications 15 SP4","purl":"pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Server%20Applications%2015%20SP4"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"14.8-150200.5.26.1"}]}],"ecosystem_specific":{"binaries":[{"postgresql14-devel":"14.8-150200.5.26.1","postgresql14-docs":"14.8-150200.5.26.1","postgresql14-plperl":"14.8-150200.5.26.1","postgresql14-plpython":"14.8-150200.5.26.1","postgresql14-pltcl":"14.8-150200.5.26.1","postgresql14-server-devel":"14.8-150200.5.26.1","postgresql14-server":"14.8-150200.5.26.1","postgresql14-contrib":"14.8-150200.5.26.1"}]},"database_specific":{"source":"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2205-1.json"}},{"package":{"name":"postgresql14","ecosystem":"SUSE:Linux Enterprise High Performance Computing 15 SP2-LTSS","purl":"pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP2-LTSS"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"14.8-150200.5.26.1"}]}],"ecosystem_specific":{"binaries":[{"postgresql14-devel":"14.8-150200.5.26.1","postgresql14-docs":"14.8-150200.5.26.1","postgresql14-server":"14.8-150200.5.26.1","postgresql14":"14.8-150200.5.26.1","postgresql14-contrib":"14.8-150200.5.26.1","postgresql14-plperl":"14.8-150200.5.26.1","postgresql14-plpython":"14.8-150200.5.26.1","postgresql14-pltcl":"14.8-150200.5.26.1","postgresql14-server-devel":"14.8-150200.5.26.1"}]},"database_specific":{"source":"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2205-1.json"}},{"package":{"name":"postgresql14","ecosystem":"SUSE:Linux Enterprise High Performance Computing 15 SP3-ESPOS","purl":"pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP3-ESPOS"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"14.8-150200.5.26.1"}]}],"ecosystem_specific":{"binaries":[{"postgresql14-pltcl":"14.8-150200.5.26.1","postgresql14-server-devel":"14.8-150200.5.26.1","postgresql14":"14.8-150200.5.26.1","postgresql14-devel":"14.8-150200.5.26.1","postgresql14-server":"14.8-150200.5.26.1","postgresql14-contrib":"14.8-150200.5.26.1","postgresql14-docs":"14.8-150200.5.26.1","postgresql14-plperl":"14.8-150200.5.26.1","postgresql14-plpython":"14.8-150200.5.26.1"}]},"database_specific":{"source":"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2205-1.json"}},{"package":{"name":"postgresql14","ecosystem":"SUSE:Linux Enterprise High Performance Computing 15 SP3-LTSS","purl":"pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP3-LTSS"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"14.8-150200.5.26.1"}]}],"ecosystem_specific":{"binaries":[{"postgresql14-server-devel":"14.8-150200.5.26.1","postgresql14-devel":"14.8-150200.5.26.1","postgresql14-docs":"14.8-150200.5.26.1","postgresql14-plperl":"14.8-150200.5.26.1","postgresql14-plpython":"14.8-150200.5.26.1","postgresql14-server":"14.8-150200.5.26.1","postgresql14":"14.8-150200.5.26.1","postgresql14-contrib":"14.8-150200.5.26.1","postgresql14-pltcl":"14.8-150200.5.26.1"}]},"database_specific":{"source":"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2205-1.json"}},{"package":{"name":"postgresql14","ecosystem":"SUSE:Linux Enterprise Real Time 15 SP3","purl":"pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Real%20Time%2015%20SP3"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"14.8-150200.5.26.1"}]}],"ecosystem_specific":{"binaries":[{"postgresql14":"14.8-150200.5.26.1","postgresql14-contrib":"14.8-150200.5.26.1","postgresql14-plperl":"14.8-150200.5.26.1","postgresql14-server":"14.8-150200.5.26.1","postgresql14-devel":"14.8-150200.5.26.1","postgresql14-docs":"14.8-150200.5.26.1","postgresql14-plpython":"14.8-150200.5.26.1","postgresql14-pltcl":"14.8-150200.5.26.1","postgresql14-server-devel":"14.8-150200.5.26.1"}]},"database_specific":{"source":"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2205-1.json"}},{"package":{"name":"postgresql14","ecosystem":"SUSE:Linux Enterprise Server 15 SP2-LTSS","purl":"pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Server%2015%20SP2-LTSS"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"14.8-150200.5.26.1"}]}],"ecosystem_specific":{"binaries":[{"postgresql14":"14.8-150200.5.26.1","postgresql14-contrib":"14.8-150200.5.26.1","postgresql14-plperl":"14.8-150200.5.26.1","postgresql14-pltcl":"14.8-150200.5.26.1","postgresql14-server-devel":"14.8-150200.5.26.1","postgresql14-server":"14.8-150200.5.26.1","postgresql14-devel":"14.8-150200.5.26.1","postgresql14-docs":"14.8-150200.5.26.1","postgresql14-plpython":"14.8-150200.5.26.1"}]},"database_specific":{"source":"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2205-1.json"}},{"package":{"name":"postgresql14","ecosystem":"SUSE:Linux Enterprise Server 15 SP3-LTSS","purl":"pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Server%2015%20SP3-LTSS"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"14.8-150200.5.26.1"}]}],"ecosystem_specific":{"binaries":[{"postgresql14-pltcl":"14.8-150200.5.26.1","postgresql14-server-devel":"14.8-150200.5.26.1","postgresql14":"14.8-150200.5.26.1","postgresql14-docs":"14.8-150200.5.26.1","postgresql14-plpython":"14.8-150200.5.26.1","postgresql14-server":"14.8-150200.5.26.1","postgresql14-contrib":"14.8-150200.5.26.1","postgresql14-devel":"14.8-150200.5.26.1","postgresql14-plperl":"14.8-150200.5.26.1"}]},"database_specific":{"source":"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2205-1.json"}},{"package":{"name":"postgresql14","ecosystem":"SUSE:Linux Enterprise Server for SAP Applications 15 SP2","purl":"pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2015%20SP2"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"14.8-150200.5.26.1"}]}],"ecosystem_specific":{"binaries":[{"postgresql14-docs":"14.8-150200.5.26.1","postgresql14-plperl":"14.8-150200.5.26.1","postgresql14-plpython":"14.8-150200.5.26.1","postgresql14-pltcl":"14.8-150200.5.26.1","postgresql14-server":"14.8-150200.5.26.1","postgresql14-contrib":"14.8-150200.5.26.1","postgresql14-devel":"14.8-150200.5.26.1","postgresql14-server-devel":"14.8-150200.5.26.1","postgresql14":"14.8-150200.5.26.1"}]},"database_specific":{"source":"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2205-1.json"}},{"package":{"name":"postgresql14","ecosystem":"SUSE:Linux Enterprise Server for SAP Applications 15 SP3","purl":"pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2015%20SP3"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"14.8-150200.5.26.1"}]}],"ecosystem_specific":{"binaries":[{"postgresql14-pltcl":"14.8-150200.5.26.1","postgresql14-server-devel":"14.8-150200.5.26.1","postgresql14-contrib":"14.8-150200.5.26.1","postgresql14-plperl":"14.8-150200.5.26.1","postgresql14-plpython":"14.8-150200.5.26.1","postgresql14-server":"14.8-150200.5.26.1","postgresql14":"14.8-150200.5.26.1","postgresql14-devel":"14.8-150200.5.26.1","postgresql14-docs":"14.8-150200.5.26.1"}]},"database_specific":{"source":"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2205-1.json"}},{"package":{"name":"postgresql14","ecosystem":"SUSE:Manager Proxy 4.2","purl":"pkg:rpm/suse/postgresql14&distro=SUSE%20Manager%20Proxy%204.2"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"14.8-150200.5.26.1"}]}],"ecosystem_specific":{"binaries":[{"postgresql14-pltcl":"14.8-150200.5.26.1","postgresql14-server-devel":"14.8-150200.5.26.1","postgresql14":"14.8-150200.5.26.1","postgresql14-docs":"14.8-150200.5.26.1","postgresql14-plperl":"14.8-150200.5.26.1","postgresql14-server":"14.8-150200.5.26.1","postgresql14-contrib":"14.8-150200.5.26.1","postgresql14-devel":"14.8-150200.5.26.1","postgresql14-plpython":"14.8-150200.5.26.1"}]},"database_specific":{"source":"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2205-1.json"}},{"package":{"name":"postgresql14","ecosystem":"SUSE:Manager Server 4.2","purl":"pkg:rpm/suse/postgresql14&distro=SUSE%20Manager%20Server%204.2"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"14.8-150200.5.26.1"}]}],"ecosystem_specific":{"binaries":[{"postgresql14-contrib":"14.8-150200.5.26.1","postgresql14-docs":"14.8-150200.5.26.1","postgresql14-pltcl":"14.8-150200.5.26.1","postgresql14-server-devel":"14.8-150200.5.26.1","postgresql14-devel":"14.8-150200.5.26.1","postgresql14-plperl":"14.8-150200.5.26.1","postgresql14-plpython":"14.8-150200.5.26.1","postgresql14-server":"14.8-150200.5.26.1","postgresql14":"14.8-150200.5.26.1"}]},"database_specific":{"source":"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2205-1.json"}},{"package":{"name":"postgresql14","ecosystem":"SUSE:Enterprise Storage 7","purl":"pkg:rpm/suse/postgresql14&distro=SUSE%20Enterprise%20Storage%207"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"14.8-150200.5.26.1"}]}],"ecosystem_specific":{"binaries":[{"postgresql14-server":"14.8-150200.5.26.1","postgresql14-devel":"14.8-150200.5.26.1","postgresql14-docs":"14.8-150200.5.26.1","postgresql14":"14.8-150200.5.26.1","postgresql14-contrib":"14.8-150200.5.26.1","postgresql14-plperl":"14.8-150200.5.26.1","postgresql14-plpython":"14.8-150200.5.26.1","postgresql14-pltcl":"14.8-150200.5.26.1","postgresql14-server-devel":"14.8-150200.5.26.1"}]},"database_specific":{"source":"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2205-1.json"}},{"package":{"name":"postgresql14","ecosystem":"SUSE:Enterprise Storage 7.1","purl":"pkg:rpm/suse/postgresql14&distro=SUSE%20Enterprise%20Storage%207.1"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"14.8-150200.5.26.1"}]}],"ecosystem_specific":{"binaries":[{"postgresql14-contrib":"14.8-150200.5.26.1","postgresql14-docs":"14.8-150200.5.26.1","postgresql14-plpython":"14.8-150200.5.26.1","postgresql14-server-devel":"14.8-150200.5.26.1","postgresql14-devel":"14.8-150200.5.26.1","postgresql14-plperl":"14.8-150200.5.26.1","postgresql14-pltcl":"14.8-150200.5.26.1","postgresql14-server":"14.8-150200.5.26.1","postgresql14":"14.8-150200.5.26.1"}]},"database_specific":{"source":"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2205-1.json"}},{"package":{"name":"postgresql14","ecosystem":"openSUSE:Leap 15.4","purl":"pkg:rpm/opensuse/postgresql14&distro=openSUSE%20Leap%2015.4"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"14.8-150200.5.26.1"}]}],"ecosystem_specific":{"binaries":[{"postgresql14-llvmjit":"14.8-150200.5.26.1","postgresql14-plperl":"14.8-150200.5.26.1","postgresql14-plpython":"14.8-150200.5.26.1","postgresql14-pltcl":"14.8-150200.5.26.1","postgresql14-server-devel":"14.8-150200.5.26.1","postgresql14-docs":"14.8-150200.5.26.1","postgresql14-server":"14.8-150200.5.26.1","postgresql14-test":"14.8-150200.5.26.1","postgresql14":"14.8-150200.5.26.1","postgresql14-contrib":"14.8-150200.5.26.1","postgresql14-devel":"14.8-150200.5.26.1","postgresql14-llvmjit-devel":"14.8-150200.5.26.1"}]},"database_specific":{"source":"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:2205-1.json"}}],"schema_version":"1.7.3"}