Re: Extract Auditing Information from Oracle Server.

Oracle auditing does provide most of the Details that you wanted like Time,User,Type of Transaction,Objects Involved,Sucess etc ,but may not provide with Old & New values..You might have to use Triggers for that..

To enable Auditing ,
1.Run cataudit.sql located in $ORACLE_HOME/rdbms/admin 2.Add the entry AUDIT_TRAIL = DB in U'r Init.ora and Restart the Instance.
3.Use Various 'AUDIT' Commands available to acheive Object Auditing(DMLs against a specific Object) , Statement Auditing or Privilege auditing.. 4.Audit Records are stored in SYS.AUD$ table and you can query various other views like DBA_AUDIT_TRAIL,DBA_AUDIT_OBJECTS etc..

-Thiru

tjmxyz_at_my-deja.com wrote:

> Hi!
>
> Our system has a logging system that records basically which records
> have changed what in which databse.
>
> It was built in Foxpro and I kept it the way it is for a fast rewrite
> to Oracle...
>
> Problem is I see it as very slow because I can not save in bulk I must
> save row by row...
>
> So the procedure goes in the worst cases..
> FOR i=1 to Number_of_table_records DO
> SAVE THE RECORD
> LOG THE CHANGE TO SEPERATE LOG TABLE
> SAVE THE CHANGE NUMBER TO MAIN TABLE
> END FOR
>
> SO I was thinking about using Oracles Auditing as a replacement for
> the log table as it must store the same thing:
>
> I would like to extract the following information:
> A Uniue key of somekind to reference the record...
> USER,TABLE,TYPE (delete, update ect..)
> ,TIME,MAINKEY in the saved table
> Old and new value.
>
> How can I go about doing this or is it even possible?
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Aug 02 1999 - 10:39:54 CDT