Unrated severityNVD Advisory· Published Jun 9, 2023· Updated Jan 6, 2025
CVE-2023-2455
CVE-2023-2455
Description
Row security policies disregard user ID changes after inlining; PostgreSQL could permit incorrect policies to be applied in certain cases where role-specific policies are used and a given query is planned under one role and then executed under other roles. This scenario can happen under security definer functions or when a common user and query is planned initially and then re-used across multiple SET ROLEs. Applying an incorrect policy may permit a user to complete otherwise-forbidden reads and modifications. This affects only databases that have used CREATE POLICY to define a row security policy.
Affected products
104- PostgreSQL/PostgreSQLdescription
- osv-coords103 versionspkg:bitnami/postgresqlpkg:rpm/almalinux/pgauditpkg:rpm/almalinux/pg_repackpkg:rpm/almalinux/postgres-decoderbufspkg:rpm/almalinux/postgresqlpkg:rpm/almalinux/postgresql-contribpkg:rpm/almalinux/postgresql-docspkg:rpm/almalinux/postgresql-plperlpkg:rpm/almalinux/postgresql-plpython3pkg:rpm/almalinux/postgresql-pltclpkg:rpm/almalinux/postgresql-private-develpkg:rpm/almalinux/postgresql-private-libspkg:rpm/almalinux/postgresql-serverpkg:rpm/almalinux/postgresql-server-develpkg:rpm/almalinux/postgresql-staticpkg:rpm/almalinux/postgresql-testpkg:rpm/almalinux/postgresql-test-rpm-macrospkg:rpm/almalinux/postgresql-upgradepkg:rpm/almalinux/postgresql-upgrade-develpkg:rpm/opensuse/postgresql11&distro=openSUSE%20Tumbleweedpkg:rpm/opensuse/postgresql12&distro=openSUSE%20Leap%2015.4pkg:rpm/opensuse/postgresql12&distro=openSUSE%20Tumbleweedpkg:rpm/opensuse/postgresql13&distro=openSUSE%20Leap%2015.4pkg:rpm/opensuse/postgresql13&distro=openSUSE%20Tumbleweedpkg:rpm/opensuse/postgresql14&distro=openSUSE%20Leap%2015.4pkg:rpm/opensuse/postgresql14&distro=openSUSE%20Tumbleweedpkg:rpm/opensuse/postgresql15&distro=openSUSE%20Leap%2015.4pkg:rpm/opensuse/postgresql15&distro=openSUSE%20Tumbleweedpkg:rpm/opensuse/postgresql16&distro=openSUSE%20Tumbleweedpkg:rpm/opensuse/postgresql17&distro=openSUSE%20Tumbleweedpkg:rpm/suse/postgresql12&distro=SUSE%20Enterprise%20Storage%207pkg:rpm/suse/postgresql12&distro=SUSE%20Enterprise%20Storage%207.1pkg:rpm/suse/postgresql12&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP1-LTSSpkg:rpm/suse/postgresql12&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP2-LTSSpkg:rpm/suse/postgresql12&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP3-ESPOSpkg:rpm/suse/postgresql12&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP3-LTSSpkg:rpm/suse/postgresql12&distro=SUSE%20Linux%20Enterprise%20Server%2012%20SP5pkg:rpm/suse/postgresql12&distro=SUSE%20Linux%20Enterprise%20Server%2015%20SP1-LTSSpkg:rpm/suse/postgresql12&distro=SUSE%20Linux%20Enterprise%20Server%2015%20SP2-LTSSpkg:rpm/suse/postgresql12&distro=SUSE%20Linux%20Enterprise%20Server%2015%20SP3-LTSSpkg:rpm/suse/postgresql12&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2012%20SP5pkg:rpm/suse/postgresql12&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2015%20SP1pkg:rpm/suse/postgresql12&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2015%20SP2pkg:rpm/suse/postgresql12&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2015%20SP3pkg:rpm/suse/postgresql12&distro=SUSE%20Linux%20Enterprise%20Software%20Development%20Kit%2012%20SP5pkg:rpm/suse/postgresql13&distro=SUSE%20Enterprise%20Storage%207pkg:rpm/suse/postgresql13&distro=SUSE%20Enterprise%20Storage%207.1pkg:rpm/suse/postgresql13&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP2-LTSSpkg:rpm/suse/postgresql13&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP3-ESPOSpkg:rpm/suse/postgresql13&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP3-LTSSpkg:rpm/suse/postgresql13&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Legacy%2015%20SP4pkg:rpm/suse/postgresql13&distro=SUSE%20Linux%20Enterprise%20Real%20Time%2015%20SP3pkg:rpm/suse/postgresql13&distro=SUSE%20Linux%20Enterprise%20Server%2012%20SP5pkg:rpm/suse/postgresql13&distro=SUSE%20Linux%20Enterprise%20Server%2015%20SP2-LTSSpkg:rpm/suse/postgresql13&distro=SUSE%20Linux%20Enterprise%20Server%2015%20SP3-LTSSpkg:rpm/suse/postgresql13&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2012%20SP5pkg:rpm/suse/postgresql13&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2015%20SP2pkg:rpm/suse/postgresql13&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2015%20SP3pkg:rpm/suse/postgresql13&distro=SUSE%20Linux%20Enterprise%20Software%20Development%20Kit%2012%20SP5pkg:rpm/suse/postgresql13&distro=SUSE%20Manager%20Proxy%204.2pkg:rpm/suse/postgresql13&distro=SUSE%20Manager%20Server%204.2pkg:rpm/suse/postgresql14&distro=SUSE%20Enterprise%20Storage%207pkg:rpm/suse/postgresql14&distro=SUSE%20Enterprise%20Storage%207.1pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP2-LTSSpkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP3-ESPOSpkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP3-LTSSpkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Basesystem%2015%20SP4pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Package%20Hub%2015%20SP4pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Server%20Applications%2015%20SP4pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Real%20Time%2015%20SP3pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Server%2012%20SP5pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Server%2015%20SP2-LTSSpkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Server%2015%20SP3-LTSSpkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2012%20SP5pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2015%20SP2pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2015%20SP3pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Software%20Development%20Kit%2012%20SP5pkg:rpm/suse/postgresql14&distro=SUSE%20Manager%20Proxy%204.2pkg:rpm/suse/postgresql14&distro=SUSE%20Manager%20Server%204.2pkg:rpm/suse/postgresql15&distro=SUSE%20Enterprise%20Storage%207pkg:rpm/suse/postgresql15&distro=SUSE%20Enterprise%20Storage%207.1pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP2-LTSSpkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP3-ESPOSpkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP3-LTSSpkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Basesystem%2015%20SP4pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Package%20Hub%2015%20SP4pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Server%20Applications%2015%20SP4pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Real%20Time%2015%20SP3pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Server%2012%20SP2-BCLpkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Server%2012%20SP4-ESPOSpkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Server%2012%20SP4-LTSSpkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Server%2012%20SP5pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Server%2015%20SP2-LTSSpkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Server%2015%20SP3-LTSSpkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2012%20SP4pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2012%20SP5pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2015%20SP2pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2015%20SP3pkg:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Software%20Development%20Kit%2012%20SP5pkg:rpm/suse/postgresql15&distro=SUSE%20Manager%20Proxy%204.2pkg:rpm/suse/postgresql15&distro=SUSE%20Manager%20Server%204.2pkg:rpm/suse/postgresql15&distro=SUSE%20OpenStack%20Cloud%209pkg:rpm/suse/postgresql15&distro=SUSE%20OpenStack%20Cloud%20Crowbar%209
>= 11.0.0, < 11.20.0+ 102 more
- (no CPE)range: >= 11.0.0, < 11.20.0
- (no CPE)range: < 1.7.0-1.module_el9.2.0+22+09653793
- (no CPE)range: < 1.4.8-1.module_el9.2.0+22+09653793
- (no CPE)range: < 1.9.7-1.Final.module_el9.2.0+22+09653793
- (no CPE)range: < 13.11-1.el9_2
- (no CPE)range: < 13.11-1.el9_2
- (no CPE)range: < 13.11-1.el9_2
- (no CPE)range: < 13.11-1.el9_2
- (no CPE)range: < 13.11-1.el9_2
- (no CPE)range: < 13.11-1.el9_2
- (no CPE)range: < 13.11-1.el9_2
- (no CPE)range: < 13.11-1.el9_2
- (no CPE)range: < 13.11-1.el9_2
- (no CPE)range: < 13.11-1.el9_2
- (no CPE)range: < 13.11-1.el9_2
- (no CPE)range: < 13.11-1.el9_2
- (no CPE)range: < 15.3-1.module_el9.2.0+32+f3c125b5
- (no CPE)range: < 13.11-1.el9_2
- (no CPE)range: < 13.11-1.el9_2
- (no CPE)range: < 11.20-1.1
- (no CPE)range: < 12.15-150200.8.44.1
- (no CPE)range: < 12.15-1.1
- (no CPE)range: < 13.11-150200.5.40.1
- (no CPE)range: < 13.11-1.1
- (no CPE)range: < 14.8-150200.5.26.1
- (no CPE)range: < 14.8-1.1
- (no CPE)range: < 15.3-150200.5.9.1
- (no CPE)range: < 15.3-1.1
- (no CPE)range: < 16.4-1.1
- (no CPE)range: < 17.6-2.1
- (no CPE)range: < 12.15-150200.8.44.1
- (no CPE)range: < 12.15-150200.8.44.1
- (no CPE)range: < 12.15-150100.3.41.1
- (no CPE)range: < 12.15-150200.8.44.1
- (no CPE)range: < 12.15-150200.8.44.1
- (no CPE)range: < 12.15-150200.8.44.1
- (no CPE)range: < 12.15-3.39.1
- (no CPE)range: < 12.15-150100.3.41.1
- (no CPE)range: < 12.15-150200.8.44.1
- (no CPE)range: < 12.15-150200.8.44.1
- (no CPE)range: < 12.15-3.39.1
- (no CPE)range: < 12.15-150100.3.41.1
- (no CPE)range: < 12.15-150200.8.44.1
- (no CPE)range: < 12.15-150200.8.44.1
- (no CPE)range: < 12.15-3.39.1
- (no CPE)range: < 13.11-150200.5.40.1
- (no CPE)range: < 13.11-150200.5.40.1
- (no CPE)range: < 13.11-150200.5.40.1
- (no CPE)range: < 13.11-150200.5.40.1
- (no CPE)range: < 13.11-150200.5.40.1
- (no CPE)range: < 13.11-150200.5.40.1
- (no CPE)range: < 13.11-150200.5.40.1
- (no CPE)range: < 13.11-3.33.1
- (no CPE)range: < 13.11-150200.5.40.1
- (no CPE)range: < 13.11-150200.5.40.1
- (no CPE)range: < 13.11-3.33.1
- (no CPE)range: < 13.11-150200.5.40.1
- (no CPE)range: < 13.11-150200.5.40.1
- (no CPE)range: < 13.11-3.33.1
- (no CPE)range: < 13.11-150200.5.40.1
- (no CPE)range: < 13.11-150200.5.40.1
- (no CPE)range: < 14.8-150200.5.26.1
- (no CPE)range: < 14.8-150200.5.26.1
- (no CPE)range: < 14.8-150200.5.26.1
- (no CPE)range: < 14.8-150200.5.26.1
- (no CPE)range: < 14.8-150200.5.26.1
- (no CPE)range: < 14.8-150200.5.26.1
- (no CPE)range: < 14.8-150200.5.26.1
- (no CPE)range: < 14.8-150200.5.26.1
- (no CPE)range: < 14.8-150200.5.26.1
- (no CPE)range: < 14.8-3.23.1
- (no CPE)range: < 14.8-150200.5.26.1
- (no CPE)range: < 14.8-150200.5.26.1
- (no CPE)range: < 14.8-3.23.1
- (no CPE)range: < 14.8-150200.5.26.1
- (no CPE)range: < 14.8-150200.5.26.1
- (no CPE)range: < 14.8-3.23.1
- (no CPE)range: < 14.8-150200.5.26.1
- (no CPE)range: < 14.8-150200.5.26.1
- (no CPE)range: < 15.3-150200.5.9.1
- (no CPE)range: < 15.3-150200.5.9.1
- (no CPE)range: < 15.3-150200.5.9.1
- (no CPE)range: < 15.3-150200.5.9.1
- (no CPE)range: < 15.3-150200.5.9.1
- (no CPE)range: < 15.3-150200.5.9.1
- (no CPE)range: < 15.3-150200.5.9.1
- (no CPE)range: < 15.3-150200.5.9.1
- (no CPE)range: < 15.3-150200.5.9.1
- (no CPE)range: < 15.3-3.9.1
- (no CPE)range: < 15.3-3.9.1
- (no CPE)range: < 15.3-3.9.1
- (no CPE)range: < 15.3-3.9.1
- (no CPE)range: < 15.3-150200.5.9.1
- (no CPE)range: < 15.3-150200.5.9.1
- (no CPE)range: < 15.3-3.9.1
- (no CPE)range: < 15.3-3.9.1
- (no CPE)range: < 15.3-150200.5.9.1
- (no CPE)range: < 15.3-150200.5.9.1
- (no CPE)range: < 15.3-3.9.1
- (no CPE)range: < 15.3-150200.5.9.1
- (no CPE)range: < 15.3-150200.5.9.1
- (no CPE)range: < 15.3-3.9.1
- (no CPE)range: < 15.3-3.9.1
Patches
0No patches discovered yet.
Vulnerability mechanics
AI mechanics synthesis has not run for this CVE yet.
References
3News mentions
0No linked articles in our index yet.