Re: DBLINK ISSUE

From: Nagaraj S <nagaraj.chk_at_gmail.com>
Date: Thu, 24 Mar 2011 10:38:59 +0530
Message-ID: <AANLkTimkaXngP=ywZVjzFZQkw+bjdHwL9MrLnSFSiUan_at_mail.gmail.com>



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_at_vanzanen.com> 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_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:08:59 CDT

Original text of this message