Skip to content
Fencer Vulns
medium 5.4

CVE-2023-2455 json

Row security policies disregard user ID changes after inlining; PostgreSQL could permit incorrect policies to be applied in certain cases w…

published 2023-06-09 3 y ago modified 2026-09-08 2 mo ago also BIT-postgresql-2023-2455 , EUVD-2023-33940 , JLSEC-2026-41

cvss
5.4
version 3.1, CNA
cisa kev
Not listed
not in CISA's catalog
epss
0.7%
EPSS 0.7% chance of exploitation in 30 days, percentile 53%
public exploits
0
none known

Summary

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.

Patch / fix

  • bitnami postgresql 11.20.0, 12.15.0, 13.11.0, 14.8.0, 15.3.0
  • julia LibPQ_jll 16.0.0+0
  • postgresql postgresql 11.20, 12.15, 13.11, 14.8, 15.3
  • postgresql-15 Debian 12 15.3-0+deb12u1

debian advisories DEBIAN-CVE-2023-2455

  • postgresql-10 Ubuntu 18.04 LTS 10.23-0ubuntu0.18.04.2
  • postgresql-12 Ubuntu 20.04 LTS 12.15-0ubuntu0.20.04.1
  • postgresql-14 Ubuntu 22.04 LTS 14.8-0ubuntu0.22.04.1

ubuntu advisories UBUNTU-CVE-2023-2455

Ubuntu security data © Canonical Ltd., from https://github.com/canonical/ubuntu-security-notices via OSV; changed: normalised to fixed package versions per release. CC BY-SA 4.0

  • pgaudit RHEL 8, RHEL 8.6 EUS 1.4.0-5.module+el8.5.0+11354+78b3c9c5
  • pg_repack RHEL 8, RHEL 8.6 EUS 1.4.6-3.module+el8.5.0+11354+78b3c9c5
  • postgres-decoderbufs RHEL 8, RHEL 8.6 EUS 0.10.0-2.module+el8.5.0+11354+78b3c9c5
  • pgaudit RHEL 8, RHEL 8.6 EUS, RHEL 8.4 TUS +2 more 1.5.0-1.module+el8.4.0+8873+b821c30a
  • pg_repack RHEL 8, RHEL 8.6 EUS 1.4.6-3.module+el8.5.0+11357+bcc62552
  • postgres-decoderbufs RHEL 8, RHEL 8.6 EUS, RHEL 8.4 TUS +2 more 0.10.0-2.module+el8.4.0+8873+b821c30a
  • pgaudit RHEL 8 1.7.0-1.module+el8.8.0+17071+aaaceaa4
  • pg_repack RHEL 8 1.4.8-1.module+el8.8.0+17071+aaaceaa4

red hat advisories RHSA-2023:7694RHSA-2023:7667RHSA-2023:7666RHSA-2023:7580RHSA-2023:7695RHSA-2023:5269

  • postgresql13 SLES for SAP 15 SP3, SLES for SAP 15 SP2, SLES 15 SP3-LTSS +11 more 13.11-150200.5.40.1
  • postgresql15 SLES for SAP 15 SP3, SLES for SAP 15 SP2, SLES 15 SP3-LTSS +13 more 15.3-150200.5.9.1
  • postgresql15 SLES for SAP 12 SP5, SLES for SAP 12 SP4, SLES 12 SP5 +6 more 15.3-3.9.1
  • postgresql14 SLES for SAP 15 SP3, SLES for SAP 15 SP2, SLES 15 SP3-LTSS +13 more 14.8-150200.5.26.1
  • postgresql14 SLES for SAP 12 SP5, SLES 12 SP5, SLE Software Development Kit 12 SP5 14.8-3.23.1
  • postgresql13 SLES for SAP 12 SP5, SLES 12 SP5, SLE Software Development Kit 12 SP5 13.11-3.33.1
  • postgresql12 SLES for SAP 12 SP5, SLES 12 SP5, SLE Software Development Kit 12 SP5 12.15-3.39.1
  • postgresql12 SLES for SAP 15 SP3, SLES for SAP 15 SP2, SLES 15 SP3-LTSS +7 more 12.15-150200.8.44.1

suse advisories SUSE-SU-2023:2219-1SUSE-SU-2023:2207-1SUSE-SU-2023:2206-1SUSE-SU-2023:2205-1SUSE-SU-2023:2202-1SUSE-SU-2023:2201-1

  • postgresql17 openSUSE Tumbleweed 17.6-2.1
  • postgresql16 openSUSE Tumbleweed 16.4-1.1
  • postgresql11 openSUSE Tumbleweed 11.20-1.1
  • postgresql12 openSUSE Tumbleweed 12.15-1.1
  • postgresql13 openSUSE Tumbleweed 13.11-1.1
  • postgresql14 openSUSE Tumbleweed 14.8-1.1
  • postgresql15 openSUSE Tumbleweed 15.3-1.1

