Hi Arne, > The next problem I have is that the users I create with the Database > Manager GUI have no right to create tables or even to select from > existing tables, and I have found no way to grant the rights > using the > GUI. So I guess I'll have to read the docs, but which ones? The "User > Manual", the "Database Manager GUI", the "Database Manager > CLI" or the > "Reference Manual" ??? Can someone give me a hint please.
the users you create with DBMGui are for admin purposes only. except the SYSDBA they can't even connect via *DBC (SQL Studio , e.g.). use an SQL tool (e.g. SQL Studio) to connect as SYSDBA (or whatever you named the "Database System Administrator") and create ordinary users with a 'create user' stmt. in almost all cases you want to create them as 'not exclusive' and (at least) 'resource' users (cf. the documentation :\) (take a look e.g. at what the "SQL Reference" tells about the 'create user' stmt) ). regards Markus Stausberg SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
