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: Audit

Re: Audit

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: Tue, 22 Sep 1998 21:19:23 -0700
Message-ID: <6u9sjf$jb6@dfw-ixnews3.ix.netcom.com>


I don't think there will be any tables out there that store those kind of info. But you can always write a trigger on those tables to capture the changes. Or, try to turn the SQL TRACE on to capture all the transaction on a certain group of tables.

Winnie

Maitee Alexandria wrote in message
<645346C45E37D211ACDC006097D1798CC1CE6E_at_news.telebahia.net.br>...
>I´ll want to Audit some tables.
>
>Are there any view, or sys.tables that allows to see the record deleted,
>updated or inserted ?
>
>Thank´s
>
>
>
Received on Tue Sep 22 1998 - 23:19:23 CDT

Original text of this message

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