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

Home -> Community -> Usenet -> c.d.o.misc -> Different ways of setting up a multi user database.

Different ways of setting up a multi user database.

From: George <info_at_expohire.com.au>
Date: Mon, 19 Oct 1998 17:01:15 +1000
Message-ID: <362AE3BB.6CAE@expohire.com.au>


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

Original text of this message

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