DB Link, How to created DB Link Options

[churamanidba]

Hi,

for creating a db link, How to get the encrypted password
here is an example
create public database link "TEST1.UNIX.190.ORG"
connect to "scott" identified by values '053E6879854B7744F64396350297E1D6EF191163AE35216E64'
using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.30.20.20)(PORT=1521))(CONNECT_D
ATA=(SID=SID1)))';


where or how to get the encrypted password(Pink colored above) to create db link.

Thanks
Churamani

[burleson]

Hi Churamani,

>> where or how to get the encrypted password

Good question!

You have to type it in when you create it, but you can then encrypt the table column where the db-link is stored.

The password for the database link is then stored in the data dictionary:

CODE

col link for a30
col username for a10
col host for a20
col owner for a10
select l.name link, l.userid username, l.host, l.ctime created, u.name owner,
l.password
from sys.link$ l, sys.user$ u
where l.OWNER# = u.USER#;

I get

LINK USERNAME HOST OWNER PASSWORD
--------------- ---------- -------------------- -------------------- --------
DHC9_C CDHC DHC_C.WORLD CDHC CDHC2005
DHC9_C CDHC DHC_C.WORLD HR_DDHC CDHC2005
DHC9_C CDHC DHC_C.WORLD HR_TEAM CDHC2005
DHCPRIVATE CDHC DHC.WORLD HIR CDHC2005

See here, how to encrypt the password for a database link:

http://www.dba-oracle.com/t_password_hidin...ion_db_link.htm

[churamanidba]

Thanks Donald..This Helped me..