Prevent password leakage while using sql* loader
Posted
by Jai
on Stack Overflow
See other posts from Stack Overflow
or by Jai
Published on 2010-04-07T04:25:49Z
Indexed on
2010/04/07
4:33 UTC
Read the original article
Hit count: 402
sqlloader
|password-protection
I have shell script calling Sql*loader utility which inturn uses username/password as arguments. This details cannot be stored on server in any form due to security related policies. i got 2 approaches to handle this situation, 1. create hidden parameter file with login details and limit the access to owner. again the implication is i cannot store login data in any format on server 2. Create the user as OS authenticated and straight away login into sql without any userid/password I am not able to figure out risks involved in 2nd approach which u experienced folks could have come across. let me know if there is any other approach to handle password leakage issue
© Stack Overflow or respective owner