Hello, now I got it up and running :-)
But I still have a few questions, probably easy to answer: 1. why doesn't sapdb like my statement separators? "select * from users" works, "select * from users;" doesn't: [SAP AG][LIBSQLOD SO][SAP DB]Syntax error or access violation;-3014 POS(20) Invalid end of SQL statement. It gives me this in both cases: when I use the web administration tool, and when I use ODBC. Is there something I missed? 2. how can I prevent users from changing their usernames? (rename <myself> to <othername>) I didn't find anything on that in the documentation, and all my tries like "revoke update on domain.users from <user>" and similar failed (both as user dba and domain). Is there some way to prevent users from changing their names? 3. What is that 33%? When I use the webdbm tool to have a look at my databases, what exactly does the "state" graph show? My database is 480000 kb, and only a few bytes have been used. Still, the graph shows 33%. When I click on "Data" however, the correct usage is shown (100% free). I have a screenshot of this at http://members.rosenkeller.org/~christoph/sapdbscr.gif if you want to see it) Or is that some sort of bug? 4. Can I actually _do_ anything as the user "domain"? I have tried logging on as different users, including "domain". This one is strange because it doesn't get the fancy menus and all, just a plain SQL input window. And all I can do is select etc. (no updates/inserts...). So what is this user for?... Thank you for your help, and have a nice weekend :-) Christoph _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
