Questions tagged [dynamic-data-masking]

I am using Azure SQL database and some of the table columns are using Dynamic mask like this: CREATE TABLE PartialMask ( ID INT IDENTITY (1,1) PRIMARY KEY NOT NULL, Name VARCHAR(255) MASKED WITH (FUNCTION = 'partial(2, "XXXXXX",2)') NULL, …

If I have a SQL Server user that has UNMASK permissions on a table, is it possible for that user to still get results with masked data? My use case is that I have a service that returns employee data. Since SQL Server does not support OAuth2 /…