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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Audit - Please Help me

Re: Oracle Audit - Please Help me

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 28 Sep 1998 12:59:33 GMT
Message-ID: <360f8822.2322219@192.86.155.100>


A copy of this was sent to "Maitee Alexandria" <maitee_at_hospitalalianca.com.br> (if that email address didn't require changing) On Sat, 26 Sep 1998 10:34:51 -0300, you wrote:

>I want to audit some tables, but I have a problem.
>How which record can I know it was altered?
>In the table sys.Aud$ I see what table was updated, for who and when, but I
>donīt know which record was update.
>
>Thankīs
>

the only way to get row level updates audited is via a database trigger on the table.  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/ -- downloadable utilities  



Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Mon Sep 28 1998 - 07:59:33 CDT

Original text of this message

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