Help - Search - Members - Calendar
Full Version: DB Link
Oracle DBA Forums > Oracle > Oracle Forum
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..smile.gif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.