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,
OCP 8i, 9i DBA
Brisbane Australia