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

From: <reidlai_at_hk.super.net>
Date: Tue, 20 Oct 1998 08:59:56 GMT
Message-ID: <70hjeb$ubb$1@nnrp1.dejanews.com>

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

Why don't you use public synonym? Is it difficult to use in your project?

>
> 2. Make all client code accessing the database include the schema name.
> (Thus not requiring the use of synonyms).
>

If you really care synonym, you should use public synonym or a trick as follow:

Before executing any queries, ALTER SESSION SET CURRENT_SCHEMA= your_target_schema (no quote and no space).

E.g. ALTER SESSION SET CURRENT_SCHEMA=SYS.

Please be careful to use the above statement which is not recommended by Oracle.

Best Regards,

Reid Lai

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 20 1998 - 03:59:56 CDT