One more piece of information that would have been very helpful at the time is that you have to use the INTERNAL sql mode to be able to create users. For some reason I thought using ANSI mode as default would be a good idea (compatability etc.) but it wasn't. Even if these 'traps' are very well hidden, trust that *someone* will find them :-)That's something many SAP DB users have experienced I'm sure. The answer is that the users you create through the DBMGUI are not SQL users.What you have to do is to log in using DBA, and then create the users using the CREATE USER statement. The typical command to do this is: CREATE USER the_username PASSWORD the_password RESOURCE NOT EXCLUSIVE
Arne
--
Institute of Shipping Economics and Logistics http://www.isl.org/
Arne Gehlhaar mailto:[EMAIL PROTECTED]
Universitaetsallee GW1 Block A phone:+49.421.22096.49
D-28359 Bremen, Germany fax:+49.421.22096.55
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
