When developing an application; we generally give options to create,update,delete etc.
here i like to keep/maintain users action (updating,deleting etc...)
The purpose is: one of my client requesting to give update & delete option for sensitive part in database.
i advised to pass a requisition to me and the same will be taking care.
But he promised me to handle in a safe manner and requesting me to give full rights in admin panel.
Finally i agree to give such option (full option in admin panel)
But at the same time i am not sure that he will always handle perfectly as i instructed.
he may miss-handle any time. during that time he will come and apologies and requesting me to give a solution.
So, i need to maintain all his actions including the data which was update/deleted.
How to do ?
Is there any regular practice to keep track or maintain separate database for
the records been update/deleted by Users?
Expecting your valuable reply.