Forum Discussion
kevinfr1435
Apr 15, 2024Copper Contributor
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
- SivertSolemIron Contributor
Hi Kevin,
It would appear that this level of control was introduced in SQL Server 2022, see this Github issue.
https://github.com/MicrosoftDocs/sql-docs/issues/7787#issue-1301876883