Depersonalize data
446099Apr 28 2008 — edited Apr 28 2008Hello,
I would like to de-personalize a datamodel. For example in an employees table I would like to scramble or mix up the Firstname/Lastname and salary column.
Is there any tool to do this? I've been looking at DBMS_CRYPTO, but that's more for protecting data.
In my situation, I don't need te be able to 'go back' to the original data. We have a copy of production, and need to secure it before giving it to Development dept.
Any hints? It would be nice not to do a lot of manual labour and writing sql (translate) statements.
Thx.