pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pgsql: In REFRESH MATERIALIZED VIEW, set user ID before running user co
6+ messages / 1 participants
[nested] [flat]

* pgsql: In REFRESH MATERIALIZED VIEW, set user ID before running user co
@ 2022-05-09 15:37  Noah Misch <noah@leadboat.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Noah Misch @ 2022-05-09 15:37 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

In REFRESH MATERIALIZED VIEW, set user ID before running user code.

It intended to, but did not, achieve this.  Adopt the new standard of
setting user ID just after locking the relation.  Back-patch to v10 (all
supported versions).

Reviewed by Simon Riggs.  Reported by Alvaro Herrera.

Security: CVE-2022-1552

Branch
------
REL_10_STABLE

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

Modified Files
--------------
src/backend/commands/matview.c           | 30 +++++++++++-------------------
src/test/regress/expected/privileges.out | 16 ++++++++++++++++
src/test/regress/sql/privileges.sql      | 17 +++++++++++++++++
3 files changed, 44 insertions(+), 19 deletions(-)



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

* pgsql: In REFRESH MATERIALIZED VIEW, set user ID before running user co
@ 2022-05-09 15:37  Noah Misch <noah@leadboat.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Noah Misch @ 2022-05-09 15:37 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

In REFRESH MATERIALIZED VIEW, set user ID before running user code.

It intended to, but did not, achieve this.  Adopt the new standard of
setting user ID just after locking the relation.  Back-patch to v10 (all
supported versions).

Reviewed by Simon Riggs.  Reported by Alvaro Herrera.

Security: CVE-2022-1552

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/0abc1a059e27c5a71a1a186c97d9c0af407469cc

Modified Files
--------------
src/backend/commands/matview.c           | 30 +++++++++++-------------------
src/test/regress/expected/privileges.out | 16 ++++++++++++++++
src/test/regress/sql/privileges.sql      | 17 +++++++++++++++++
3 files changed, 44 insertions(+), 19 deletions(-)



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

* pgsql: In REFRESH MATERIALIZED VIEW, set user ID before running user co
@ 2022-05-09 15:37  Noah Misch <noah@leadboat.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Noah Misch @ 2022-05-09 15:37 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

In REFRESH MATERIALIZED VIEW, set user ID before running user code.

It intended to, but did not, achieve this.  Adopt the new standard of
setting user ID just after locking the relation.  Back-patch to v10 (all
supported versions).

Reviewed by Simon Riggs.  Reported by Alvaro Herrera.

Security: CVE-2022-1552

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/34ff15660b4f752e3941d661c3896fd96b1571f9

Modified Files
--------------
src/backend/commands/matview.c           | 30 +++++++++++-------------------
src/test/regress/expected/privileges.out | 16 ++++++++++++++++
src/test/regress/sql/privileges.sql      | 17 +++++++++++++++++
3 files changed, 44 insertions(+), 19 deletions(-)



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

* pgsql: In REFRESH MATERIALIZED VIEW, set user ID before running user co
@ 2022-05-09 15:37  Noah Misch <noah@leadboat.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Noah Misch @ 2022-05-09 15:37 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

In REFRESH MATERIALIZED VIEW, set user ID before running user code.

It intended to, but did not, achieve this.  Adopt the new standard of
setting user ID just after locking the relation.  Back-patch to v10 (all
supported versions).

Reviewed by Simon Riggs.  Reported by Alvaro Herrera.

Security: CVE-2022-1552

Branch
------
REL_12_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/880511cb0bdfd75a29ada6b80bf6e4efe6bc27b4

Modified Files
--------------
src/backend/commands/matview.c           | 30 +++++++++++-------------------
src/test/regress/expected/privileges.out | 16 ++++++++++++++++
src/test/regress/sql/privileges.sql      | 17 +++++++++++++++++
3 files changed, 44 insertions(+), 19 deletions(-)



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

* pgsql: In REFRESH MATERIALIZED VIEW, set user ID before running user co
@ 2022-05-09 15:37  Noah Misch <noah@leadboat.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Noah Misch @ 2022-05-09 15:37 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

In REFRESH MATERIALIZED VIEW, set user ID before running user code.

It intended to, but did not, achieve this.  Adopt the new standard of
setting user ID just after locking the relation.  Back-patch to v10 (all
supported versions).

Reviewed by Simon Riggs.  Reported by Alvaro Herrera.

Security: CVE-2022-1552

Branch
------
REL_13_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/88743d581e1bdedc13e4ca33c5a6597a5d2dbdc4

Modified Files
--------------
src/backend/commands/matview.c           | 30 +++++++++++-------------------
src/test/regress/expected/privileges.out | 16 ++++++++++++++++
src/test/regress/sql/privileges.sql      | 17 +++++++++++++++++
3 files changed, 44 insertions(+), 19 deletions(-)



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

* pgsql: In REFRESH MATERIALIZED VIEW, set user ID before running user co
@ 2022-05-09 15:37  Noah Misch <noah@leadboat.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Noah Misch @ 2022-05-09 15:37 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

In REFRESH MATERIALIZED VIEW, set user ID before running user code.

It intended to, but did not, achieve this.  Adopt the new standard of
setting user ID just after locking the relation.  Back-patch to v10 (all
supported versions).

Reviewed by Simon Riggs.  Reported by Alvaro Herrera.

Security: CVE-2022-1552

Branch
------
REL_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/677a494789062ca88e0142a17bedd5415f6ab0aa

Modified Files
--------------
src/backend/commands/matview.c           | 30 +++++++++++-------------------
src/test/regress/expected/privileges.out | 16 ++++++++++++++++
src/test/regress/sql/privileges.sql      | 17 +++++++++++++++++
3 files changed, 44 insertions(+), 19 deletions(-)



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


end of thread, other threads:[~2022-05-09 15:37 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-05-09 15:37 pgsql: In REFRESH MATERIALIZED VIEW, set user ID before running user co Noah Misch <noah@leadboat.com>
2022-05-09 15:37 pgsql: In REFRESH MATERIALIZED VIEW, set user ID before running user co Noah Misch <noah@leadboat.com>
2022-05-09 15:37 pgsql: In REFRESH MATERIALIZED VIEW, set user ID before running user co Noah Misch <noah@leadboat.com>
2022-05-09 15:37 pgsql: In REFRESH MATERIALIZED VIEW, set user ID before running user co Noah Misch <noah@leadboat.com>
2022-05-09 15:37 pgsql: In REFRESH MATERIALIZED VIEW, set user ID before running user co Noah Misch <noah@leadboat.com>
2022-05-09 15:37 pgsql: In REFRESH MATERIALIZED VIEW, set user ID before running user co Noah Misch <noah@leadboat.com>

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