Re: Need data masking function ideas...

From: Michael Moore <michaeljmoore_at_gmail.com>
Date: Fri, 6 May 2011 12:30:07 -0700
Message-ID: <BANLkTi=XLZpuyNPyXf33wpGn1=nwTYPSjg_at_mail.gmail.com>

NM, you said you wanted the length to remain the same.

On Fri, May 6, 2011 at 12:29 PM, Michael Moore <michaeljmoore_at_gmail.com>wrote:

> could you use ORA_HASH?
>
>
> On Fri, May 6, 2011 at 11:45 AM, Robert Freeman <robertgfreeman_at_yahoo.com>wrote:
>
>> Ok.... So I'm doing some data masking. The problem is that I have many
>> many tables that have related columns with no FK's... I'm going to use the
>> data masking pack to do the masking, but it does not offer the complete
>> functionality I need since the FK's are not in place. So I need a function
>> to call from the job to do most of the actual masking.
>>
>> I want to make sure that when I mask a given column that the following is
>> true:
>>
>> 1. The data length remains the same.
>> 2. That the mask value for a given value remains the same.
>>
>> For example, if on table A I have a column called test_col with rows with
>> values 1,2,3 and these mask to 3,1,6 , values 32,555,6433 will mask to
>> something like 22, 345 and 5500...
>>
>> that on table B the same result will occur.
>>
>> Now I know I can come up with a deterministic masking function/strategy to
>> do this, but I'm wondering if anyone else has any ideas.
>>
>> Thanks in advance...
>>
>> Robert G. Freeman
>> Master Principal Consultant, Oracle Corporation, Oracle ACE
>> Author of various books on RMAN, New Features and this shorter signature
>> line.
>> Blog: http://robertgfreeman.blogspot.com
>>
>> Note: THIS EMAIL IS NOT AN OFFICIAL ORACLE SUPPORT COMMUNICATION. It is
>> just the opinion of one Oracle employee. I can be wrong, have been wrong in
>> the past and will be wrong in the future. If your problem is a critical
>> production problem, you should always contact Oracle support for assistance.
>> Statements in this email in no way represent Oracle Corporation or any
>> subsidiaries and reflect only the opinion of the author of this email.
>>
>>
>> ------------------------------
>> *From:* Lei Zeng <lzeng_at_yahoo-inc.com>
>> *To:* "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
>> *Sent:* Thu, May 5, 2011 9:33:23 PM
>> *Subject:* how to find the name for SQL_OPCODE
>>
>> Hi, list:
>>
>>
>>
>> I am on 10g, not 11g. How to find out the complete list of names for
>> SQL_OPCODE? I want to do something like
>>
>>
>>
>> decode(OPCODE
>>
>> 0,'BACKGROUND',
>>
>> 1,'Create Table',
>>
>> 2,'INSERT', ….)
>>
>>
>>
>> Thanks,
>>
>> Lei
>>
>>
>>
>
>

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

Received on Fri May 06 2011 - 14:30:07 CDT