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: 400

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

Related posts about sqlloader

Related posts about password-protection