MS-SQL 2008 Standard - define the security for internal data
Posted on 2016-11-09
Hi database gurus,
I'm looking for a technology for securing data inside a database. Is there is any way there we can secure data by protective marking ?
Any help tips guidance and references are highly appreciated.
I have found it can be done using SQL views and Custom app code. But there would be some disadvantages, further found there will be a security featured implemented in SQL 2016 called "Raw Level Security" but in my case I have MS-SQL 2008 Standard.
Please shed some lights on the situation.
Thanks in advance !