Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Passwords in UNIX process list
This would appear to be ticket for my scripts.
Many thanks.
-Craig
Oh yeah -- and I'll pass along the hide.c suggestion to the application vendors.
Peter Sylvester wrote:
> try
>
> sqlplus /nolog <<EOF
> connect user/password
> ...
> EOF
>
> -Peter
>
> Craig Silver wrote:
> >
> > I'm trying to keep database passwords out of the 'ps' listing on a UNIX
> > system.
> >
> > I've use simple redirect scripts in the past, with Sybase and Informix.
> > These would just feed the password to the database login process rather
> > than including it on the command line ( login/password ).
> >
> > sqlplus dblogin <<!
> > dbpassword
> > select ......;
> > quit
> > !
> >
> > I get errors from Oracle (8.1.6) when trying this froma ksh script -
> > SP2-0306 Invalid option. and a usage message .
> >
> > I can drag something like 'expect' into the mix, but I would like to use
> > a simpler solution, if it exists. The system I'm working on does not
> > use the operating system credentials for the database access.
> >
> > I'm more of a UNIX admin than a DBA, so please pardon my ignorance if
> > this is a stupid question. I have looked through some Oracle 7 course
> > material from about 4 years ago, and a couple of O'reilly books I've
> > got, but haven't come across a solution yet.
> >
> > Thanks for any help or direction you can provide.
> >
> > -Craig