For security reasons (and policies) I need to mask the data in my SharePoint 2013 on-premises production environment, so: 1) In case of an unauthorized user obtains a site backup and restored it in another environment it will just read scrambled data. 2) It has to provide Column Level Security, so we can select different kind of users to read the real list content and the others will read a mask like "***" or will read the field just empty.
An ideal tool will be the one that masks the data at real-time, by changing the data stream on the fly so that the data requester does not get access to the sensitive data, while no physical changes to the original production data take place, by reading some comments this is provided by SQL 2016, but we only have SQL 2014 licensed, so if you can recommand me a tool for this SQL version will be great.
I haven't found any Microsoft solution nor a Third Party one for the column level security.
Is there any alternative?