Re: sqlldr password suppression
From: Ed Kulis <ekulis_at_apple.com>
Date: Mon, 11 Feb 2002 10:19:25 -0800
Message-ID: <B88D4B2D.FCD%ekulis_at_apple.com>
>>
>> Hi All,
>>
>> I'd like to run sqlldr from cronjobs in Unix so I don't want sqlldr to ask
>> for a password.
Date: Mon, 11 Feb 2002 10:19:25 -0800
Message-ID: <B88D4B2D.FCD%ekulis_at_apple.com>
2/7 10:55a
> 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.
Thanks all for the suggestions.
Here are three ways,
Conner Macdonald:
#!/bin/ksh
print THE_PASSWORD | sqlldr userid=THE_USERID ...
Daniel Morgan:
Use an OPS$ account to do the work and use object privileges to give access
to
the schema being loaded.
Oracle support:
Use a 400 parfile containing:
userid=scott/tiger
(See e.g.) http://info-it.umsystem.edu/oradocs/doc/server/doc/SUT73/ch6.htm Received on Mon Feb 11 2002 - 19:19:25 CET