Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

oracle data masking: is it possible, if we need, after masking a column, to obtain the original value ?

25 views
Skip to first unread message

fore...@gva.es

unread,
Nov 14, 2012, 7:02:27 AM11/14/12
to
We are beginning with Oracle Data masking and a user of us ask about the posibilitie ot retriev the original value after masking the data, if he need for any reason.

joel garry

unread,
Nov 14, 2012, 12:14:40 PM11/14/12
to
On Nov 14, 4:02 am, fores_...@gva.es wrote:
> We are beginning with Oracle Data masking and a user of us ask about the posibilitie ot retriev the original value after masking the data, if he need for any reason.

I wouldn't know, but I would guess that since the data is actually
replaced, the answer would have to be "no, you need to keep the
original data." That is the point of the product. Of course, since
it is an update, there may be a flashback. But the same could be said
about any backup, the answer to that is don't propagate backups or a
db that can be flashed back. If you need data, back it up.

http://www.oracle.com/technetwork/oem/pdf/511890.pdf

jg
--
@home.com is bogus.
Up to your ass in alligators...
http://www.postandcourier.com/article/20121105/PC05/121109613/1010/kearney-column-google-data-center-executive-updates-berkeley-county-site
0 new messages