I don't think that "global db links" created by using the same username/password pair across all databases would satisfy auditors -- it wouldn't satisfy me. a. That would mean an account would have the same password in all the databases {ie, all the databases connected by dblinks using that account} b. I cannot be flexible in account names. By "flexible", I mean that I use database link names to identify which database they connect to and account names used by the database links to identify where they came from. Hemant At 08:46 AM Wednesday, Hollis, Les wrote: >Use global db links and you don't have to worry about passwords.... > >None required to create the link. > >-----Original Message----- >From: oracle-l-bounce@xxxxxxxxxxxxx >[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Tony Vecchiet >Sent: Tuesday, March 01, 2005 3:56 PM >To: Oracle-L >Subject: password and dblink mgmt tool > >hi, >does anyone have a tool to manage schema passwords and dblinks? >For SOX all apps have to rotate their passwords every 6 months, which >means changing all their dblinks too. >Also, any time a clone to test or dev is done, all the passwords have to >change and all the >dblinks too. >thanks >tony > > >-- >//www.freelists.org/webpage/oracle-l > >-- >//www.freelists.org/webpage/oracle-l Hemant K Chitale http://web.singnet.com.sg/~hkchital -- //www.freelists.org/webpage/oracle-l