Re: data masking
- From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- To: jobmiller@xxxxxxxxx
- Date: Mon, 28 Jul 2008 21:53:53 +0100
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@xxxxxxxxx> 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@xxxxxxxxxxx>* wrote:
>
> From: David Boyd <davidb158@xxxxxxxxxxx>
> Subject: data masking
> To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
> 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
Other related posts:
