The problem is on the M5 layer. I'll look into it. On 30-10-2006 11:56:49 +0100, Romulo Goncalves wrote:

Dear developers,

I created a user, schema and I set the new schema for the new user:

CREATE SCHEMA "test" AUTHORIZATION "public";

CREATE USER "monet_test" WITH PASSWORD 'pass_test' NAME 'TEST USER' SCHEMA "sys";

ALTER USER "monet_test" SET SCHEMA "test";

Then I connect the new user with a mclient:

[goncalve@amelia Dependencies]$ mclient -umonet_test -Ppass_test MAPI = monet_test@localhost:50000 ACTION= mapi_start_talking ERROR = !InvalidCredentialsException:checkCredentials:Invalid credentials for user 'monet_test' [goncalve@amelia Dependencies]$

What is the problem with the user creation? The authorization for the schema is public this means that any user can use the schema "test". I am right or wrong?

I will appreciate some help.

Best Regards, Romulo Goncalves

------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers