filmov
tv
Using Oracle DML Database Trigger For Auditing Purpose
Показать описание
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
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