Re: How to hide sqlplus login/passwd

As long as you are interactivly using SQL*Plus, just:

    sqlplus
    system/manager
    sequence of SQL statements

Damon K. Haley wrote:

> 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 - 22:09:06 CST