Re: How to hide sqlplus login/passwd

I happened to see this thread and it offered good suggestions on hiding username/password when running an sql command and then returning to unix.

How can I hide username/password when I just want to enter sqlplus and run commands from the sql> prompt?

Here is what I tried:

**

sqlplus $LOGNAME@$HOSTNAME < $PASS > mylog.out
**

where $PASS is a file only I can read.

This dumps me back on the command line and leaves this in my output file:

SQL*Plus: Release 3.3.4.0.1 - Production on Mon Dec 28 18:33:23 1998

Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.

Enter password:

Connected to:
Oracle7 Server Release 7.2.3.0.0 - Production Release With the distributed option
PL/SQL Release 2.2.3.0.0 - Production

SQL> Disconnected from Oracle7 Server Release 7.2.3.0.0 - Production Release With the distributed option
PL/SQL Release 2.2.3.0.0 - Production

For some reason it disconnects me :-(

I want to alias this kind of command so I don't have to enter my username/ password all the time but so people can't see my password with ps -af | grep sqlplus

Thanks
Damon Haley Received on Mon Dec 28 1998 - 19:36:54 CST