pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pgsql: Handle RLS dependencies in inlined set-returning functions prope
6+ messages / 1 participants
[nested] [flat]

* pgsql: Handle RLS dependencies in inlined set-returning functions prope
@ 2023-05-08 14:12  Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 6+ messages in thread

From: Tom Lane @ 2023-05-08 14:12 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

Handle RLS dependencies in inlined set-returning functions properly.

If an SRF in the FROM clause references a table having row-level
security policies, and we inline that SRF into the calling query,
we neglected to mark the plan as potentially dependent on which
role is executing it.  This could lead to later executions in the
same session returning or hiding rows that should have been hidden
or returned instead.

Our thanks to Wolfgang Walther for reporting this problem.

Stephen Frost and Tom Lane

Security: CVE-2023-2455

Branch
------
REL_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/04e5606045e4887463ac9070acfc52e060fe6583

Modified Files
--------------
src/backend/optimizer/util/clauses.c      |  7 +++++++
src/test/regress/expected/rowsecurity.out | 27 +++++++++++++++++++++++++++
src/test/regress/sql/rowsecurity.sql      | 20 ++++++++++++++++++++
3 files changed, 54 insertions(+)



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* pgsql: Handle RLS dependencies in inlined set-returning functions prope
@ 2023-05-08 14:12  Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 6+ messages in thread

From: Tom Lane @ 2023-05-08 14:12 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

Handle RLS dependencies in inlined set-returning functions properly.

If an SRF in the FROM clause references a table having row-level
security policies, and we inline that SRF into the calling query,
we neglected to mark the plan as potentially dependent on which
role is executing it.  This could lead to later executions in the
same session returning or hiding rows that should have been hidden
or returned instead.

Our thanks to Wolfgang Walther for reporting this problem.

Stephen Frost and Tom Lane

Security: CVE-2023-2455

Branch
------
REL_12_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/ee87b482c3952a1e7504a8ba0df7c8ebaab36f72

Modified Files
--------------
src/backend/optimizer/util/clauses.c      |  7 +++++++
src/test/regress/expected/rowsecurity.out | 27 +++++++++++++++++++++++++++
src/test/regress/sql/rowsecurity.sql      | 20 ++++++++++++++++++++
3 files changed, 54 insertions(+)



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* pgsql: Handle RLS dependencies in inlined set-returning functions prope
@ 2023-05-08 14:12  Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 6+ messages in thread

From: Tom Lane @ 2023-05-08 14:12 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

Handle RLS dependencies in inlined set-returning functions properly.

If an SRF in the FROM clause references a table having row-level
security policies, and we inline that SRF into the calling query,
we neglected to mark the plan as potentially dependent on which
role is executing it.  This could lead to later executions in the
same session returning or hiding rows that should have been hidden
or returned instead.

Our thanks to Wolfgang Walther for reporting this problem.

Stephen Frost and Tom Lane

Security: CVE-2023-2455

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/473626cf00babd829eb15c36b51dfb358d32bc95

Modified Files
--------------
src/backend/optimizer/util/clauses.c      |  7 +++++++
src/test/regress/expected/rowsecurity.out | 27 +++++++++++++++++++++++++++
src/test/regress/sql/rowsecurity.sql      | 20 ++++++++++++++++++++
3 files changed, 54 insertions(+)



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* pgsql: Handle RLS dependencies in inlined set-returning functions prope
@ 2023-05-08 14:12  Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 6+ messages in thread

From: Tom Lane @ 2023-05-08 14:12 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

Handle RLS dependencies in inlined set-returning functions properly.

If an SRF in the FROM clause references a table having row-level
security policies, and we inline that SRF into the calling query,
we neglected to mark the plan as potentially dependent on which
role is executing it.  This could lead to later executions in the
same session returning or hiding rows that should have been hidden
or returned instead.

Our thanks to Wolfgang Walther for reporting this problem.

Stephen Frost and Tom Lane

Security: CVE-2023-2455

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/ca73753b090c33bc69ce299b4d7fff891a77b8ad

Modified Files
--------------
src/backend/optimizer/util/clauses.c      |  7 +++++++
src/test/regress/expected/rowsecurity.out | 27 +++++++++++++++++++++++++++
src/test/regress/sql/rowsecurity.sql      | 20 ++++++++++++++++++++
3 files changed, 54 insertions(+)



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* pgsql: Handle RLS dependencies in inlined set-returning functions prope
@ 2023-05-08 14:12  Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 6+ messages in thread

From: Tom Lane @ 2023-05-08 14:12 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

Handle RLS dependencies in inlined set-returning functions properly.

If an SRF in the FROM clause references a table having row-level
security policies, and we inline that SRF into the calling query,
we neglected to mark the plan as potentially dependent on which
role is executing it.  This could lead to later executions in the
same session returning or hiding rows that should have been hidden
or returned instead.

Our thanks to Wolfgang Walther for reporting this problem.

Stephen Frost and Tom Lane

Security: CVE-2023-2455

Branch
------
REL_13_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/b8e28f04f7f339d4285852960e6455de75dbf9b3

Modified Files
--------------
src/backend/optimizer/util/clauses.c      |  7 +++++++
src/test/regress/expected/rowsecurity.out | 27 +++++++++++++++++++++++++++
src/test/regress/sql/rowsecurity.sql      | 20 ++++++++++++++++++++
3 files changed, 54 insertions(+)



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* pgsql: Handle RLS dependencies in inlined set-returning functions prope
@ 2023-05-08 14:12  Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 6+ messages in thread

From: Tom Lane @ 2023-05-08 14:12 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

Handle RLS dependencies in inlined set-returning functions properly.

If an SRF in the FROM clause references a table having row-level
security policies, and we inline that SRF into the calling query,
we neglected to mark the plan as potentially dependent on which
role is executing it.  This could lead to later executions in the
same session returning or hiding rows that should have been hidden
or returned instead.

Our thanks to Wolfgang Walther for reporting this problem.

Stephen Frost and Tom Lane

Security: CVE-2023-2455

Branch
------
REL_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/f8d799eda26391bdcd8b493f4eacd77ca70b14f4

Modified Files
--------------
src/backend/optimizer/util/clauses.c      |  7 +++++++
src/test/regress/expected/rowsecurity.out | 27 +++++++++++++++++++++++++++
src/test/regress/sql/rowsecurity.sql      | 20 ++++++++++++++++++++
3 files changed, 54 insertions(+)



^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2023-05-08 14:12 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-05-08 14:12 pgsql: Handle RLS dependencies in inlined set-returning functions prope Tom Lane <tgl@sss.pgh.pa.us>
2023-05-08 14:12 pgsql: Handle RLS dependencies in inlined set-returning functions prope Tom Lane <tgl@sss.pgh.pa.us>
2023-05-08 14:12 pgsql: Handle RLS dependencies in inlined set-returning functions prope Tom Lane <tgl@sss.pgh.pa.us>
2023-05-08 14:12 pgsql: Handle RLS dependencies in inlined set-returning functions prope Tom Lane <tgl@sss.pgh.pa.us>
2023-05-08 14:12 pgsql: Handle RLS dependencies in inlined set-returning functions prope Tom Lane <tgl@sss.pgh.pa.us>
2023-05-08 14:12 pgsql: Handle RLS dependencies in inlined set-returning functions prope Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox