User cannot insert into own local temporary table #6628
Last updated: 2018-08-31 13:23:26 +0200
Date: 2018-07-19 11:23:35 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36
I admit I always had a hard time with SQL roles and permissions, so perhaps it's just me doing something wrong.
If I create a user (with admin privileges), and the user operates in its own schema:
CREATE USER "spinque" WITH UNENCRYPTED PASSWORD '123456789' NAME 'Spinque user' SCHEMA "sys";
Then login as this user, this happens:
The user can create the table in schema 'tmp', but not write into it.
My understanding was that regardless of roles and privileges explicitly assigned, users always has full rights on the tables that they create. This doesn't seem to be true for tables created in a different schema.
$ mserver5 --version
Date: 2018-07-27 10:18:48 +0200
For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=c65a60e3b9cb
The text was updated successfully, but these errors were encountered: