We are working on making our data ITAR Compliant so for that we are thinking of using the dynamic data masking technique .
DB we are using is sql server and at the database level masking works fine but the problem is that we have one DB connector thing which uses admin user for connection to DB .
If we change this user to normal user, then masking works fine but masked data cannot be accessed for calculations and other business logic which creates problem for us.
Is there any other way of achieving this without creating new DB connector thing ?
