{"id":"UBUNTU-CVE-2023-2455","details":"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.","modified":"2026-04-22T14:03:30.968500Z","published":"2023-05-12T00:00:00Z","related":["USN-6104-1"],"upstream":["CVE-2023-2455"],"references":[{"type":"REPORT","url":"https://ubuntu.com/security/CVE-2023-2455"},{"type":"REPORT","url":"https://www.postgresql.org/about/news/postgresql-153-148-1311-1215-and-1120-released-2637/"},{"type":"ADVISORY","url":"https://ubuntu.com/security/notices/USN-6104-1"},{"type":"REPORT","url":"https://www.cve.org/CVERecord?id=CVE-2023-2455"}],"affected":[{"package":{"name":"postgresql-9.3","ecosystem":"Ubuntu:Pro:14.04:LTS","purl":"pkg:deb/ubuntu/postgresql-9.3@9.3.24-0ubuntu0.14.04+esm1?arch=source&distro=esm-infra-legacy/trusty"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["9.3.1-1","9.3.2-1","9.3.2-1ubuntu1","9.3.2-1ubuntu2","9.3.3-1","9.3.3-1bzr1","9.3.3-1bzr2","9.3.4-1","9.3.5-0ubuntu0.14.04.1","9.3.6-0ubuntu0.14.04","9.3.7-0ubuntu0.14.04","9.3.8-0ubuntu0.4.04","9.3.9-0ubuntu0.14.04","9.3.10-0ubuntu0.14.04","9.3.11-0ubuntu0.14.04","9.3.12-0ubuntu0.14.04","9.3.13-0ubuntu0.14.04","9.3.14-0ubuntu0.14.04","9.3.15-0ubuntu0.14.04","9.3.16-0ubuntu0.14.04","9.3.17-0ubuntu0.14.04","9.3.18-0ubuntu0.14.04.1","9.3.19-0ubuntu0.14.04","9.3.20-0ubuntu0.14.04","9.3.21-0ubuntu0.14.04","9.3.22-0ubuntu0.14.04","9.3.23-0ubuntu0.14.04","9.3.24-0ubuntu0.14.04","9.3.24-0ubuntu0.14.04+esm1"],"ecosystem_specific":{"binaries":[{"binary_name":"libecpg-compat3","binary_version":"9.3.24-0ubuntu0.14.04+esm1"},{"binary_name":"libecpg6","binary_version":"9.3.24-0ubuntu0.14.04+esm1"},{"binary_name":"libpgtypes3","binary_version":"9.3.24-0ubuntu0.14.04+esm1"},{"binary_name":"libpq5","binary_version":"9.3.24-0ubuntu0.14.04+esm1"},{"binary_name":"postgresql-9.3","binary_version":"9.3.24-0ubuntu0.14.04+esm1"},{"binary_name":"postgresql-client-9.3","binary_version":"9.3.24-0ubuntu0.14.04+esm1"},{"binary_name":"postgresql-contrib-9.3","binary_version":"9.3.24-0ubuntu0.14.04+esm1"},{"binary_name":"postgresql-doc-9.3","binary_version":"9.3.24-0ubuntu0.14.04+esm1"},{"binary_name":"postgresql-plperl-9.3","binary_version":"9.3.24-0ubuntu0.14.04+esm1"},{"binary_name":"postgresql-plpython-9.3","binary_version":"9.3.24-0ubuntu0.14.04+esm1"},{"binary_name":"postgresql-plpython3-9.3","binary_version":"9.3.24-0ubuntu0.14.04+esm1"},{"binary_name":"postgresql-pltcl-9.3","binary_version":"9.3.24-0ubuntu0.14.04+esm1"},{"binary_version":"9.3.24-0ubuntu0.14.04+esm1","binary_name":"postgresql-server-dev-9.3"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2023/UBUNTU-CVE-2023-2455.json"}},{"package":{"name":"postgresql-9.5","ecosystem":"Ubuntu:Pro:16.04:LTS","purl":"pkg:deb/ubuntu/postgresql-9.5@9.5.25-0ubuntu0.16.04.1+esm10?arch=source&distro=esm-infra/xenial"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["9.5.0-1","9.5.0-2","9.5.0-3","9.5.1-1","9.5.2-1","9.5.3-0ubuntu0.16.04","9.5.4-0ubuntu0.16.04","9.5.5-0ubuntu0.16.04","9.5.6-0ubuntu0.16.04","9.5.7-0ubuntu0.16.04","9.5.8-0ubuntu0.16.04.1","9.5.9-0ubuntu0.16.04","9.5.10-0ubuntu0.16.04","9.5.11-0ubuntu0.16.04","9.5.12-0ubuntu0.16.04","9.5.13-0ubuntu0.16.04","9.5.14-0ubuntu0.16.04","9.5.16-0ubuntu0.16.04.1","9.5.17-0ubuntu0.16.04.1","9.5.18-0ubuntu0.16.04.1","9.5.19-0ubuntu0.16.04.1","9.5.21-0ubuntu0.16.04.1","9.5.23-0ubuntu0.16.04.1","9.5.24-0ubuntu0.16.04.1","9.5.25-0ubuntu0.16.04.1","9.5.25-0ubuntu0.16.04.1+esm1","9.5.25-0ubuntu0.16.04.1+esm2","9.5.25-0ubuntu0.16.04.1+esm3","9.5.25-0ubuntu0.16.04.1+esm4","9.5.25-0ubuntu0.16.04.1+esm5","9.5.25-0ubuntu0.16.04.1+esm6","9.5.25-0ubuntu0.16.04.1+esm7","9.5.25-0ubuntu0.16.04.1+esm8","9.5.25-0ubuntu0.16.04.1+esm10"],"ecosystem_specific":{"binaries":[{"binary_name":"libecpg-compat3","binary_version":"9.5.25-0ubuntu0.16.04.1+esm10"},{"binary_version":"9.5.25-0ubuntu0.16.04.1+esm10","binary_name":"libecpg6"},{"binary_name":"libpgtypes3","binary_version":"9.5.25-0ubuntu0.16.04.1+esm10"},{"binary_name":"libpq5","binary_version":"9.5.25-0ubuntu0.16.04.1+esm10"},{"binary_name":"postgresql-9.5","binary_version":"9.5.25-0ubuntu0.16.04.1+esm10"},{"binary_name":"postgresql-client-9.5","binary_version":"9.5.25-0ubuntu0.16.04.1+esm10"},{"binary_version":"9.5.25-0ubuntu0.16.04.1+esm10","binary_name":"postgresql-contrib-9.5"},{"binary_name":"postgresql-doc-9.5","binary_version":"9.5.25-0ubuntu0.16.04.1+esm10"},{"binary_version":"9.5.25-0ubuntu0.16.04.1+esm10","binary_name":"postgresql-plperl-9.5"},{"binary_name":"postgresql-plpython-9.5","binary_version":"9.5.25-0ubuntu0.16.04.1+esm10"},{"binary_name":"postgresql-plpython3-9.5","binary_version":"9.5.25-0ubuntu0.16.04.1+esm10"},{"binary_name":"postgresql-pltcl-9.5","binary_version":"9.5.25-0ubuntu0.16.04.1+esm10"},{"binary_name":"postgresql-server-dev-9.5","binary_version":"9.5.25-0ubuntu0.16.04.1+esm10"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2023/UBUNTU-CVE-2023-2455.json"}},{"package":{"name":"postgresql-10","ecosystem":"Ubuntu:18.04:LTS","purl":"pkg:deb/ubuntu/postgresql-10@10.23-0ubuntu0.18.04.2?arch=source&distro=bionic"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"10.23-0ubuntu0.18.04.2"}]}],"versions":["10.1-1","10.1-2","10.2-1","10.3-1","10.4-0ubuntu0.18.04","10.5-0ubuntu0.18.04","10.6-0ubuntu0.18.04.1","10.7-0ubuntu0.18.04.1","10.8-0ubuntu0.18.04.1","10.9-0ubuntu0.18.04.1","10.10-0ubuntu0.18.04.1","10.12-0ubuntu0.18.04.1","10.14-0ubuntu0.18.04.1","10.15-0ubuntu0.18.04.1","10.16-0ubuntu0.18.04.1","10.17-0ubuntu0.18.04.1","10.18-0ubuntu0.18.04.1","10.19-0ubuntu0.18.04.1","10.20-0ubuntu0.18.04.1","10.21-0ubuntu0.18.04.1","10.22-0ubuntu0.18.04.1","10.23-0ubuntu0.18.04.1"],"ecosystem_specific":{"availability":"No subscription required","binaries":[{"binary_name":"libecpg-compat3","binary_version":"10.23-0ubuntu0.18.04.2"},{"binary_name":"libecpg6","binary_version":"10.23-0ubuntu0.18.04.2"},{"binary_name":"libpgtypes3","binary_version":"10.23-0ubuntu0.18.04.2"},{"binary_name":"libpq5","binary_version":"10.23-0ubuntu0.18.04.2"},{"binary_name":"postgresql-10","binary_version":"10.23-0ubuntu0.18.04.2"},{"binary_version":"10.23-0ubuntu0.18.04.2","binary_name":"postgresql-client-10"},{"binary_name":"postgresql-doc-10","binary_version":"10.23-0ubuntu0.18.04.2"},{"binary_name":"postgresql-plperl-10","binary_version":"10.23-0ubuntu0.18.04.2"},{"binary_name":"postgresql-plpython-10","binary_version":"10.23-0ubuntu0.18.04.2"},{"binary_name":"postgresql-plpython3-10","binary_version":"10.23-0ubuntu0.18.04.2"},{"binary_name":"postgresql-pltcl-10","binary_version":"10.23-0ubuntu0.18.04.2"},{"binary_name":"postgresql-server-dev-10","binary_version":"10.23-0ubuntu0.18.04.2"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2023/UBUNTU-CVE-2023-2455.json"}},{"package":{"name":"postgresql-12","ecosystem":"Ubuntu:20.04:LTS","purl":"pkg:deb/ubuntu/postgresql-12@12.15-0ubuntu0.20.04.1?arch=source&distro=focal"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"12.15-0ubuntu0.20.04.1"}]}],"versions":["12.0-1","12.1-1","12.1-2build1","12.2-1","12.2-1ubuntu2","12.2-4","12.4-0ubuntu0.20.04.1","12.5-0ubuntu0.20.04.1","12.6-0ubuntu0.20.04.1","12.7-0ubuntu0.20.04.1","12.8-0ubuntu0.20.04.1","12.9-0ubuntu0.20.04.1","12.10-0ubuntu0.20.04.1","12.11-0ubuntu0.20.04.1","12.12-0ubuntu0.20.04.1","12.13-0ubuntu0.20.04.1","12.14-0ubuntu0.20.04.1"],"ecosystem_specific":{"availability":"No subscription required","binaries":[{"binary_name":"libecpg-compat3","binary_version":"12.15-0ubuntu0.20.04.1"},{"binary_name":"libecpg6","binary_version":"12.15-0ubuntu0.20.04.1"},{"binary_name":"libpgtypes3","binary_version":"12.15-0ubuntu0.20.04.1"},{"binary_name":"libpq5","binary_version":"12.15-0ubuntu0.20.04.1"},{"binary_name":"postgresql-12","binary_version":"12.15-0ubuntu0.20.04.1"},{"binary_version":"12.15-0ubuntu0.20.04.1","binary_name":"postgresql-client-12"},{"binary_name":"postgresql-doc-12","binary_version":"12.15-0ubuntu0.20.04.1"},{"binary_name":"postgresql-plperl-12","binary_version":"12.15-0ubuntu0.20.04.1"},{"binary_name":"postgresql-plpython3-12","binary_version":"12.15-0ubuntu0.20.04.1"},{"binary_name":"postgresql-pltcl-12","binary_version":"12.15-0ubuntu0.20.04.1"},{"binary_name":"postgresql-server-dev-12","binary_version":"12.15-0ubuntu0.20.04.1"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2023/UBUNTU-CVE-2023-2455.json"}},{"package":{"name":"postgresql-14","ecosystem":"Ubuntu:22.04:LTS","purl":"pkg:deb/ubuntu/postgresql-14@14.8-0ubuntu0.22.04.1?arch=source&distro=jammy"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"14.8-0ubuntu0.22.04.1"}]}],"versions":["14.1-1ubuntu1","14.2-1","14.2-1ubuntu1","14.3-0ubuntu0.22.04.1","14.4-0ubuntu0.22.04.1","14.5-0ubuntu0.22.04.1","14.6-0ubuntu0.22.04.1","14.7-0ubuntu0.22.04.1"],"ecosystem_specific":{"availability":"No subscription required","binaries":[{"binary_name":"libecpg-compat3","binary_version":"14.8-0ubuntu0.22.04.1"},{"binary_name":"libecpg6","binary_version":"14.8-0ubuntu0.22.04.1"},{"binary_version":"14.8-0ubuntu0.22.04.1","binary_name":"libpgtypes3"},{"binary_name":"libpq5","binary_version":"14.8-0ubuntu0.22.04.1"},{"binary_name":"postgresql-14","binary_version":"14.8-0ubuntu0.22.04.1"},{"binary_name":"postgresql-client-14","binary_version":"14.8-0ubuntu0.22.04.1"},{"binary_name":"postgresql-doc-14","binary_version":"14.8-0ubuntu0.22.04.1"},{"binary_name":"postgresql-plperl-14","binary_version":"14.8-0ubuntu0.22.04.1"},{"binary_name":"postgresql-plpython3-14","binary_version":"14.8-0ubuntu0.22.04.1"},{"binary_name":"postgresql-pltcl-14","binary_version":"14.8-0ubuntu0.22.04.1"},{"binary_version":"14.8-0ubuntu0.22.04.1","binary_name":"postgresql-server-dev-14"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2023/UBUNTU-CVE-2023-2455.json"}}],"schema_version":"1.7.5","severity":[{"type":"CVSS_V3","score":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N"},{"type":"CVSS_V3","score":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N"},{"type":"Ubuntu","score":"medium"}]}