[Q] about hiding command line password in UNIX

Hi Folks,

When invoking SQL scripts with parameters (&1,&2...), from the operating system, I specify the parameters on the command line. Since some of the scripts have several 'CONNECT' statements, I pass passwords of user accounts.

In Unix the command to check process information, ps -ef, displays the programs currently executing and there I see my program with the password, which I entered on the command line.

Is there a way by which I could suppress, by specifying a password file which sqlplus executable will look for to match a user account. A very similar example would be, the command ftp which looks for file '.netrc' to connect to a remote machine when invoked using 'here documents', in a shell program.

Any suggestion is very much appreciated. Thanks.

-Poorna Prakash
 Oracle DBA Received on Thu Mar 26 1998 - 00:00:00 CST