Re: Private Synonyms

From: rjamya <>
Date: Thu, 12 Dec 2013 14:54:51 -0500
Message-ID: <>

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.


Received on Thu Dec 12 2013 - 20:54:51 CET

Original text of this message