| Name | 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. |
| Source | CVE (at NVD; CERT, LWN, oss-sec, fulldisc, Red Hat, Ubuntu, Gentoo, SUSE bugzilla/CVE, GitHub advisories/code/issues, web search, more) |
| References | DLA-3422-1, DSA-5401-1, ELA-880-1 |
The table below lists information on source packages.
| Source Package | Release | Version | Status |
|---|---|---|---|
| postgresql-11 (PTS) | buster, buster (lts) | 11.22-0+deb10u3 | fixed |
| buster (security) | 11.22-0+deb10u2 | fixed | |
| postgresql-13 (PTS) | bullseye | 13.16-0+deb11u1 | fixed |
| bullseye (security) | 13.18-0+deb11u1 | fixed | |
| postgresql-15 (PTS) | bookworm | 15.8-0+deb12u1 | fixed |
| bookworm (security) | 15.10-0+deb12u1 | fixed | |
| postgresql-9.4 (PTS) | jessie, jessie (lts) | 9.4.26-0+deb8u10 | fixed |
| postgresql-9.6 (PTS) | stretch (security) | 9.6.24-0+deb9u1 | vulnerable |
| stretch (lts), stretch | 9.6.24-0+deb9u7 | fixed |
The information below is based on the following data on fixed versions.
| Package | Type | Release | Fixed Version | Urgency | Origin | Debian Bugs |
|---|---|---|---|---|---|---|
| postgresql-11 | source | buster | 11.20-0+deb10u1 | DLA-3422-1 | ||
| postgresql-11 | source | (unstable) | (unfixed) | |||
| postgresql-13 | source | bullseye | 13.11-0+deb11u1 | DSA-5401-1 | ||
| postgresql-13 | source | (unstable) | (unfixed) | |||
| postgresql-15 | source | (unstable) | 15.3-0+deb12u1 | |||
| postgresql-9.4 | source | jessie | (not affected) | |||
| postgresql-9.4 | source | (unstable) | (unfixed) | |||
| postgresql-9.6 | source | stretch | 9.6.24-0+deb9u4 | ELA-880-1 | ||
| postgresql-9.6 | source | (unstable) | (unfixed) |
https://www.postgresql.org/about/news/postgresql-153-148-1311-1215-and-1120-released-2637/
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=473626cf00babd829eb15c36b51dfb358d32bc95 (REL_11_20)
[jessie] - postgresql-9.4 <not-affected> (Vulnerable code introduced later)
Introduced by optimization in 9.6: https://github.com/postgres/postgres/commit/45639a0525a58a2700cf46d4c934d6de78349dac