Re: Auditing on record level?

"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

check out these concepts:

• workspace manager (can use it for versioning of data) native in 9.2, can be installed in 8.1.7
• fine grained auditing combined with dbms_flashback enterprise edition required

hth,

Pd Received on Tue Apr 22 2003 - 19:36:05 CDT