Post reply

HOWTO get the data masked in my Prod_DB ?

  • April 29, 2004 at 3:44 am

    #163556

    For the security reasons, i want to mask the data in some columns in some tables of my prodcution DB, before i deliver

    it to the outside developers.

    any idea or suggestion pls ?

  • April 29, 2004 at 2:35 pm

    #504745

    Have you thought of using views to exclude the columns you don't want them to see?

    Greg

    Greg

  • April 30, 2004 at 2:00 am

    #504775

    We must deliver them a copy of our DBProd one a month.

    so we need to modify, for example, our customerNameColumn, customerAddrCol, and accountNumberCol etc...for the security reason

  • April 30, 2004 at 7:08 am

    #504814

    Well, you'll likely need to write a few T-SQL queries to change the entries. You could find a names database (like a book of baby names or the like) and modify the name that way. For account number you could take all your account numbers, and create a new account number for each one using some pseudo-random function then update accordingly.  For addresses, you can substitute city, state, and zip with something else, but the street may prove difficult because that means breaking apart the address line into the relevant parts.

     

    K. Brian Kelley
    @kbriankelley

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply