How to mask a field?

• shivashankara9

  SSC Eights!

  Points: 859

  More actions

  August 19, 2012 at 6:10 pm

  #392983

  Hi,

  I have a table with 10 columns

  Out of 10, i need to mask 5 columns because i don't want to show those columns in development and testing environment.

  If any of you have solution for this please let me know!!

  I am working on SQL Server 2008.

• Animal Magic

  SSChampion

  Points: 13964

  More actions

  August 20, 2012 at 3:35 am

  #1527475

  Create a view with only the 5 fields you want to be exposed. Give permissions to this view and not the base table