Hi,
I wan to use "COPY INTO table from 'file'" SQL instruction with a user
rather than monetdb. This user needs the administrator rights. So far I
have done these using monetdb user as the login:
CREATE USER "mdb_user" WITH PASSWORD '"password"' NAME 'Test db user'
SCHEMA "sys";
CREATE ROLE "testdbadmin" WITH ADMIN CURRENT_USER;
GRANT "testdbadmin" TO "mdb_user" WITH ADMIN OPTION;
CREATE SCHEMA "testdb" AUTHORIZATION "mdb_user";
ALTER USER "mdb_user" SET SCHEMA "testdb";
I learnt this from MonetDB UserGuide tutorial and from MonetDB
authorisation documentation. However, I still cannot use 'mdb_user' for
COPY INTO from file command. What is missing? What does 'ADMIN OPTION'
do? How to make 'mdb_user' have the same right as monetdb?
At the moment, I'm using monetdb user directly. But, it would be a bit
nicer to have a different username. I'm working on a web service
connecting to 3 different databases: mysql, postgres and now monetdb.
They have a common username for the database connection. If I keep using
monetdb user, the commonality rule is broken. I have another to use
'mdb_user' via STDIN and piping, but exporting DOTMONETDBFILE as an
environment variable to make mclient login with out asking for password
is another complexity dimension.
Making mdb_user to have administrator rights like monetdb is the best
option for me if this is possible, and I hope this is possible.
Regards,
Puthick
