RE: using obfuscation

2002-10-02 Thread Aponte, Tony
Title: RE: using obfuscation I was wondering if this was of any help. Tony Aponte -Original Message- From: Aponte, Tony Sent: Tuesday, September 17, 2002 7:04 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: using obfuscation I've been developing

RE: using obfuscation

2002-09-17 Thread Aponte, Tony
Title: RE: using obfuscation I've been developing a solution for a similar requirement. Although I reached a dead-end with this thread I think it solves your problem. I'm picking it up from the point where the data in encrypted_data of sensitive_table needs encryption. I did

Re: using obfuscation

2002-09-11 Thread Don Jerman
Create View statement? Randy -Original Message- Sent: Tuesday, September 10, 2002 10:13 AM To: Multiple recipients of list ORACLE-L Subject:Re: using obfuscation File: Card for Don Jerman What about... create view my_data as select de_encrypt(sensitive_data

RE: using obfuscation

2002-09-10 Thread Steiner, Randy
is still in the index. -Original Message- Sent: Monday, September 09, 2002 6:04 PM To: Multiple recipients of list ORACLE-L Subject:Re: using obfuscation Randy, Do you have an index on SENSITIVE_DATA? Also, you didn't include the long running query. Does it look

Re: using obfuscation

2002-09-10 Thread Don Jerman
What about... create view my_data as select de_encrypt(sensitive_data) as clear_sensitive_data where sensitive_data = encrypt('CLEAR TEXT') ? This lets you create an index on the sensitive data without decrypting it, and the function need only be called once on the clear text. Caveat: no idea

RE: using obfuscation

2002-09-10 Thread Steiner, Randy
Don, It seems like a real good idea, but what am I putting inside my call to the encrypt function in my Create View statement? Randy -Original Message- Sent: Tuesday, September 10, 2002 10:13 AM To: Multiple recipients of list ORACLE-L Subject:Re: using obfuscation

RE: using obfuscation

2002-09-10 Thread Jamadagni, Rajendra
Title: RE: using obfuscation Can you create a Function based index on that column? That could be of use ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal

RE: using obfuscation

2002-09-10 Thread Kirsh, Gary
, It seems like a real good idea, but what am I putting inside my call to the encrypt function in my Create View statement? Randy -Original Message- Sent: Tuesday, September 10, 2002 10:13 AM To: Multiple recipients of list ORACLE-L Subject:Re: using obfuscation File: Card

RE: using obfuscation

2002-09-10 Thread Steiner, Randy
Title: RE: using obfuscation Wouldnt that store the sensitive data in the index? -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 12:13 PM To: Multiple recipients of list ORACLE-L Subject: RE: using obfuscation Can you

RE: using obfuscation

2002-09-10 Thread Jamadagni, Rajendra
Title: RE: using obfuscation I wouldn't worry about that ... unless you dump the index blocks, you won't see that data anyway. OTOH, why don't you set your view to select based on a PK and then apply the function on selected rows?? Raj

RE: using obfuscation

2002-09-10 Thread Jared . Still
] 09/10/2002 01:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: using obfuscation I wouldn't worry about that ... unless you dump the index blocks, you won't see that data anyway. OTOH, why don't

Re: using obfuscation

2002-09-09 Thread Jared . Still
Randy, Do you have an index on SENSITIVE_DATA? Also, you didn't include the long running query. Does it look something like select * from original_table where decrypt(sensitive_data) = 'CLEAR TEXT' ? That requires a full table scan, unless you build a functional index with the