Re: removing/masking sensitive data

From: Tim Onions <att755_at_hotmail.com>
Date: Tue, 19 Dec 2006 08:46:27 +0000
Message-ID: <BAY19-F4F118E243987128BF3D3399C80@phx.gbl>

Well the datamasker demo pages show a simple exmple where a WHERE clause is used on the "gender" column to determine how the rule works on the "name" column. Not quite what your issue was but does show that the tools out there do have conditional logic in them so might still be worth a look.

Regards

Tim Onions

>I recently had the opportunity (successfully at that) to create such a
>manual script. I don't think that a 3rd party tool could have worked.
>Reason is that in _some_ of the tables, the ssn was in a column called
'>data' iff a column called 'name' was 'xyz' and there was numeric data
>in cols 1 - 9 (or similar lack of logic).

---

It's Hotmail's 10th Birthday! Come and play Pass the Parcel http://www.msnpasstheparcel.com

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

Received on Tue Dec 19 2006 - 02:46:27 CST