I have a column in the SQL Server 2005 DB which needs to be masked to ****. I tried masking it using mask function, however I found out that masking function works only in SQL Server 2016 + and above.
Is there any easiest way to alter an existing column in SQL Server 2005 DB to ***** ??
None
0 Points
3 Posts
SQL Server 2005 - Need to mask an existing table column
May 09, 2019 06:28 AM|kumarsj0224@gmail.com|LINK
Hi All,
I have a column in the SQL Server 2005 DB which needs to be masked to ****. I tried masking it using mask function, however I found out that masking function works only in SQL Server 2016 + and above.
Is there any easiest way to alter an existing column in SQL Server 2005 DB to ***** ??
Looking forward to hear from you. Thanks.
All-Star
48710 Points
18183 Posts
Re: SQL Server 2005 - Need to mask an existing table column
May 09, 2019 09:41 AM|PatriceSc|LINK
Hi,
You could use a view instead rather than exposing the real table. The purpose is to hide this from users having direct access to the database ? In this case a general purpose SQL Server at https://social.msdn.microsoft.com/Forums/sqlserver/en-us/home?category=sqlserver could be better.