Hi Massimo, you wrote : > I can connect to the database only with "dba" user. > In the DBMGui I've created a new user with all permission > (the same of dba), > but I can't use it: > [SAPAG][SQLOD32 DLL][SAP DB]Invalid authorization > specification;-4008 POS(1) > Unknow user name/password combination
the users created with dbmgui are administrative users , they cannot connect to the db via *dbc (e.g. using SQLStudio) the only exception from this is the "database system administrator" (which you apparently named "dba"). "ordinary users" have to be created with a "create user" statement in sql (e.g. using SQLStudio, cf. my direct mail from this morning). That means : connect as "dba", create a user(which is then "owned" by "dba"), this user can then connect via a query tool (and, if privileged (see docs, "create user" stmt), create users of its own), etc. . regards, Markus Stausberg SAP Labs Berlin > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
