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

[kevinfr1435]

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

[#2]

@kevinfr1435 

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