08-26-2014
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, I want to encrypt the password file and my shell script should decrypt it.
However, whoever has access to the script should not be able to decrypt it.
Is it possible? If so, how?
TIA,
Regards,
Praveen
Last edited by rbatte1; 08-27-2014 at 11:49 AM..
Reason: Set as LIST tags
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
how do i encrypt and decrypt a password (2 Replies)
Discussion started by: sanwish
2 Replies
2. Solaris
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
3. Shell Programming and Scripting
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
4. Shell Programming and Scripting
How to encrypt and decrypt a file using unix Command?
Can any one help me? (2 Replies)
Discussion started by: laknar
2 Replies
5. Shell Programming and Scripting
Hi,
I have written a shell script in unix for my customer. Now I want to make it only execute and not to read/write. Can anybody help me how to set password protect/encript my script.
Thanks
Suresh (3 Replies)
Discussion started by: suresh3566
3 Replies
6. Shell Programming and Scripting
Hi,
I have run the below script which is connected to db2 v9.5. There is no issue. The only problem is how to encrypt the dbpwd?
#!/bin/ksh
#---- Set Environment
dbalias="dev1db"
dbuser="user1"
dbpwd="password"
#---- Connect to the Database
cd /opt/ibm/db2/V9.5/bin
db2 "connect to... (1 Reply)
Discussion started by: lookinginfo
1 Replies
7. Shell Programming and Scripting
Hi
Please see if you have come across any aprts of this. I can read, integrate and syntehsixe. Any help you could offer me would be super. thanks in advance!
Good day.
Thank you for your response in this matter. Here are some further details:
1) scripting is to be in BASH... (1 Reply)
Discussion started by: cdc01
1 Replies
8. Shell Programming and Scripting
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
9. Shell Programming and Scripting
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
10. UNIX for Beginners Questions & Answers
Hello,
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,
Sri (3 Replies)
Discussion started by: eskay
3 Replies
LEARN ABOUT DEBIAN
apache::session::store::oracle
Apache::Session::Store::Oracle(3pm) User Contributed Perl Documentation Apache::Session::Store::Oracle(3pm)
NAME
Apache::Session::Store::Oracle - Store persistent data in a Oracle database
SYNOPSIS
use Apache::Session::Store::Oracle;
my $store = new Apache::Session::Store::Oracle;
$store->insert($ref);
$store->update($ref);
$store->materialize($ref);
$store->remove($ref);
DESCRIPTION
Apache::Session::Store::Oracle fulfills the storage interface of Apache::Session. Session data is stored in a Oracle database.
SCHEMA
To use this module, you will need at least these columns in a table called 'sessions':
id varchar2(32) # or however long your session IDs are.
a_session long
To create this schema, you can execute this command using the sqlplus program:
CREATE TABLE sessions (
id varchar2(32) not null primary key,
a_session long
);
If you use some other command, ensure that there is a unique index on the table's id column.
CONFIGURATION
The module must know what datasource, username, and password to use when connecting to the database. These values can be set using the
options hash (see Apache::Session documentation). The options are DataSource, UserName, and Password.
Example:
tie %hash, 'Apache::Session::Oracle', $id, {
DataSource => 'dbi:Oracle:database',
UserName => 'database_user',
Password => 'K00l'
};
Instead, you may pass in an already-opened DBI handle to your database.
tie %hash, 'Apache::Session::Oracle', $id, {
Handle => $dbh
};
The last option is LongReadLen, which specifies the maximum size of the session object. If not supplied, the default maximum size is 8 KB.
AUTHOR
This modules was written by Jeffrey William Baker <jwbaker@acm.org>
A fix for the commit policy was contributed by Michael Schout <mschout@gkg.net>
SEE ALSO
Apache::Session, Apache::Session::Store::DBI
perl v5.10.1 2010-10-18 Apache::Session::Store::Oracle(3pm)