Re: Encrypt and Decrypt the data

On 6/12/06, Jared Still <jkstill_at_gmail.com> wrote:
>
> On 6/11/06, Sachin Sethi <s.sethi_at_telserra.com> 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.

;)

--
http://www.freelists.org/webpage/oracle-l