Re: data masking
- From: Job Miller <jobmiller@xxxxxxxxx>
- To: niall.litchfield@xxxxxxxxx
- Date: Tue, 29 Jul 2008 06:13:22 -0700 (PDT)
Yes, this is an extra-cost option that is available in Grid Control 10.2.0.4
that is priced based on the # of CPUs on the server where the data is being
masked.
The Data Masking Pack is certified for all database releases supported by EMGC
10.2.0.4.
some official docs are here:
http://download.oracle.com/docs/cd/B16240_01/doc/em.102/b31949/database_management.htm#sthref1211
--- On Mon, 7/28/08, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote:
From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
Subject: Re: data masking
To: jobmiller@xxxxxxxxx
Cc: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
Date: Monday, July 28, 2008, 4:53 PM
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.
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
