Re: sqlplus and unix - hidden user and password

You can also put the password as the only line in a file. Save that file as "passwd" or other name. Do a "chmod 400 passwd" so that noone else can see your password file. Then you can call scripts through cron (or other) by doing:

   sqlplus userid @scriptfile < passwd

The advantage of this method is that should your user's password change, you only have to change it in one location, not many different scripts.

HTH,
Brian

Sigrid Staudte wrote:
>
> Hi...
>
> I'm starting sqlplus from a unix shell in a shell script with the command
>
> sqlplus user/password<<EOF
> ...
> sql-statements
> ...
> exit;
> EOF
>
> The database is running on the unix server. When I start the command
>
> ps -ef |grep user
>
> then the complete command sqlplus user/password is displayed. So can
> anybody find out the username and password.
> Is there a possibility to hidden user and password? Is there another
> way to start sqlplus in a shell script, so that nobody can seen the
> user and password with the ps command.
>
> Regards...
>
> Sigrid
Received on Tue Jan 11 2000 - 07:48:20 CST