Hiding crucial data in tables
Data stored in tables can be viewed by via SQL*Plus or by any other means of connecting to
database directly. No problem with that, but sometimes, critical information needs to be
prevented from being seen by others. The only preventive action is storing data in encrypted
format. Such data can then be decrypted in the appropriate front-end screen for the rightful
authority to view it. Does Oracle provide any encryption process for storing data?
E.g.: Credit card number kept in Varchar2/number field.
DBMS_OBFUSCATION_TOOLKIT
This package is available for data encryption and integrity checks.
E.g.:
declare
l_str varchar2(64) := 'amar kumar padhi';
l_deskey varchar2(64) := 'The encryption key *&^%.';
l_desstr varchar2(100);
begin
dbms_output.put_line('The string provided is:' || l_str);
dbms_obfuscation_toolkit.desencrypt
(input_string => l_str, key_string => l_deskey, encrypted_string => l_desstr);
dbms_output.put_line('The encrypted data is:' || l_desstr);
l_str := null;
dbms_obfuscation_toolkit.desdecrypt
(input_string => l_desstr, key_string => l_deskey, decrypted_string => l_str);
dbms_output.put_line('The decrypted data is:' || l_str);
end;
The package is capable of encrypting in DES and DES3 encryption formats. MD5 checksum for data
integrity check is also available under this package.
Best viewed in medium text size. Please refresh this page (F5) to view the latest information. This page was created on 16-dec-2001 and last updated on 16-dec-2001.
please forward all queries to amar_padhi@fastmail.fm