Data Activity Tracking Using SQL Triggers


Introduction

In Today’s IT world, data is everything, so providing data access to many users introduces a potential threat of unknown risks. We must take proper measures to capture data changes and updates to avoid such risks. Therefore, the data managers must apply tools to track each data activity done by the users who have read-write access to the data. This data tracking tool needs to be implemented at the field level for each available data element. In this article we will discuss such tools and cover the following topics:

Setting up the database tables and triggers Generic and