Thursday, March 15, 2007

db link passwords

To work out what database links are using what passwords, run the following sql.

select name,ctime,host,userid,password from sys.KU$_DBLINK_VIEW;

This should work upto 10G.