Forum Discussion

kevinfr1435's avatar
kevinfr1435
Copper Contributor
Apr 15, 2024

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

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?

 

Regards

 

Resources