September 2006
Intermediate to advanced
562 pages
18h 33m
English
A common requirement for database designs is to record the name of the user who created the record, as well as the name of the user who last modified the record, in separate columns (CREATED_BY and MODIFIED_BY, respectively) in each table. In addition, the creation date and last modified date are stored in two more columns (CREATED_DATE and MODIFIED_DATE, respectively). Although this information does not provide a complete history of the record, it helps track some of the activity. For a complete history, you would create a journal table for each table that requires operation-level audits. This journal table would store details about every INSERT, UPDATE, ...
Read now
Unlock full access