Oracle Database Discussions

Hi , i am using oracle 10.2.0.4.

I just imported some data, and one of objects imported was using a dblink:

IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "USR_CONTROLFIN"."FGF_TEMP_RUBRICA" ("RU"
"BRO","DESCRIPCION") AS "
"select rubro,"
" descripcion"
" from rubros@abc"

I just want to know if there is a way to retrieve the password used on dblink?
Example:

CREATE DATABASE LINK abc
CONNECT TO hr IDENTIFIED BY hr
USING 'abc';


It is possible to get the parameters for this dblink? i checked at dba_db_links view:
OWNER DB_LINK USERNAME HOST CREATED
---------------------------------------------------------------------------
PUBLIC abc ISSR GF 16/11/2008




Above i got only the HOST, there is a way to get the username hr and/or the password for hr ?

I am afraid that some people get this information and access the database for this dblink. I know i could remove the dblink, but i am trying to improve my knowledge with this information.

Thanks in advance.

thanks

Edited by: BSalesRashid on 30/05/2012 06:02