issue granting administrator rights
I have successfully managed to configure multi-user access to my user defined schema. All the users are granted monetdb “rights with:
GRANT monetdb TO user1
Once logging the new user has ability to SELECT / DROP / INSERT etc. in the user schema.
Sadly at the time of executing the MonetDB.R command:
tStatus <- dbWriteTable(conn, tPFile, dataDt,overwrite=TRUE, csvdump=TRUE)
I’ve got:
Unable to execute statement 'COPY OFFSET 2 INTO demand FROM '/Users/xxx/demand.csv' USIN...'. Server says '!COPY INTO: insufficient privileges: COPY INTO from file(s) requires database administrator rights, use 'COPY INTO "demand" FROM STDIN' instead'
So clearly GRANT monetdb TO user1 is not enough to empower user1.
I tried:
GRANT monetdb to “user1" WITH ADMIN OPTION;
But at this point after:
SET SCHEMA cleveland; SET ROLE monetdb;
I get error "Role (monetdb) missing”
It does not seem correct to me: surely it should be possible to grant rights to a user at the same level of “monetdb”, including administrator rights?
Enzo enzo@smartinsightsfromdata.com
participants (1)
-
Enzo