Using Oracle DML Database Trigger For Auditing Purpose

preview_player
Показать описание
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

Рекомендации по теме