{"id":"CVE-2023-2455","year":2023,"sequence":2455,"component":"core server","score":4.2,"cvss_version":"3.0","vector":"AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N","first_published":"2023-05-11","source_url":"https://www.postgresql.org/support/security/CVE-2023-2455/","facts":{"affected":{"11":"11","12":"12","13":"13","14":"14","15":"15"},"component":"core server","cvss_version":"3.0","description_en":"While CVE-2016-2193 fixed most interaction between row security and user ID changes, it missed a scenario involving function inlining. This leads to potentially incorrect policies being applied in 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 ROLE s. 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.\n\nThe PostgreSQL project thanks Wolfgang Walther for reporting this problem.","first_published":"2023-05-11","fixed":{"11":"11.20","12":"12.15","13":"13.11","14":"14.8","15":"15.3"},"id":"CVE-2023-2455","introduced":{},"published":{"11":"2023-05-11","12":"2023-05-11","13":"2023-05-11","14":"2023-05-11","15":"2023-05-11"},"score":4.2,"title":"Row security policies disregard user ID changes after inlining","url":"https://www.postgresql.org/support/security/CVE-2023-2455/","vector":"AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N"},"reviewed_hash":"6a65a7884245936f6adaef8709d290d460e999dfce1ad78734fa7c9a324ed325","source_hash":"965b9e2323feab543f3cbeb74c418c3a5b43cbefc6594d2862ff0d24dcf8e6a2","text":{"locale":"en","title":"Row security policies disregard user ID changes after inlining","description":"While CVE-2016-2193 fixed most interaction between row security and user ID changes, it missed a scenario involving function inlining. This leads to potentially incorrect policies being applied in 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 ROLE s. 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.\n\nThe PostgreSQL project thanks Wolfgang Walther for reporting this problem.","details":null,"format":"plain","provenance":{"fetched_at":"2026-09-26T10:56:06+00:00","path":"compare/security.json","root":"source-data","sha256":"6a65a7884245936f6adaef8709d290d460e999dfce1ad78734fa7c9a324ed325","source_archive_sha256":"8d8ad63581e1d27b3a0f995ded3feb81c265e38b2ac652eb22f022f52c2240ec","source_revision":"004bc292ee31c11f9a41ab007e9d8116bce29a71","source_url":"https://www.postgresql.org/support/security/"},"text_hash":"6d7e62dcfdd6af30016724348d10528410b1b2bfa31d8cdd6071a213e0751fa0"},"locales":["en","zh-Hans"],"fixes":[{"major":"11","fixed_version":"11.20","introduced":null,"published_date":"2023-05-11","facts":{"fixed":"11.20","introduced":null,"published":"2023-05-11"}},{"major":"12","fixed_version":"12.15","introduced":null,"published_date":"2023-05-11","facts":{"fixed":"12.15","introduced":null,"published":"2023-05-11"}},{"major":"13","fixed_version":"13.11","introduced":null,"published_date":"2023-05-11","facts":{"fixed":"13.11","introduced":null,"published":"2023-05-11"}},{"major":"14","fixed_version":"14.8","introduced":null,"published_date":"2023-05-11","facts":{"fixed":"14.8","introduced":null,"published":"2023-05-11"}},{"major":"15","fixed_version":"15.3","introduced":null,"published_date":"2023-05-11","facts":{"fixed":"15.3","introduced":null,"published":"2023-05-11"}}],"legacy":[{"source":"center","source_id":25,"observed_at":"2026-10-03 12:08:35.169032+08","raw":{"id":25,"cve":"2023-2455","public":true,"vector":"CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N","details":null,"component":"core server","cvenumber":202302455,"description":"行级安全策略在内联后会忽略用户 ID 变化","detailslink":"https://access.redhat.com/security/cve/CVE-2023-2455","legacyscore":"","newspost_id":null},"fixes":[{"source_id":89,"source_version_id":28,"major":"15","fixed_minor":3,"raw":{"id":89,"patch_id":25,"version_id":28,"fixed_minor":3},"version_raw":{"id":28,"tree":15.0,"current":false,"docsgit":"","eoldate":"2027-11-11","reldate":"2026-08-13","testing":0,"supported":true,"docsloaded":"2026-09-27T08:10:47.078613+08:00","latestminor":19,"firstreldate":"2022-10-13"}},{"source_id":90,"source_version_id":27,"major":"14","fixed_minor":8,"raw":{"id":90,"patch_id":25,"version_id":27,"fixed_minor":8},"version_raw":{"id":27,"tree":14.0,"current":false,"docsgit":"","eoldate":"2026-11-12","reldate":"2026-08-13","testing":0,"supported":true,"docsloaded":"2026-09-27T08:10:47.078613+08:00","latestminor":24,"firstreldate":"2021-09-30"}}]},{"source":"pgweb","source_id":25,"observed_at":"2026-10-03 12:08:55.967155+08","raw":{"id":25,"cve":"2023-2455","public":true,"vector":"CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N","details":null,"component":"core server","cvenumber":202302455,"description":"行级安全策略在内联后会忽略用户 ID 变化","detailslink":"https://access.redhat.com/security/cve/CVE-2023-2455","legacyscore":"","newspost_id":null},"fixes":[{"source_id":89,"source_version_id":28,"major":"15","fixed_minor":3,"raw":{"id":89,"patch_id":25,"version_id":28,"fixed_minor":3},"version_raw":{"id":28,"tree":15.0,"current":false,"docsgit":"","eoldate":"2027-11-11","reldate":"2026-08-13","testing":0,"supported":true,"docsloaded":"2026-09-27T00:10:45.258078+08:00","latestminor":19,"firstreldate":"2022-10-13"}},{"source_id":90,"source_version_id":27,"major":"14","fixed_minor":8,"raw":{"id":90,"patch_id":25,"version_id":27,"fixed_minor":8},"version_raw":{"id":27,"tree":14.0,"current":false,"docsgit":"","eoldate":"2026-11-12","reldate":"2026-08-13","testing":0,"supported":true,"docsloaded":"2026-09-27T00:10:45.258078+08:00","latestminor":24,"firstreldate":"2021-09-30"}}]}]}