SQL 2017 - Granting unmask access to security group not working getting errors

Copper Contributor

Hi All,


I am trying to grant unmask access for a security group for a specific table and for a specific column however im getting a the below error message.


query executed.


GRANT UNMASK ON schemaName.tablename(ColumnName) TO [Account that requires access, in my case a security group]

error message :


Msg 102, Level 15, State 1, Line 0

Incorrect syntax near 'UNMASK'.


Anyone experience this issue and how does one resolve this?




1 Reply


Hi Kevin,
It would appear that this level of control was introduced in SQL Server 2022, see this Github issue.