{"schemaVersion":3,"id":"CVE-2023-2455","aliases":["ALPINE-CVE-2023-2455","UBUNTU-CVE-2023-2455","DEBIAN-CVE-2023-2455"],"status":"published","duplicateOf":null,"title":null,"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.","dates":{"published":"2023-06-09T00:00:00.000Z","modified":"2025-01-06T17:13:23.297Z","reserved":null,"kevAdded":[],"kevDue":[]},"cvss":{"headline":{"score":5.4,"severity":"medium","version":"3.1","versionLabel":"v3.1","source":"CVE.org","vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N","computed":false,"selection":"backend-summary"},"metrics":[{"version":"3.1","versionLabel":"v3.1","source":"CVE.org","score":5.4,"severity":"medium","vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N","exploitability":null,"impact":null,"computed":false},{"version":"3.1","versionLabel":"v3.1","source":"OSV · Alpine","score":5.4,"severity":"medium","vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N","exploitability":7.2,"impact":4.2,"computed":true},{"version":"3.1","versionLabel":"v3.1","source":"OSV · Ubuntu","score":5.4,"severity":"medium","vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N","exploitability":7.2,"impact":4.2,"computed":true},{"version":"3.1","versionLabel":"v3.1","source":"OSV · Debian","score":5.4,"severity":"medium","vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N","exploitability":7.2,"impact":4.2,"computed":true},{"version":"3.1","versionLabel":"v3.1","source":"NVD","score":5.4,"severity":"medium","vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N","exploitability":null,"impact":null,"computed":false}]},"epss":{"probability":0.007,"percentile":0.52291,"severity":"low","asOf":"2026-10-19T00:00:00.000Z","change":{"pp":0.006000000000000016,"baselineDate":"2026-09-19T00:00:00.000Z","baselineScore":0.00694},"history":[{"date":"2026-09-14T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-15T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-16T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-17T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-18T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-19T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-20T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-21T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.007,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.007,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.007,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.007,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.007,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.007,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.007,"percentile":0.52291}],"last30":[{"date":"2026-09-19T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-20T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-21T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.00694,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.007,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.007,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.007,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.007,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.007,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.007,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.007,"percentile":0.52291}]},"kev":{"state":"not-listed","entries":[],"listedCount":0,"totalCatalogs":3,"catalogs":[{"source":"cisa","label":"CISA","listed":false,"entry":null},{"source":"enisa","label":"ENISA","listed":false,"entry":null},{"source":"circl","label":"CIRCL","listed":false,"entry":null}]},"ransomware":{"state":"none-recorded","sources":[]},"exploits":[],"exploitCount":0,"weaknesses":[{"id":"CWE-20","name":"Improper Input Validation","description":"The product receives input or data, but it does\n        not validate or incorrectly validates that the input has the\n        properties that are required to process the data safely and\n        correctly.","type":"weakness","status":"Stable","abstraction":"Class","likelihoodOfExploit":"High","url":"https://cwe.mitre.org/data/definitions/20.html"}],"affected":[{"vendor":"alpine","product":"postgresql","name":"postgresql","label":"postgresql","ecosystem":"Alpine Linux","cpePart":null,"purl":"pkg:apk/alpine/postgresql","purlType":"apk","versions":[{"text":"≥ 11.0, < 13.11-r0","noFixRecorded":false,"fixedIn":null}],"versionsText":"≥ 11.0, < 13.11-r0","eol":null,"hubHref":null},{"vendor":"alpine","product":"postgresql13","name":"postgresql13","label":"postgresql13","ecosystem":"Alpine Linux","cpePart":null,"purl":"pkg:apk/alpine/postgresql13","purlType":"apk","versions":[{"text":"< 13.11-r0","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 13.11-r0","eol":null,"hubHref":null},{"vendor":"alpine","product":"postgresql14","name":"postgresql14","label":"postgresql14","ecosystem":"Alpine Linux","cpePart":null,"purl":"pkg:apk/alpine/postgresql14","purlType":"apk","versions":[{"text":"< 14.8-r0","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 14.8-r0","eol":null,"hubHref":null},{"vendor":"alpine","product":"postgresql15","name":"postgresql15","label":"postgresql15","ecosystem":"Alpine Linux","cpePart":null,"purl":"pkg:apk/alpine/postgresql15","purlType":"apk","versions":[{"text":"< 15.3-r0","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 15.3-r0","eol":null,"hubHref":null},{"vendor":"debian","product":"postgresql-15","name":"postgresql-15","label":"postgresql-15","ecosystem":"Debian","cpePart":null,"purl":"pkg:deb/debian/postgresql-15","purlType":"deb","versions":[{"text":"< 15.3-0+deb12u1","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 15.3-0+deb12u1","eol":null,"hubHref":null},{"vendor":"ubuntu","product":"postgresql-10","name":"postgresql-10","label":"postgresql-10","ecosystem":"Ubuntu","cpePart":null,"purl":"pkg:deb/ubuntu/postgresql-10","purlType":"deb","versions":[{"text":"< 10.23-0ubuntu0.18.04.2","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 10.23-0ubuntu0.18.04.2","eol":null,"hubHref":null},{"vendor":"ubuntu","product":"postgresql-12","name":"postgresql-12","label":"postgresql-12","ecosystem":"Ubuntu","cpePart":null,"purl":"pkg:deb/ubuntu/postgresql-12","purlType":"deb","versions":[{"text":"< 12.15-0ubuntu0.20.04.1","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 12.15-0ubuntu0.20.04.1","eol":null,"hubHref":null},{"vendor":"ubuntu","product":"postgresql-14","name":"postgresql-14","label":"postgresql-14","ecosystem":"Ubuntu","cpePart":null,"purl":"pkg:deb/ubuntu/postgresql-14","purlType":"deb","versions":[{"text":"< 14.8-0ubuntu0.22.04.1","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 14.8-0ubuntu0.22.04.1","eol":null,"hubHref":null},{"vendor":"ubuntu","product":"postgresql-9.3","name":"postgresql-9.3","label":"postgresql-9.3","ecosystem":"Ubuntu","cpePart":null,"purl":"pkg:deb/ubuntu/postgresql-9.3","purlType":"deb","versions":[{"text":"All versions","noFixRecorded":true,"fixedIn":null}],"versionsText":"All versions (No fix recorded)","eol":null,"hubHref":null},{"vendor":"ubuntu","product":"postgresql-9.5","name":"postgresql-9.5","label":"postgresql-9.5","ecosystem":"Ubuntu","cpePart":null,"purl":"pkg:deb/ubuntu/postgresql-9.5","purlType":"deb","versions":[{"text":"All versions","noFixRecorded":true,"fixedIn":null}],"versionsText":"All versions (No fix recorded)","eol":null,"hubHref":null},{"vendor":"fedoraproject","product":"fedora","name":"fedora","label":"fedora","ecosystem":null,"cpePart":"o","purl":null,"purlType":null,"versions":[{"text":"38","noFixRecorded":false,"fixedIn":null}],"versionsText":"38","eol":{"isEol":true,"eolDate":"2024-05-21T00:00:00.000Z","matchMethod":"cpe","cycle":{"name":"38","label":"38","eolFrom":"2024-05-21T00:00:00.000Z","isLts":false,"isMaintained":false,"latestVersion":null},"product":{"name":"fedora","label":"Fedora Linux","category":"os"}},"hubHref":"/vendor/fedoraproject/fedora"},{"vendor":"postgresql","product":"postgresql","name":"postgresql","label":"postgresql","ecosystem":null,"cpePart":"a","purl":null,"purlType":null,"versions":[{"text":"≥ 11.0, < 11.20","noFixRecorded":false,"fixedIn":null},{"text":"≥ 12.0, < 12.15","noFixRecorded":false,"fixedIn":null},{"text":"≥ 13.0, < 13.11","noFixRecorded":false,"fixedIn":null},{"text":"≥ 14.0, < 14.8","noFixRecorded":false,"fixedIn":null},{"text":"≥ 15.0, < 15.3","noFixRecorded":false,"fixedIn":null}],"versionsText":"≥ 11.0, < 11.20 | ≥ 12.0, < 12.15 | ≥ 13.0, < 13.11 | ≥ 14.0, < 14.8 | ≥ 15.0, < 15.3","eol":{"isEol":null,"eolDate":null,"matchMethod":"cpe","cycle":null,"product":{"name":"postgresql","label":"PostgreSQL","category":"database"}},"hubHref":"/vendor/postgresql/postgresql"},{"vendor":"redhat","product":"enterprise_linux","name":"enterprise linux","label":"enterprise_linux","ecosystem":null,"cpePart":"o","purl":null,"purlType":null,"versions":[{"text":"8.0","noFixRecorded":false,"fixedIn":null},{"text":"9.0","noFixRecorded":false,"fixedIn":null}],"versionsText":"8.0 | 9.0","eol":{"isEol":false,"eolDate":"2029-05-31T00:00:00.000Z","matchMethod":"cpe","cycle":{"name":"8","label":"8 (Upcoming ELS)","eolFrom":"2029-05-31T00:00:00.000Z","isLts":false,"isMaintained":true,"latestVersion":"8.10"},"product":{"name":"rhel","label":"Red Hat Enterprise Linux","category":"os"}},"hubHref":"/vendor/redhat/enterprise_linux"},{"vendor":"redhat","product":"software_collections","name":"software collections","label":"software_collections","ecosystem":null,"cpePart":"a","purl":null,"purlType":null,"versions":[{"text":"na","noFixRecorded":false,"fixedIn":null}],"versionsText":"na","eol":null,"hubHref":"/vendor/redhat/software_collections"}],"affectedCount":14,"eol":{"hasEol":true,"count":1},"references":[{"url":"https://access.redhat.com/security/cve/CVE-2023-2455","label":"access.redhat.com/security/cve/CVE-2023-2455","hostname":"access.redhat.com","tags":["Third Party Advisory"]},{"url":"https://www.postgresql.org/support/security/CVE-2023-2455/","label":"www.postgresql.org/support/security/CVE-2023-2455/","hostname":"www.postgresql.org","tags":["Vendor Advisory"]},{"url":"https://security.netapp.com/advisory/ntap-20230706-0006/","label":"security.netapp.com/advisory/ntap-20230706-0006/","hostname":"security.netapp.com","tags":[]},{"url":"https://security.alpinelinux.org/vuln/CVE-2023-2455","label":"security.alpinelinux.org/vuln/CVE-2023-2455","hostname":"security.alpinelinux.org","tags":["Advisory"]},{"url":"https://ubuntu.com/security/CVE-2023-2455","label":"ubuntu.com/security/CVE-2023-2455","hostname":"ubuntu.com","tags":["REPORT"]},{"url":"https://www.postgresql.org/about/news/postgresql-153-148-1311-1215-and-1120-released-2637/","label":"www.postgresql.org/about/news/postgresql-153-148-1311-1215-and-1120-released-2637/","hostname":"www.postgresql.org","tags":["REPORT"]},{"url":"https://ubuntu.com/security/notices/USN-6104-1","label":"ubuntu.com/security/notices/USN-6104-1","hostname":"ubuntu.com","tags":["Advisory"]},{"url":"https://www.cve.org/CVERecord?id=CVE-2023-2455","label":"www.cve.org/CVERecord?id=CVE-2023-2455","hostname":"www.cve.org","tags":["REPORT"]},{"url":"https://security-tracker.debian.org/tracker/CVE-2023-2455","label":"security-tracker.debian.org/tracker/CVE-2023-2455","hostname":"security-tracker.debian.org","tags":["Advisory"]}],"lineage":{"upstream":[],"downstream":["DLA-3422-1","DSA-5401-1","MGASA-2023-0187","OPENSUSE-SU-2024:12929-1","OPENSUSE-SU-2024:12930-1","OPENSUSE-SU-2024:12931-1","OPENSUSE-SU-2024:12932-1","OPENSUSE-SU-2024:12933-1","OPENSUSE-SU-2024:14360-1","OPENSUSE-SU-2025:15580-1","RHSA-2023:3714","RHSA-2023:4313","RHSA-2023:4327","RHSA-2023:4527","RHSA-2023:4535","RHSA-2023:4539","RHSA-2023:5269","RHSA-2023:7545","RHSA-2023:7580","RHSA-2023:7666","RHSA-2023:7667","RHSA-2023:7694","RHSA-2023:7695","RHSA-2023:7772","SUSE-SU-2023:2198-1","SUSE-SU-2023:2199-1","SUSE-SU-2023:2200-1","SUSE-SU-2023:2201-1","SUSE-SU-2023:2202-1","SUSE-SU-2023:2205-1","SUSE-SU-2023:2206-1","SUSE-SU-2023:2207-1","SUSE-SU-2023:2219-1","USN-6104-1"],"duplicates":[],"related":["OPENSUSE-SU-2024:12929-1","OPENSUSE-SU-2024:12930-1","OPENSUSE-SU-2024:12931-1","OPENSUSE-SU-2024:12932-1","OPENSUSE-SU-2024:12933-1","OPENSUSE-SU-2024:14360-1","OPENSUSE-SU-2025:15580-1","SUSE-SU-2023:2198-1","SUSE-SU-2023:2199-1","SUSE-SU-2023:2200-1","SUSE-SU-2023:2201-1","SUSE-SU-2023:2202-1","SUSE-SU-2023:2205-1","SUSE-SU-2023:2206-1","SUSE-SU-2023:2207-1","SUSE-SU-2023:2219-1","USN-6104-1"]},"timeline":[{"kind":"published","date":"2023-06-09T00:00:00.000Z","label":"Published","detail":"Vulnerability first disclosed.","source":null},{"kind":"modified","date":"2025-01-06T17:13:23.297Z","label":"Last modified","detail":"Vulnerability information updated.","source":null}],"risk":{"score":22,"level":"low","profile":"Default","thresholds":{"critical":75,"high":50,"medium":25,"low":10}},"meta":{"dataAsOf":"2026-10-19T18:35:17.871Z","stale":false,"partial":false}}