RE: Passwords in Scripts

I have been using the External Password Store in 10.2. I havent tried it out with multiple unix user accounts only the oracle account but by using different services in our databases I connect as a different oracle users it works well for running automated rman scripts as I can connect to target auxiliary and catalog for duplication and there is not a password in site.
I guess we can use tns_names set to individual locations for each user if we need to get fancy

Each client system can have its own password store and therefore its possible to give a user access to a store of passwords which he doesn't have any knowledge of. Alternatively you can have a single file accessible by all client systems

Cheers

Peter

-----Original Message-----

From: MacGregor, Ian A. [mailto:ian_at_slac.stanford.edu] Sent: Thursday, 21 June 2007 04:16 AM
To: fmhabash_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: RE: Passwords in Scripts

Thanks, the DBA management scripts are not a problem. Those on the database server itself, except for those which need to talk to the rman catalog have no passwords.

The problem is with client programs. Access to physics papers and data for analyis for collaboration members, data which needs to be public, that sort of thing.

Ian

Fred Habash (OCP 8i,9i)
ACS Healthcare
Off: 248-226-8778
http://www.acs-inc.com/index.html  

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of fmhabash Sent: Wednesday, June 20, 2007 9:46 AM
To: MacGregor, Ian A.
Cc: oracle-l_at_freelists.org
Subject: Re: Passwords in Scripts

I personally developed all my DBA management tools using PERL for
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jun 20 2007 - 17:56:03 CDT