Re: Refer other oracle schema.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 28 Dec 2005 08:04:21 +0100
Message-ID: <i5e4r1t2ktvt87i0935m8ja603do2m7ku9@4ax.com>

On 27 Dec 2005 16:59:26 -0800, "B" <bhawin13_at_gmail.com> wrote:

>Sir,
>
>I have already granted select to l1 of both schema table l2.t1 and
>l3.t1.
>
>When executes query how oracle decides schema if schema is not
>specified in query?
>
>Thanks & Regards
>B

1 look for a table in the schema of the user 2 look whether there is a private synonym 3 look whether there is a public synonym

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Dec 28 2005 - 01:04:21 CST