RE: password and dblink mgmt tool

Hemant, a global database link does not use a userid and password in the database; it gets the logon information from an external source and requires that Oracle Names (prior to version 10g) or LDAP be in use. As such since most Oracle sites use neither I do not think this is a workable solution in very many cases.

HTH -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hemant K Chitale
Sent: Wednesday, March 02, 2005 9:43 AM
To: Les.Hollis_at_ps.net; Tony.Vecchiet_at_xilinx.com; Oracle-L Subject: 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} 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_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
--
http://www.freelists.org/webpage/oracle-l