Last modified by and modification time for records in a view

For each record in a table, we want to record who last modified it and when. This becomes a problem when we want to find out who last modified a record in a view since it can be a "join view". So, we thought if we can determine the base table for the particular field in the record that they are interested in, we can query the base table and return the modification time and modifier fields. Any ideas? How do people generally deal with last modifier and modification times? The AUDIT feature in oracle doesn't seem to apply since we want to keep track for each and every record.

(I know that this plan has the flaw that the modification time and person might not reflect changes to the particular field they are interested in , only the fact that some fields in the same record in the base table got changed, but we won't worry about that.)

As usual, a cc to my email at lpoon_at_isr.umd.edu would be appreciated. TIA

Leon Received on Thu Sep 17 1998 - 18:28:26 CDT