]> git.ipfire.org Git - thirdparty/postgresql.git/commit
In REFRESH MATERIALIZED VIEW, set user ID before running user code.
authorNoah Misch <noah@leadboat.com>
Mon, 9 May 2022 15:35:08 +0000 (08:35 -0700)
committerNoah Misch <noah@leadboat.com>
Mon, 9 May 2022 15:35:12 +0000 (08:35 -0700)
commit880511cb0bdfd75a29ada6b80bf6e4efe6bc27b4
tree7e30a4c76ae06d8a3bd95ab28aa73d78a54a2790
parent7f098f7b53edfe8340c6e031bf497308a2e65e2e
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
src/backend/commands/matview.c
src/test/regress/expected/privileges.out
src/test/regress/sql/privileges.sql