Encrypt and Decrypt a File with Password

Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Encrypt and Decrypt a File with Password
# 1  
Old 02-27-2017
Encrypt and Decrypt a File with Password


I have few files on unix which are payroll related and I need them to encrypt with password so others wouldn't see the data. I use ETL tool and would like to know the unix command that does encryption/decryption to use in the ETL.

Thank you,
# 2  
Old 02-27-2017
You'll have to be more specific than "ETL". You may not be able to do it inside ETL itself in any case, just externally.
# 3  
Old 02-28-2017
Beware that any process to encrypt/decrypt is open to abuse if someone can read the script and work out where the password/key is stored and can read that. There are various ways to encrypt data, but the tough part is having a decryption process that is not decipherable.

For example, you could make a file difficult to read by compressing it and using a non-obvious file name, however anyone reading your decryption process would spot it is a simple decompression and be able to read your data.

If ETL stands for Extract, Transform, Load as three database functions, you need to say what tools you are using in each of the stages and where the data will be stored at each point. Are you transferring data from one server to another perhaps?

# 4  
Old 02-28-2017
Originally Posted by eskay
I have few files on unix [...] and I need them to encrypt with password so others wouldn't see the data.
Unix offers a lot of utilities doing exactly that: uuencode, openssl and several others.

The problem you will be facing is not so much the encyption/decryption itself but to make sure nobody can intercept it. Suppose you use a password to encrypt your file you might have a script with the line

encrypt_utility "password" /path/to/file > path/to/file.encrypted

and then move/send/... the encrypted version of the file. But if someone can read your scvript he could take the password from there and use it himself to decrypt the file.

This means you have to plan carefully so that nobody without the proper rights have even read-access to such a script. As in most security-related problems the solution is very simple once you got the planning of who is allowed to do what under which circumstance correct.

For the tools to use i suggest you read the man-pages/descriptions of the two utilities i mentioned above. They are standard-UNIX tools and freely available open-source respectively. If what they can do suffices for your purpose we can help you put one or the other to work. If not, i suggest doing a Google-search for other such tools. There are reams and reams of software out there, for all kind of purposes. Once you have decided for one or the other we can (hopefully) help you put that o work too.

I hope this helps.

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Encrypt and decrypt the password in a Shell Script

Hello, I have the following UNIX shell script which connects to the teradata database and executes the SQL Queries. For this, I am passing database name, username and password. I don't want to reveal my password to anyone. So, is there any way that I can encrypt my password and read the... (2 Replies)
Discussion started by: ronitreddy
2 Replies

2. Programming

Encrypt and Decrypt file using RIJNDAEL-128

Hi All, Can I use MCRYPT - (RIJNDAEL-128) / CBC mode to encrypt and decrypt a file? I am trying to find some sample C program on internet, which will encrypt and decrypt a file. But was not able to find any thing. Can some help me with the programming. Thanks. (1 Reply)
Discussion started by: Shre
1 Replies

3. Shell Programming and Scripting

Encrypt and decrypt a password in shell script

Hi All, very good morning all. I am trying to connect to informatica repository by using shell script. I have written pmrep connect command in the script file. But i need to provide repository, domain ,username and password to connect. Username and password are hard coded in the script... (8 Replies)
Discussion started by: SekhaReddy
8 Replies

4. Shell Programming and Scripting

Encrypt Password file and decrypt in a shell script

Hi All, I have stored Oracle database passwords in a hidden file - .pass_file. My shell script reads the hidden file, gets the password and then logs in to the Oracle database and runs some SQL script. My requirement is: I need to provide the shell script to be executed by someone else. So,... (1 Reply)
Discussion started by: sunpraveen
1 Replies

5. Shell Programming and Scripting

Encrypt and Decrypt

I have script for all oracle prod db. I have hard coded the username / password. I need a mechanism to encode and decode the username / password in a shell script. Another challenge is I use the username and password in a Select command for oracle DB. How can call the decrypted... (2 Replies)
Discussion started by: ilugopal
2 Replies

6. Shell Programming and Scripting

Encrypt and decrypt a string

Hi, I want to encrypt and decrypt a string(database password) which will be used in my scripts. encrypt the string while storing in a file and while using it in other scripts it should decrypt. i tried below method. As it can decrypt easily, it is not recommended. encrypt=`perl -e 'print unpack... (5 Replies)
Discussion started by: rohan10k
5 Replies

7. Shell Programming and Scripting

How to encrypt and decrypt a file

How to encrypt and decrypt a file using unix Command? Can any one help me? (2 Replies)
Discussion started by: laknar
2 Replies

8. Shell Programming and Scripting

Encrypt and Decrypt script

Dear Experts, I am using one script name :volume.sh and its written in bash shell script. I just want to encrypt the script so that any one else cannot see it. please tell me the commands how to encrypt the script as well as to decrypt it. Regards, SHARY (9 Replies)
Discussion started by: shary
9 Replies

9. Solaris

Decrypt Des file - then encrypt

Help.. I need to decrypt a file that was encrypted using DES 56 Bit. I have the encryption key and the block size used but no idea what utility to use.. I then need to encrypt the file using pgp and another key I have.. againt I dont know what utility to use. I am running solaris 9 .... ... (0 Replies)
Discussion started by: frustrated1
0 Replies

10. Shell Programming and Scripting

encrypt and decrypt password

how do i encrypt and decrypt a password (2 Replies)
Discussion started by: sanwish
2 Replies
Login or Register to Ask a Question

Featured Tech Videos