As I stated above, I cannot make use public database link.

As I need to use only private database link (that will be create without giving password at the
time of creating DB Link). Even though I create any object in USER1 that uses DB Link. Even though
the other users have access objects of USER1, they are unusable as Oracle is throwing me an error
ORA-01017: invalid username/password; logon denied

Regards

Shanker