passing database password to isql command in shell script

Shell Programming and Scripting
1

Hi,

I need to connect to DB through my shell script. but I dont want to hardcode my db password in the script. Is there a way to do it?

Thanks

---------- Post updated at 07:42 PM ---------- Previous update was at 04:54 PM ----------

:(Guys..please help me with this:(

2

very unlikely, although you'd probably be able to obfuscate it somewhat...

One option I've seen used is to provide a secondary script that is sourced into use, which actually provides the password. It serves to abstract the password from general population (that would be accessing your primary SQL file), but as with any command line parameter, it's still visible from any ps listing. Sort of like moving the password from the script, but putting it within easy reach of anyone with command line access.

You could also look into maybe setting up an ssh Tunnel that would effectively broker the call for you, but I've not done it myself either, so that's pretty much conjecture.