Re: Security question: sqlplus and the ps cmd on Unix

Use sqlplus /nolog option and make the connection in the script. (assume this is a automated process).

If manually, just type sqlplus username, password will be prompted. (This is something u have to teach ur user).

Or even, set up a shell script for sqlplus instead of ps. something like :

#!/bin/csh
set SQLBIN=<your sqlplus directory>
set SQLEXE=<sqlplus's new name, make sure rename it to something else> if ( $#argv > 1 ) then

$SQLBIN/$SQLEXE $argv[1]

else

$SQLBIN/SQLEXE

endif

I usually write shell scripts using csh, someone can definetly come out with something better.

Howard          Received on Sun Apr 16 1995 - 00:00:00 CEST