Re: sqlplus and unix - hidden user and password

Yours appeared at first sight to be the most promising of the answers however

with a file dba/abcd.efg contining the password i cannot get the following to work

 sqlplus system @test.sh < dba/abcd.efg

SQL*Plus: Release 8.0.5.0.0 - Production on Wed Jan 12 16:4:25 2000

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied

any ideas

Regards

--
Kevin A Lewis (BOCM PAULS LTD) - Animal Feed Manufacturer - Ipswich United Kingdom)

                        <Kevin_A_Lewis_at_Hotmail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote in message news:387B34A4.2B09FCF7_at_edcmail.cr.usgs.gov...
> 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 Wed Jan 12 2000 - 10:09:08 CST