database - Oracle 10g Datamasking -

database - Oracle 10g Datamasking -

i have oracle 10g database. want mask record of tables. doesn't need create sense, doesn't need readable. needs masked. example:

select * customer; last_name first_name address -------------- -------------- -------------------- doe john 10 someroad st

i convert :

last_name first_name address -------------- -------------- -------------------- ahd uiea 55 xxxx ue

i need open source software can work. should use?

you can utilize ora_hash or dbms_crypto bundle total fill requirements. giving solution using dbms_crypto:

--source data:

create table customer(last_name varchar2(50),first_name varchar2(50), address varchar2(200));

--encrypt function(script source):

create or replace function encrypt_value (p_in in varchar2, p_key in raw) homecoming raw l_enc_val raw (2000); l_mod number := dbms_crypto.encrypt_aes128 + dbms_crypto.chain_cbc + dbms_crypto.pad_pkcs5; begin l_enc_val := dbms_crypto.encrypt ( utl_i18n.string_to_raw (p_in, 'al32utf8'), l_mod, p_key ); homecoming l_enc_val; end;

--function implementation:

select encrypt_value(last_name,'aabbcc'),encrypt_value(first_name,'aabbcc'), encrypt_value(address,'aabbcc') customer;

database oracle10g