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

From: <aashar_at_yahoo.com>
Date: Mon, 19 Oct 1998 18:09:48 GMT
Message-ID: <70fv9d$mr9$1@nnrp1.dejanews.com>

I prefer first method as for any reason if you need to change name of the schema then you will have to change it in all the programs and recompile it.

In article <362AE3E9.33F8_at_expohire.com.au>, info_at_expohire.com.au 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.
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Oct 19 1998 - 13:09:48 CDT