Re: data masking

Job

This is Oracle's OEM add-on right? Not trying to denigrate, just not sure what non -extra-cost options they have that do this

Niall

On Mon, Jul 28, 2008 at 7:36 PM, Job Miller <jobmiller_at_yahoo.com> wrote:

> Oracle's Data Masking can fulfill both #1 and #2.
>
>
>
> Currently #2 is only for user-defined masks. I believe Oracle is working
> on some deterministic maskings for the various templates they otherwise
> pre-deliver.
>
>
>
> Job
>
> --- On *Mon, 7/28/08, David Boyd <davidb158_at_hotmail.com>* wrote:
>
> From: David Boyd <davidb158_at_hotmail.com>
> Subject: data masking
> To: "oracle-l" <oracle-l_at_freelists.org>
> Date: Monday, July 28, 2008, 10:34 AM
>
>
> We need ship an entire schema to another site. Some data is sensitive,
> which we'd like to mask with substitution. Our requirements are:
>
> 1. Table-Table Data Synchronization
>
> A column is a join key to a column in one (or more) other tables. This
> means data
>
> masked in one table must have synchronized data changes in a number of
> others.
>
> For example, changes to the EMPLOYEE_NUMBER column in one table must
> trigger identical changes in other tables.
>
> 2. Consistent Masking
>
> We have to ensure that the output is consistent across multiple runs. In
> practice this means that if the name of employee Joe Smith gets changed to
> Bill Jones then the next time the database is cloned and sanitized Joe Smith
> should again appear as Bill Jones.
>
>
>
> I wonder if there some existing scripts that I can download to do this. If
> not, could someone recommend a good tool?
>
>
>
> Dave
>
> ------------------------------
> Keep your kids safer online with Windows Live Family Safety. Help protect
> your kids.<http://www.windowslive.com/family_safety/overview.html?ocid=TXT_TAGLM_WL_family_safety_072008>
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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