opensuse advisories openSUSE-SU-2025:15580-1openSUSE-SU-2024:14360-1openSUSE-SU-2024:12929-1openSUSE-SU-2024:12930-1openSUSE-SU-2024:12931-1openSUSE-SU-2024:12932-1

  • pgaudit AlmaLinux 8 1.7.0-1.module_el8.8.0+3487+43ec1b9f
  • pg_repack AlmaLinux 8 1.4.8-1.module_el8.8.0+3487+43ec1b9f
  • postgresql AlmaLinux 8 15.3-1.module_el8.8.0+3610+f1fe5820
  • postgresql-test AlmaLinux 8 15.3-1.module_el8.8.0+3610+f1fe5820
  • postgresql-pltcl AlmaLinux 8 15.3-1.module_el8.8.0+3610+f1fe5820
  • postgresql-plperl AlmaLinux 8 15.3-1.module_el8.8.0+3610+f1fe5820
  • postgresql-server AlmaLinux 8 15.3-1.module_el8.8.0+3610+f1fe5820
  • postgresql-contrib AlmaLinux 8 15.3-1.module_el8.8.0+3610+f1fe5820

almalinux advisories ALSA-2023:5269ALSA-2023:4527ALSA-2023:4535ALSA-2023:4539ALSA-2023:4327ALSA-2023:3714

  • pgaudit Rocky Linux 8 1.7.0-1.module+el8.10.0+40056+df351139
  • pgaudit Rocky Linux 8 1.7.0-1.module+el8.9.0+1525+fc91df60
  • pg_repack Rocky Linux 8 1.4.8-1.module+el8.9.0+1525+fc91df60
  • pg_repack Rocky Linux 8 1.4.8-1.module+el8.10.0+1858+fcc46a79
  • pg_repack Rocky Linux 8 1.4.8-1.module+el8.10.0+40056+df351139
  • pg_repack Rocky Linux 8 1.4.8-1.module+el8.10.0+1622+bd25b19c
  • postgres-decoderbufs Rocky Linux 8 1.9.7-1.Final.module+el8.10.0+40056+df351139
  • postgres-decoderbufs Rocky Linux 8 1.9.7-1.Final.module+el8.9.0+1525+fc91df60

rocky linux advisories RLSA-2023:5269RLSA-2023:4527RLSA-2023:4535RLSA-2023:3714RLSA-2023:4539RLSA-2023:4327

  • postgresql Alpine 3.14, Alpine 3.13 13.11-r0
  • postgresql12 Alpine 3.18, Alpine 3.17, Alpine 3.16 +1 more 12.15-r0
  • postgresql13 Alpine 3.19, Alpine 3.18, Alpine 3.17 +2 more 13.11-r0
  • postgresql14 Alpine 3.20, Alpine 3.19, Alpine 3.18 +3 more 14.8-r0
  • postgresql15 Alpine 3.22, Alpine 3.21, Alpine 3.20 +3 more 15.3-r0

alpine advisories ALPINE-CVE-2023-2455

Alpine secdb © Alpine Linux, from https://secdb.alpinelinux.org via OSV; changed: normalised to fixed package versions per release. CC BY-SA 4.0

Vendor advisories

What the vendors themselves say about their products: affected, fixed or not affected, and what to do.

red hat product security vex CVE-2023-2455 updated cvss 4.2

postgresql: row security policies disregard user ID changes after inlining.

  • Red Hat Enterprise Linux 6 postgresql, postgresql-libs, postgresql-test, postgresql-pltcl, postgresql-plperl, postgresql-server, +2 more Red Hat Enterprise Linux 7 postgresql, postgresql-libs, postgresql-test, postgresql-pltcl, postgresql-plperl, postgresql-server, +3 more
    affected: workaround, no fix planned “Out of support scope”
  • Red Hat CodeReady Linux Builder EUS (v.9.0) postgresql-test 13.13-1.el9_0
    fixed: vendor fix RHSA-2023:7545
  • Red Hat Enterprise Linux AppStream (v. 8) pgaudit 1.5.0-1.module+el8.4.0+8873+b821c30a, pgaudit 1.4.0-5.module+el8.5.0+11354+78b3c9c5, pgaudit 1.7.0-1.module+el8.8.0+17071+aaaceaa4, pg_repack 1.4.6-3.module+el8.5.0+11354+78b3c9c5, pg_repack 1.4.6-3.module+el8.5.0+11357+bcc62552, pg_repack 1.4.8-1.module+el8.8.0+17071+aaaceaa4, +40 more
    fixed: vendor fix RHSA-2023:4535
  • Red Hat Enterprise Linux AppStream (v. 9) postgresql 13.11-1.el9_2, postgresql-pltcl 13.11-1.el9_2, postgresql-plperl 13.11-1.el9_2, postgresql-server 13.11-1.el9_2, postgresql-contrib 13.11-1.el9_2, postgresql-upgrade 13.11-1.el9_2, +15 more
    fixed: vendor fix RHSA-2023:4327
  • Red Hat Enterprise Linux AppStream AUS (v. 8.2) pgaudit 1.4.0-4.module+el8.2.0+9043+1dbb5661, postgresql 12.17-1.module+el8.2.0+20720+50ffbc0b, postgresql-test 12.17-1.module+el8.2.0+20720+50ffbc0b, postgresql-pltcl 12.17-1.module+el8.2.0+20720+50ffbc0b, postgresql-plperl 12.17-1.module+el8.2.0+20720+50ffbc0b, postgresql-server 12.17-1.module+el8.2.0+20720+50ffbc0b, +5 more
    fixed: vendor fix RHSA-2023:7667
  • Red Hat Enterprise Linux AppStream AUS (v.8.4) pgaudit 1.5.0-1.module+el8.4.0+8873+b821c30a, pgaudit 1.4.0-6.module+el8.4.0+11288+c193d6d7, postgresql 12.17-1.module+el8.4.0+20773+7c41d490, postgresql 13.13-1.module+el8.4.0+20774+68ad636d, postgresql-test 12.17-1.module+el8.4.0+20773+7c41d490, postgresql-test 13.13-1.module+el8.4.0+20774+68ad636d, +16 more
    fixed: vendor fix RHSA-2023:7694
  • Red Hat Enterprise Linux AppStream E4S (v. 8.2) pgaudit 1.4.0-4.module+el8.2.0+9043+1dbb5661, postgresql 12.17-1.module+el8.2.0+20720+50ffbc0b, postgresql-test 12.17-1.module+el8.2.0+20720+50ffbc0b, postgresql-pltcl 12.17-1.module+el8.2.0+20720+50ffbc0b, postgresql-plperl 12.17-1.module+el8.2.0+20720+50ffbc0b, postgresql-server 12.17-1.module+el8.2.0+20720+50ffbc0b, +5 more
    fixed: vendor fix RHSA-2023:7667
  • Red Hat Enterprise Linux AppStream E4S (v.8.4) pgaudit 1.5.0-1.module+el8.4.0+8873+b821c30a, pgaudit 1.4.0-6.module+el8.4.0+11288+c193d6d7, postgresql 12.17-1.module+el8.4.0+20773+7c41d490, postgresql 13.13-1.module+el8.4.0+20774+68ad636d, postgresql-test 12.17-1.module+el8.4.0+20773+7c41d490, postgresql-test 13.13-1.module+el8.4.0+20774+68ad636d, +16 more
    fixed: vendor fix RHSA-2023:7694
