How to check which database roles can see `masked` columns?
2
votes
1
answer
5029
views
In
SQL Server 2016 SP1
standard edition we can use dynamic-data-masking . The masking of data is controlled using the built-in security, for example:
REVOKE UNMASK TO user_who_cannot_see_senstive_data
Of course, this is not working for the users who are members of the db_owner
database role.
Is there a list with security roles or cases showing when the REVOKE UNMASK
is going to work?
I have found a database engine permissions but it's too complicated and does not seem to show when data cannot be masked from a user.
Asked by gotqn
(4348 rep)
Jun 13, 2017, 01:16 PM
Last activity: Jun 13, 2017, 01:31 PM
Last activity: Jun 13, 2017, 01:31 PM