Encrypt Password to connect to the back-end database

[bheemsen]

We have lots of Shell scripts where the password is hardcoded to
connect to the database(Oracle): Ex: sqlplus username/password

The password should not be in clear text & should be encrypted before
connecting to the backend. Oracle will not take encrypted passwords in my opinion to connect to the database.


I want to encrypt this hardcoded password & decrypt it to connect to the database. Can anyone help me or point me to links showing some examples.

Thanks
-Bheem

 

[PHV]

man crypt

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SamBones]

One small change you can make is to just get the username and password off the command line. If you start it like "[tt]sqlplus user/pass[/tt]", it will be visible from a [tt]ps[/tt] command. Try changing it to this...

sqlplus -nolog <<-SQLCMDS
connect user/pass ...

SQLCMDS

That keeps them off the command line.