Creating Synonym and available schema
467819Nov 15 2005 — edited Nov 16 2005HI all
I have two schemas and a I would like to create a private synonym from schema1 to schema2. ButwWhen using the WEB interface for creating the synonym[b] I only see my own schema in the field "schema". normally I would expect to see all schema as when using TOAD.Although Creating a synonym using a DBLInk seems to work I am not able to see others schemas as mine. Furthermore when creating the synonym the tableowner attribute of the user_synonyms table is not feeded with the owner of the objects referenced in the synonym.
Practically : Assume user1 and user2 the 2 schemas
I want a private synonym in schema2 referrencing table1 in schema1. When the creating synonym in schema2 (WEB interface http:/.../htmldb) I can only select schema2 as object owner (UI Section "Create Synonym on:" Schema dropdown box).
But at the contrario when using tool like aquastudio TOAD , TORA I can choose between the different schemas available.. as expected...
Any idea why such behavior would be really welcome..
Cheers
Jan