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
Hai Puthick,
On Apr 23, 2015, at 09:53, Puthick Hok hputhick@gmail.com wrote:
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";
Did these queries succeed?
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 do you mean exactly with "cannot use"? Did you get any error messages like permission denied or something?
While MonetDB version are you using, on what OS?
Regards,
Jennie
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
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Hi Jennie,
Ying Zhang wrote:
Hai Puthick,
On Apr 23, 2015, at 09:53, Puthick Hok hputhick@gmail.com wrote:
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";
Did these queries succeed?
All these queries succeed. I can use 'mdb_user' for everything, except 'COPY INTO table from file'. I got:
COPY INTO: insufficient privileges: COPY INTO from file(s) requires database administrator rights, use 'COPY INTO "markerdata11" FROM STDIN' instead
My question is how to create a user in MonetDB with the administrator rights which can run 'COPY INTO table from file'.
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 do you mean exactly with "cannot use"? Did you get any error messages like permission denied or something?
While MonetDB version are you using, on what OS?
My MonetDB is MonetDB-11.19.9 compiled from source on openSuSe 12.2.
Regards,
Jennie
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
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Puthick Hok -
Ying Zhang