MIME-Version: 1.0
In-Reply-To: <52A8F55B.9010308@comcast.net>
References: <20131210060515.6A674268E5@turing.freelists.org>
 <52A8F55B.9010308@comcast.net>
Date: Thu, 12 Dec 2013 14:54:51 -0500
Message-ID: <CAGurbTMJHM_w+MtuNttU_9isaYTxDx8p2h8TQyFYwwE-T=ZKHA@mail.gmail.com>
Subject: Re: Private Synonyms
From: rjamya <rjamya@gmail.com>
To: rjgoulet@comcast.net
Cc: Oracle-List <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary=e89a8ff1c748faa8c104ed5bb742
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: rjamya@gmail.com
--e89a8ff1c748faa8c104ed5bb742
Content-Type: text/plain; charset=ISO-8859-1

I ran dbms_utility.name_resolve as user2 and passed in 'USER1.EMP' as a
parameter, oracle did come back pointing to owner as 'SCOTT' and table name
as 'EMP'. So based on privileges, it did figure out the correct object_name
underneath.

in my case I had my id own the table, user1 and user2 were created, user1
had a synonym emp_new pointing to emp. oracle came back resolving
user1.emp_new to emp table in my schema.

Raj

--e89a8ff1c748faa8c104ed5bb742
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I ran dbms_utility.name_resolve as user2 and passed in =
9;USER1.EMP&#39; as a parameter, oracle did come back pointing to owner as =
&#39;SCOTT&#39; and table name as &#39;EMP&#39;. So based on privileges, it=
 did figure out the correct object_name underneath.<div>
<br></div><div>in my case I had my id own the table, user1 and user2 were c=
reated, user1 had a synonym emp_new pointing to emp. oracle came back resol=
ving user1.emp_new to emp table in my schema.<br><div><br></div><div>Raj</d=
iv>
<div class=3D"gmail_extra"><br></div></div></div>

--e89a8ff1c748faa8c104ed5bb742--
--
http://www.freelists.org/webpage/oracle-l