RE: password and dblink mgmt tool

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.

1. That would mean an account would have the same password in all the databases {ie, all the databases connected by dblinks using that account}
2. 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_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org] 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
>
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>--
>http://www.freelists.org/webpage/oracle-l

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

--
http://www.freelists.org/webpage/oracle-l