SQL & PL/SQL

I'm logged on database EMSDB.D710.DE and created a database link to EMSDB.D999.DE with current_user(...same user, same credentials I'm logged in). When I tried to use that created link I get the errorcode:"ORA-01017: Benutzername/Kennwort ungültig; Anmeldung abgelehnt". What I don't understand is, why I can connect to EMSDB.D999.DE --- but not access to the same database with a database link???

SELECT	'EMSDB.D999.DE'               REMOTE_DB   --NAME OF DATABASE  
FROM DUAL;

VARIABLE VAR_REMOTE_DB VARCHAR2(15);
BEGIN 
    :VAR_REMOTE_DB := '&REMOTE_DB';
END;
/
SELECT  :VAR_REMOTE_DB                REMOTE_DB     
FROM DUAL;

CREATE DATABASE LINK &REMOTE_DB CONNECT TO CURRENT_USER USING '&REMOTE_DB' ;

SELECT TABLE_NAME FROM ALL_TABLES@&REMOTE_DB;

output

SQL> @test

REMOTE_DB
-------------
EMSDB.D999.DE

REMOTE_DB
--------------------------------
EMSDB.D999.DE
SELECT TABLE_NAME FROM ALL_TABLES@EMSDB.D999.DE
                                  *
FEHLER in Zeile 1:
ORA-01017: Benutzername/Kennwort ungültig; Anmeldung abgelehnt


SQL>

Edited by: user5116754 on 22.02.2011 04:33