Re: Auditing on record level?

Georg Scholz wrote:
>
> 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

You can do it manually for ins/upd/del in most versions of Oracle with triggers, and additionally you could fine grained auditing in later versions to grab the lot (ie selects as well)

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"