October 11, 2011 at 11:49 pm
Hi Everyone,
Could you please let me know, is it possible to masking the confidential data in sqlserver tables.
If possible, Let me know how to do it? otherwise if anyone have masking script in sqlserver 2008.
Could you please shared with me..
Thanks in advance
Balaji
October 13, 2011 at 7:45 am
Not sure what you mean by "masking", but at one place I worked we had an "anonymity" app (VB/CLR, if I remember correctly) into which we passed a table name and a list of fields to be modified (for example, names, addresses, phone numbers) along with the type of values (Name, Address, Phone, etc.). We had a table of allowed substitutions (type:value pairs like Name:John Jones, Name:Mary Smith, Phone:555-555-5555, Address:123 Main Street, etc.) that the app would use to update the target table. It would randomly pick a value from the substitution table for the specified type and do an UPDATE of the record in the database. Worked like a charm whenever we were working with sensitive client data.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply