Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Auditing on record level?

Re: Auditing on record level?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 23 Apr 2003 13:42:12 +0800
Message-ID: <3EA627B3.6A68@yahoo.com>


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"
Received on Wed Apr 23 2003 - 00:42:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US