show 7 more
  • Red Hat Enterprise Linux AppStream EUS (v.8.6) pgaudit 1.5.0-1.module+el8.4.0+8873+b821c30a, pgaudit 1.4.0-5.module+el8.5.0+11354+78b3c9c5, pg_repack 1.4.6-3.module+el8.5.0+11354+78b3c9c5, pg_repack 1.4.6-3.module+el8.5.0+11357+bcc62552, postgresql 12.17-1.module+el8.6.0+20721+c66fb2f5, postgresql 13.13-1.module+el8.6.0+20665+ba8c5a93, +18 more
    fixed: vendor fix RHSA-2023:7666
  • Red Hat Enterprise Linux AppStream EUS (v.9.0) postgresql 13.13-1.el9_0, postgresql-pltcl 13.13-1.el9_0, postgresql-plperl 13.13-1.el9_0, postgresql-server 13.13-1.el9_0, postgresql-contrib 13.13-1.el9_0, postgresql-upgrade 13.13-1.el9_0, +2 more
    fixed: vendor fix RHSA-2023:7545
  • Red Hat Enterprise Linux AppStream TUS (v. 8.2) pgaudit 1.4.0-4.module+el8.2.0+9043+1dbb5661, postgresql 12.17-1.module+el8.2.0+20720+50ffbc0b, postgresql-test 12.17-1.module+el8.2.0+20720+50ffbc0b, postgresql-pltcl 12.17-1.module+el8.2.0+20720+50ffbc0b, postgresql-plperl 12.17-1.module+el8.2.0+20720+50ffbc0b, postgresql-server 12.17-1.module+el8.2.0+20720+50ffbc0b, +5 more
    fixed: vendor fix RHSA-2023:7667
  • Red Hat Enterprise Linux AppStream TUS (v.8.4) pgaudit 1.5.0-1.module+el8.4.0+8873+b821c30a, pgaudit 1.4.0-6.module+el8.4.0+11288+c193d6d7, postgresql 12.17-1.module+el8.4.0+20773+7c41d490, postgresql 13.13-1.module+el8.4.0+20774+68ad636d, postgresql-test 12.17-1.module+el8.4.0+20773+7c41d490, postgresql-test 13.13-1.module+el8.4.0+20774+68ad636d, +16 more
    fixed: vendor fix RHSA-2023:7694
  • Red Hat Enterprise Linux CRB (v. 9) postgresql-test 13.11-1.el9_2
    fixed: vendor fix RHSA-2023:3714
  • Red Hat Software Collections for RHEL Workstation(v. 7) rh-postgresql12-postgresql 12.15-1.el7, rh-postgresql13-postgresql 13.13-1.el7, rh-postgresql12-postgresql-libs 12.15-1.el7, rh-postgresql12-postgresql-test 12.15-1.el7, rh-postgresql13-postgresql-libs 13.13-1.el7, rh-postgresql13-postgresql-test 13.13-1.el7, +17 more Red Hat Software Collections for RHEL(v. 7) rh-postgresql12-postgresql 12.15-1.el7, rh-postgresql13-postgresql 13.13-1.el7, rh-postgresql12-postgresql-libs 12.15-1.el7, rh-postgresql12-postgresql-test 12.15-1.el7, rh-postgresql13-postgresql-libs 13.13-1.el7, rh-postgresql13-postgresql-test 13.13-1.el7, +17 more
    fixed: vendor fix RHSA-2023:4313
  • Red Hat A-MQ Clients 2 postgresql Red Hat Cryostat 2 postgresql Red Hat Advanced Cluster Management for Kubernetes 2 acm-multicluster-globalhub-agent-container, acm-multicluster-globalhub-manager-container, acm-multicluster-globalhub-operator-container, acm-multicluster-globalhub-operator-bundle-container Red Hat AMQ Broker 7 postgresql Red Hat build of Apache Camel for Spring Boot 3 postgresql Red Hat build of Apicurio Registry 2 postgresql
    +18 more products
    Red Hat build of Debezium 1 postgresql Red Hat build of OptaPlanner 8 postgresql Red Hat build of Quarkus postgresql Red Hat Data Grid 8 postgresql Red Hat Decision Manager 7 postgresql Red Hat Fuse 7 postgresql Red Hat Integration Camel K 1 postgresql Red Hat Integration Camel Quarkus 2 postgresql Red Hat JBoss Data Grid 7 postgresql Red Hat JBoss Enterprise Application Platform 6 postgresql, jboss-on jboss-on Red Hat JBoss Enterprise Application Platform 7 postgresql Red Hat JBoss Enterprise Application Platform 8 postgresql Red Hat JBoss Enterprise Application Platform Expansion Pack postgresql Red Hat JBoss Fuse 6 postgresql Red Hat JBoss Fuse Service Works 6 postgresql Red Hat OpenShift Application Runtimes postgresql Red Hat OpenShift Container Platform 3.11 postgresql-apb-role, openshift-enterprise-postgresql-apb Red Hat OpenShift Container Platform 4 openshift4/ose-installer, openshift4/ose-installer-artifacts, openshift4/ose-baremetal-installer-rhel9
    not affected: vulnerable code not present

4 more not affected in the full advisory

Red Hat CSAF VEX © Red Hat, Inc., from https://security.access.redhat.com/data/csaf/v2/vex/; changed: reduced to product statuses and remediations. CC BY 4.0 · csaf

CISA SSVC

Exploitation
none
Automatable
no
Technical impact
partial
Assessed
22 mo ago

Exploit prediction

0.70% chance of exploitation in the next 30 days, higher than 53% of all scored CVEs (FIRST EPSS, 2026-11-08).

CVSS scores

assigned by version score vector
CISA ADP 3.1 5.4 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N
NVD 3.1 5.4 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N
CNA 3.1 5.4 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N
OSV 3.1 5.4 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N

Affected packages

ecosystem package affected fixed in
bitnami postgresql
>=11.0.0, <11.20.0
>=12.0.0, <12.15.0
>=13.0.0, <13.11.0
>=14.0.0, <14.8.0
>=15.0.0, <15.3.0
11.20.0
12.15.0
13.11.0
14.8.0
15.3.0
julia LibPQ_jll
<16.0.0+0
16.0.0+0

Affected products

  • n/a postgresql

Classification

Weakness
  • CWE-20 Improper Input Validation
Technology feeds

References

Sources

Fencer Vulns keeps one entry per vulnerability: the CVE id wins, then GHSA, and records that alias each other are merged, except that two CVEs always keep separate entries. The same data is available as JSON.