Re: sqlldr password suppression

Ed Kulis wrote:
>
> Hi All,
>
> 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

#!/bin/ksh
print THE_PASSWORD | sqlldr userid=THE_USERID ...

hth
conor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."