Auditing Table means keeping monitoring of all the dml activities occurred on a specific table of the database like Insert, Update or Delete single row row at a time from the table and when. It is like tracking the users activity who are messing with your data.
Monitoring user activity for missing, manipulating records is important
part for a business. In this video I tried to show how to use trigger on
a table to get information about the client machine, ip address etc.
All this information will be stored in a table which can be used in
presentation to analyses any manipulated data.
Please download the following script from the below link
https://drive.google.com/file/d/1fH79eeLUd-Xcz42qSjsAfK8wYfgtE1y9/view?usp=sharing
No comments:
Post a Comment