Check for INSERT privileges in SELECT INTO / CREATE TABLE AS.
In the normal course of events, this matters only if ALTER DEFAULT
PRIVILEGES has been used to revoke default INSERT permission. Whether
or not the new behavior is more or less likely to be what the user wants
when dealing only with the built-in privilege facilities is arguable,
but it's clearly better when using a loadable module such as sepgsql
that may use the hook in ExecCheckRTPerms to enforce additional
permissions checks.
KaiGai Kohei, reviewed by Albe Laurenz
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/f1b4aa2a84732255bd8a34fc9c7994a04409b77a
Modified Files
--------------
src/backend/executor/execMain.c | 17 ++++++++++++
src/test/regress/expected/select_into.out | 39 +++++++++++++++++++++++++++++
src/test/regress/sql/select_into.sql | 37 +++++++++++++++++++++++++++
3 files changed, 93 insertions(+), 0 deletions(-)