A m Z o n e

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; 

Press the Back button of you Browser to go to previous page
Home