How can I use synonyms for reference of object type in table?
I am using an object type in my table. I want to access the table from different user using a synonym.
I have one table EMP (empid number, audit_trail audit_trail_obj) where audit_trail_obj is an Oracle object type embedded in EMP table.
Now if I want to access the same table from different user thru a synonym, what should be the process to do so?
Thanx in advance,