sqlldr password suppression
Date: Thu, 07 Feb 2002 10:55:59 -0800
Message-ID: <B8880DBF.F54%ekulis_at_apple.com>
[Quoted] Hi All,
[Quoted] [Quoted] I'd like to run sqlldr from cronjobs in Unix so I don't want sqlldr to ask for a password.
I don't want to put the password in the script and I don't want to expand the password in the command line because with either method the password will show up in the command line runstring.
Using
sqlldr scott/tiger # password direct method
sqlldr $(password.ksh) # expansion method
where
password.ksh contains
print scott/tiger
causes a ps -ef line like this
larrye 291164 200958 0 09:48:14 pts/0 0:00 sqlldr scott/tiger
sqlplus has got this method which keeps the password out of the runstring.
sqlplus /nolog <<EOB
connect $(password.ksh);
select sysdate, name, user_name
from dual, v\$database, user_users;
EOB
Any ideas? Thanks!
-ed Received on Thu Feb 07 2002 - 19:55:59 CET