Thread: ANT Script: Protecting passwords
12-26-07, 17:05 #1Registered User
- Join Date
- Dec 2007
Unanswered: ANT Script: Protecting passwords
On a Windows platform, I have to create an ANT script that executes several SqlPlus scripts. I've selected sqlplus to do the job so the command line will be in the form of : sqlplus uname/passwd@database @scriptname.sql
The problem is that I'm not a big fan of putting passwords in script files. So I've constructed a build.xml with my sqlplus command line and all of it's parameters but I want to keep the passwords safe. I need to get them from some other file. Preferably encrypted! I've thought that I could set them in the environment, but thats not really much more secure that keeping them in the script file.
Anyone out there know of a better way to keep passwords safe and at the same time have the ability to pass them to an ANT script? What are the "Best Practices" for this sort of thing?
12-26-07, 23:49 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
>What are the "Best Practices" for this sort of thing?
Do NOT use passwords, period.
The scripts should be run directly on the database server system using Operating System Authentication & then no passwords are required.
http://download.oracle.com/docs/cd/B....htm#sthref141You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.