How to scramble data like names, ssn with meaningful data?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to scramble data like names, ssn with meaningful data?

  1. #1
    Join Date
    Jan 2015
    Posts
    1

    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.

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,487

    Cool

    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

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,080
    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.
    this space intentionally left blank

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
  •  


Click Here to Expand Forum to Full Width