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

Filed under:

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

Related posts about sqlloader

Oracle sqlldr: column not allowed here

as seen on Stack Overflow - Search for 'Stack Overflow'
Can anyone spot the error in this attempted data load? The '\\N' is because this is an import of an OUTFILE dump from mysql, which puts \N for NULL fields. The decode is to catch cases where the field might be an empty string, or might have \N. Using Oracle 10g on Linux. load data infile objects… >>> More
Prevent password leakage while using sql* loader

as seen on Stack Overflow - Search for 'Stack Overflow'
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… >>> More
using sql loader in ruby

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I just wonder if you know where to find a tutorial or samples of a Ruby script using sql *loader? >>> More
Populate an SQL Server 2k8 with Oracle Loader files

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi folks. Here's the problem: I have a project that needs to be migrated to Microsoft SQL Server 2008. We have data in text files for the Oracle SQL Loader and now we need to get that data into the SQL Server DB. I could write a program that converts everything into INSERT statements but there… >>> More
Using Oracle Sequence in SQL Loader?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am using SEQUENCE keyword in SQL Loader control file to generate primary keys. But for a special scenario I would like to use Oracle sequence in the control file. The Oracle documentation for SQL Loader doesn't mentioned anything about it. does SQL Loader support it? >>> More

Related posts about password-protection

How good is PDF password protection?

as seen on Super User - Search for 'Super User'
It appears that Word's password protection is not really good, at least until Office 2003, if I read this SU entry correctly. I'm under the impression that Acrobat's PDF password protection should be better (it says 128-bit AES for Acrobat 7 and higher). Is that true? Of course, it depends on the… >>> More
How to remove password protection from compressed files

as seen on Super User - Search for 'Super User'
This has always been a problem for me for a long time. Let's see if any SuperUser can solve this: I have a directory in which there are lots of password protected .RAR files of which I know the passwords. I want to remove the password protection from all of them without extracting the contents… >>> More
How good is Word's password protection?

as seen on Super User - Search for 'Super User'
Hi, I have a password protected MS-Word 2007 file that needs to stay private. How good is Word's protection? If it's not very good, can you suggest a better method for keeping the file protected? EDIT: my goal is to send the protected file to a recipient (who knows the password). I assume this recipient… >>> More
PHP password protection question?

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I use the sha512 function for PHP? Can I replace all my md5 funtions with the sha512 function? Do I have to download something if so what? Can any one provide examples? Thanks! >>> More
Password protection by .htaccess file not working after deployment on a new server

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I migrated my application to a new server (from a VPS to a dedicated) yesterday and the password protection which was working correctly on the previous server (using .htaccess file - asking username/pass) doesn't work anymore : anyone can access the website without being asked to enter a username… >>> More