Re: Different ways of setting up a multi user database?

You could create public synonyms, so you don't have to create them in each user's schema.

Rolf

George wrote:
>
> 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 - 07:44:24 CDT