In the original post it says:
So it seems to me that SCOTT is in DB02 and SCOTT1 is also in DB02.The objects in db01 are accessible to scott(a schema for eg) in db02 using a public dblink unthenticated by scott.
If another user for eg. scott1 in db02 want access the same tables from db01




Reply With Quote