Hands-on Practice: Load Audit Columns Using a Database Procedure and Application Context
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, ...
Get Oracle JDeveloper 10g for Forms & PL/SQL Developers: A Guide to Web Development with Oracle ADF now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
