Home » RDBMS Server » Security » how to encrypt and decrypt password field in a table for 8i release 8.1.5
how to encrypt and decrypt password field in a table for 8i release 8.1.5 [message #18369] Tue, 29 January 2002 12:15 Go to next message
mala
Messages: 18
Registered: March 2001
Junior Member
Hi,
Can anyone please let me know how to encrypt/decrypt a password field in a user created table. We have oracle 8i release 8.1.5. I need to encrypt all the psswords first. On an on-going basis,we have a web front end(java) maintenace screen(websphere ) for userid/password maintenance which also needs the password encryption/decryption.
Help greatly appreciated.
Thanks in advance.
Re: how to encrypt and decrypt password field in a table for 8i release 8.1.5 [message #18378 is a reply to message #18369] Tue, 29 January 2002 15:41 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
use DBMS_OBFUSCATION_TOOLKIT package.

see Oracle supplied pl/sql packages docs for more info
Re: how to encrypt and decrypt password field in a table for 8i release 8.1.5 [message #18392 is a reply to message #18369] Wed, 30 January 2002 04:14 Go to previous messageGo to next message
mala
Messages: 18
Registered: March 2001
Junior Member
DBMS_OBFUSCATION_TOOLKIT works only from Oracle realease 8.1.6 onwards. Since we have a lower version (8.1.5), we cannot use this package.
Is there any other way for these earlier verions of oracle. Thanks
Re: how to encrypt and decrypt password field in a table for 8i release 8.1.5 [message #18655 is a reply to message #18369] Sat, 09 February 2002 02:49 Go to previous message
Abdullah Gilani
Messages: 18
Registered: October 2001
Junior Member
hi all Oracle8i Rel-2 and onwards users ,

for password encryption and decryption Oracle 8i Provide built-in Package "DBMS_OBFUSCATION_TOOLKIT"
you may use DBMS_OBFUSCATION_TOOLKIT package.
DBMS_OBFUSCATION_TOOLKIT works only from Oracle realease 8.1.6 onwards

OR
you may use following Procedure....input 8 or multiple of 8 (6,16,24......)...
following procedure encrypted into hex value...like 'agilani ' where agilani plus one space is the password...try and enjoy

DECLARE
input_string VARCHAR2(16) := 'agilani ';
key_string VARCHAR2(8) := 'scottsc ';
encrypted_string VARCHAR2(2048);
decrypted_string VARCHAR2(2048);
begin
dbms_obfuscation_toolkit.DESEncrypt(
input_string => input_string,
key_string => key_string,
encrypted_string => encrypted_string );
dbms_output.put_line('> encrypted hex value : ' ||
rawtohex(UTL_RAW.CAST_TO_RAW(encrypted_string)));
dbms_obfuscation_toolkit.DESDecrypt(
input_string => encrypted_string,
key_string => key_string,
decrypted_string => decrypted_string );
dbms_output.put_line('> decrypted string output : ' ||
decrypted_string);
end;

Thanks & Regards

Abdullah Gilani
Email: syedgilani@hotmail.com
Previous Topic: passwordfile security
Next Topic: Oracle 8 - users & roles
Goto Forum:
  


Current Time: Fri Mar 29 04:15:22 CDT 2024