Re: Private Synonyms

From: rjamya <rjamya_at_gmail.com>
Date: Thu, 12 Dec 2013 14:54:51 -0500
Message-ID: <CAGurbTMJHM_w+MtuNttU_9isaYTxDx8p2h8TQyFYwwE-T=ZKHA_at_mail.gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 12 2013 - 20:54:51 CET

Original text of this message