pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / 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 ------ 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_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_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
* 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_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
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