Hi everybody! I need to create several users of the database: each user should be able to connect in Oracle-mode, create, handle and delete tables in his/her own work-space.
So far i've managed to properly create each user (from the DB Manager command line, or from the cli) [ user_create xxx,yyy ] and set properties [ user_put xxx sqluser=yes ] [ user_put xxx sqlusermode=resource ] or [ user_put xxx sqlusermode=dba ] [ user_put xxx dbmuser=yes ] in a way the user is seen in DB Manager, can logon in SQL Studio and work in reserved space. What such a user can't do is to switch to Oracle SQL Mode (in SQL Studio) or to connect to database in Oracle mode via jdbc. Which seems to be a unique privilege of the DBA. Where am i wrong? Andrea _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
