Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Different ways of setting up a multi user database?

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

From: Karel de Geus <karel.degeus_at_nl.eds.com>
Date: Tue, 20 Oct 1998 12:00:19 +0200
Message-ID: <362C5F33.FD3@nl.eds.com>


George,

Another option is to create public synonyms for these objects and to create a role with access to these tables and grant this role to your users.

aashar_at_yahoo.com wrote:
>
> 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 Tue Oct 20 1998 - 05:00:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US