| how to encrypt and decrypt password field in a table for 8i release 8.1.5 [message #18369] |
Tue, 29 January 2002 12:15  |
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 #18655 is a reply to message #18369] |
Sat, 09 February 2002 02:49  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
