Re: Encrypt and Decrypt the data

yes, but jared, it was offered as a sample solution ... there is enough info here for a moderately skilled tech goon to think the procedure through and come up with one's own specific solution.

after all, the poor fellow has to do something for his self-esteem, no?

r,

Gus

Jared Still wrote:

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