Re: DBLINK ISSUE

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Thu, 24 Mar 2011 16:07:21 +1100
Message-ID: <AANLkTik-OzMF3VdLMT=Q+11m7GpWHM5LxEMMm9Hk_d9X_at_mail.gmail.com>

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_at_gmail.com> 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_at_B.pln.gar.com;
> 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_at_B.pln.gar.com;
> select * from dual_at_B.pln.gar.com
> *
> ERROR at line 1:
> ORA-01017: invalid username/password; logon denied
> ORA-02063: preceding line from B
>
> -Naga
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 24 2011 - 00:07:21 CDT