Re: Auditing on record level?

Georg Scholz <georg.scholz_at_vienna.at> schreef in berichtnieuws 3cbpa.175459$UR.1680837_at_news.chello.at...
| Dear Newsgroup,
|
| We use Oracle 8.1.7
|
| I wonder if it is possible to audit table changes on record level ?
|
| Our goal:
| For each record of a table, we want to know who (+ timestamp) has changed
| (inserted, deleted, updated) that record.
| Furthermore, we want to print the complete history of changes for each
| record.
|
| Is that possible?
|
| I read along the audit documentation, tried some statements, and looked
into
| the audit views; but it seems that it's only possible to get information
| only at table detail, not at record detail.
|
| Thanks for any hints
|
| --
| Georg Scholz
| www.scholz-informatik.at
|

Write an on insert/delete/update trigger on that table. Let that trigger do an insert in an auditing table. An example of this can be found in the 8.1.7 Oracle 8i Administrator Guide, Chapter 24, Auditing through database triggers. See http://tahiti.oracle.com for this document. Received on Tue Apr 22 2003 - 13:03:51 CDT