By leaving an Audit Trail in the database, one can keep track of all the activities (in the form of operations) going on the database. All this is concerned with the security of database. I am new to this important feature of Database and in a brainstorming session comes up with numerous ways to design it.
There are two most common ways to achieve this task, both have their pros and cons.
- One is to maintain a single table in the database that stores all the actions within a database.
- Another is to create a an Audit table for every table in the database.
(More to Add)