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
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
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
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
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
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
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
,
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
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
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
]
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
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
12 matches
Mail list logo