Re: DBLINK ISSUE

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
>
>
>

Other related posts: