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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Hemant K Chitale
Sent: Wednesday, March 02, 2005 9:43 AM
To: Les.Hollis@xxxxxx; Tony.Vecchiet@xxxxxxxxxx; 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.

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
>
>
>--
>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

Other related posts: