using DBMS_OBFUSCATION_TOOLKIT over a PGP-encrypted file [message #289122] |
Wed, 19 December 2007 15:34 |
ora_balan
Messages: 21 Registered: January 2007 Location: Mumbai, India
|
Junior Member |
|
|
Hi
Am working on an Oracle9i Database Enterprise Edition Release 9.2.0.6.0 running on a Windows 2003 server.
I'm in the middle of an integration which involved web Methods v6.5 running on Sun OS v5.8
The requirement is to transport confidential data onto the database host and load it into a database table.
I was about to use an external table arrangement to load the data before running into a roadblock.
The data requires encryption while transporting or exchanging.
from my web Methods environment, I do have the ability to generate a PGP-encrypted file from the source file.
Can I use DBMS_OBFUSCATION_TOOLKIT to decrypt an entire PGP-encrypted file?
Anybody encountered this kind of situation before?
Any info / help will be helpful.
Regards,
Piyush Balan
|
|
|
|
Re: using DBMS_OBFUSCATION_TOOLKIT over a PGP-encrypted file [message #289124 is a reply to message #289123] |
Wed, 19 December 2007 16:22 |
ora_balan
Messages: 21 Registered: January 2007 Location: Mumbai, India
|
Junior Member |
|
|
Am using SSH to obtain the file from it's original source and transporting it onto the Database host.
The file on the SSH sever is in plain text and once obtained needs to be put on the Database host for me to do an INSERT..INTO..SELECT ON EXTERNAL TABLE.
Are you suggesting putting an SSH server on the database host?
|
|
|
|