RE: password and dblink mgmt tool
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 2 Mar 2005 10:01:23 -0500
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
>
>
>--
>//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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
