We had the same problem and we made it up by inserting columns date modified
and user modified in each table. Now we can control what every user were
doing in past. Also we made queries to check what is going with our data.
Robert Dimitrovski
"Georg Scholz" <georg.scholz_at_vienna.at> wrote in message
news: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
>
>
>
Received on Tue Apr 22 2003 - 10:03:26 CDT