Avatar of elimesika
Flag for Israel

asked on 

Need an advice

I have to monitor product usage by my customers, and I am asked to store the collected information per date in the table and create a report on that table.
The administrator of the application has the sa DB role , so , he is able to change anything, including collected data.
I am looking for a way to make such a change difficult and noticeable.
One option that I can think of is to add (in my c# service) listeners on that table.
Another option is to use another table having that data encrypted and synchronize the tables each X hours (I have no option to decrypt the data on my reporting tool , so I need another table)
What are the best solutions you know?
Microsoft SQL Server 2005Microsoft SQL Server 2008

Avatar of undefined
Last Comment

8/22/2022 - Mon