In article <362AE3BB.6CAE_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.
>
You can also have all connections made through the same userid and track what
users are doing by the osuser field. The userid / password would be encrypted
in the client code. That way you'd need neither.
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Oct 19 1998 - 15:55:47 CDT
