Detect full access administrator mode on certain database

Hello

I have a database with very sensitive (salary-)data. Of course the data is hidden with reader fields for special roles.

if other than specified users will have that role, a notification mail is sent…

I know an admin is always capable to see also hidden data if they are not encrypted. But it doesn’t have to be so far…

Problem is now, that the admin has simply to switch do fullaccessadmin and he can see the data right away…without having the certain role…

Is there a way to detect if the user has opened the database or any views with Full Administration rights?

regards

Subject: check database access

you can turn on activity tracking or you can track database usage. That is the only way to determine who has accessed the databas. This will not tell what access level was use, only who accessed the file

Subject: check database access