Different ways of setting up a multi user database.

I have created a database containing about 30 tables to be accessed by 60 users. All the tables that are to be access by all users will be stored in one schema. The client will be a Visual Foxpro interface accessing the Oracle database through ODBC. Which is better:

1. Create synonyms for each table in the database in each user account, thus not requiring to include the schema name for every object referenced in the client code
2. Make all client code accessing the database include the schema name. (Thus not requiring the use of synonyms).

I know this is a very open ended question however I just want some opinions on both the above methods relating to proper client-server design and security.

I would welcome any other ideas/methods as well.

Thanks in advance

George. Received on Mon Oct 19 1998 - 02:01:15 CDT