Solaris 7
Oracle 8.1.7.1.0b

sqlldr.

Every day I load a very large number of text files using sqlldr. My probelmat the moment is security.

When I connect to oracle for batch jobs outside sqlldr, I use the following.

In my unix script.sh

USER="user"
PASS="pass"
COM2="connect $USER/$PASS"
COM3="sqlplus /nologon"

$COM3 < $COM2

select * from dual;
ESQL

Then in UNIX if I do a

/usr/ptree/bin/proc

I can find the process and I CAN'T see the password. This is good.

Sqlldr on the other hand

USER="user"
PASS="pass"

COM="sqlldr $USER/$PASS"


$COM $CONTROL/data.ctl DATA=data.txt DIRECT=TRUE

I can't use the /nologon. And when I do a /usr/ptree/bin/proc I can see the user/pass, which to me is very disturbing. Any ideas what I can do?

Cheers,