Sample Header Ad - 728x90

Masking data for SA users

0 votes
2 answers
385 views
I'd like to able to mask data for all users including SA's. I'm not trying to guard against malicious intent, but rather, stop people unintentionally seeing data they shouldn't. Dynamic Data Masking seemed like a good solution but, from what I've read, it doesn't apply to admin users. Is there a good alternative? This is for a database that has not yet been created. I'll be importing data from other data sources. Our default version\edition is SQL 2017 Enterprise. Azure PaaS is also a possibility.
Asked by AlexP012 (53 rep)
Nov 15, 2023, 01:19 PM
Last activity: Nov 22, 2023, 12:55 AM