yes it was set up to use the current credentials. However "zing" user able to access the link were as other users getting error. -Naga On Thu, Mar 24, 2011 at 10:37 AM, Jack van Zanen <jack@xxxxxxxxxxxx> wrote: > Was the link possibly setup so that the current credentials are used? > > > Jack van Zanen > > ------------------------- > This e-mail and any attachments may contain confidential material for the > sole use of the intended recipient. If you are not the intended recipient, > please be aware that any disclosure, copying, distribution or use of this > e-mail or any attachment is prohibited. If you have received this e-mail in > error, please contact the sender and delete all copies. > Thank you for your cooperation > > > On Thu, Mar 24, 2011 at 3:57 PM, Nagaraj S <nagaraj.chk@xxxxxxxxx>wrote: > >> Hello Gurus, >> >> DBLINK is working for one particular user, were as it is not working for >> other users. Kindly help me to sort out the problem >> >> >> SQL> select name from v$database; >> NAME >> --------- >> A >> SQL> show user >> USER is "zing" >> SQL> select * from dual@xxxxxxxxxxxxx; >> D >> - >> X >> where as if i select as sys or any other user i am getting below error >> SQL> connect / as sysdba >> Connected. >> SQL> select * from dual@xxxxxxxxxxxxx; >> select * from dual@xxxxxxxxxxxxx >> * >> ERROR at line 1: >> ORA-01017: invalid username/password; logon denied >> ORA-02063: preceding line from B >> >> -Naga >> >> >> > >