-
How to scramble data like names, ssn with meaningful data?
Hi,
I want to scramble or desensitize data using SQL scripts.
Change NAMES with meaningful names. ex: "Smith" will be like "Taylor".
Change SSN with meaningful ssn. ex: "425635124" will be like "411638155".
Please help me on this.
Thanks.
-
1) Change SSN with meaningful ssn. ex: "425635124" will be like "411638155".
Easy with DBMS_RANDOM.VALUE(low => 100000000,high => 999999999)
2) Change NAMES with meaningful names. ex: "Smith" will be like "Taylor".
More complex, you could collect all first names and last names in arrays and then use the DBMS_RANDOM to select a new combination.
HTH
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
I took a "C" class at a university and they used a file with over 64,000 words.
So all you really need is a large list of random words to use for first and last names,
and a mechanism to randomly select two words.
Of course Oracle will sell you a module to remove PII from databases.
I have no idea what the cost it though.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|