Re: DBLINK ISSUE
- From: Nagaraj S <nagaraj.chk@xxxxxxxxx>
- To: Jack van Zanen <jack@xxxxxxxxxxxx>
- Date: Thu, 24 Mar 2011 10:38:59 +0530
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
>>
>>
>>
>
>
Other related posts:
