On 6/12/06, Jared Still <jkstill@xxxxxxxxx> wrote:
On 6/11/06, Sachin Sethi <s.sethi@xxxxxxxxxxxx> wrote:
In lieu of asking you to do some research, I will instead provide you with a sample solution:
Gee, how thoughtful of you.
create or replace trigger encrypted_insert before insert on encrypted for each row declare begin :new.first_name := utl_raw.bit_xor(utl_raw.cast_to_raw(: new.first_name ),utl_raw.cast_to_raw(encrypt_key.key)); :new.last_name := utl_raw.bit_xor(utl_raw.cast_to_raw(: new.last_name),utl_raw.cast_to_raw(encrypt_key.key)); :new.account_id := utl_raw.bit_xor(utl_raw.cast_to_raw(: new.account_id),utl_raw.cast_to_raw(encrypt_key.key)); end; /
I've watched this thread, and apparently no one has yet noticed that this is just XOR 'encryption'.
Anyone with a little cryptology background could break this in 5 minutes.
I'm surprised that you would offer such a suggestion.
Someone might take it seriously.