Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Know schema name from Synonyms

433024Jan 14 2009 — edited Jan 14 2009
Hi,

How can we get the schema name from Synonyms?

e.g.
I am DATA user and accessing objects from HR user using synonym.

I am directly selecting data using these synonym.

But I want to know list of other schema from where I am accessing data using synonyms.

Regards,
RSD
This post has been answered by _Dylan_ on Jan 14 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 11 2009
Added on Jan 14 2009
#sql
2 comments
281 views