pgsql: Check for INSERT privileges in SELECT INTO / CREATE TABLE AS. - Mailing list pgsql-committers

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(-)