Originally posted by PsudoDBA

If another user for eg. scott1 in db02 want access the same tables from db01, how the access can be done. It is the existing db_link can be used since the db_link is a public db_link? But right now the scott1 is unable to access the table from db01.
I read this as follows:

db1 has user SCOTT
db1 has a dblink to db2
db2 has SCOTT1

SCOTT read tables in db2, but now SCOTT1 wants to read data in db1. To do this he wants to use the dblink that was created in db1.

Am I correct?

As far as I know, DB Links only work one way... So, if you want SCOTT1 to read from DB1, you must create a dblink in db2 pointing to db1.

HTH,

Erik