users & indexes

[Arne Gehlhaar]

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!?!

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

--
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