Hello, On Freitag, 10. Januar 2003 11:45, Arne Gehlhaar wrote: > Hi, > > I've played around with SAPDB for some time now, and there are still two > things that the user manual does not really help me with: > > 1) USERS: When I create a new database there are two users (DBM and > SYSDBA). In the database manager I can create new users which show up in > blue. These should be DBA users which can create RESOURCE users. > However, with this DBA user I cannot log on with the SQL stutio, because > he does not have SQL rights. In the dbmcli I had to manually do > "user_put DBA SQLUSER=YES" in order to be able to use the SQL Studio. > But still I cannot create RESOURCE users: > Syntax error or access violation;-5001 POS(1) Missing privilege:DBA. > What are the blue users for? They can't do SQL and the can't create > RESOURCE users!?! > for this question you max check the archive. There has been some discussion around. If you want to create sql users that need not to have dbm properties, you may create them with sql (create user statement). There are several types of sql users (dba, resources, standard), and only dba users may create other users.
Peter Willadt > 2) FOREIGN KEYS and INDEXES. I use Sybase Power Designer for database > design. For some reason, it let's me either use foreign key constrains > (ref. integrity) XOR build indexes on foreign keys. Does this make any > sense from SAPDB's point of view? Will indexes on foreign keys increase > perfomance when joining tables or does SAPDB use foreign keys as > efficiently as primary keys? > > Thanks for the help, > Arne _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
