Re: [?] SYSDBA audit

If you look in administrative tools > event viewer is there not a button that enables one to export to a csv file the application log? Unfortunately, that may only be able to be done manually. Maybe some enterprising soul has tried to write a Perl script to do this ....

If you insist on using Windows, you will continue to face this type of obstacle.

Mark Bole wrote:
> wfholmes_at_yahoo.com wrote:
>
> > Well, you can find on the internet information that shows that
> > audit_sys_operations can be set along with the audit_file_dest
> > parameter.
> >
> > Look at treating the trace files generated as external files. This
> > might make them accessible to sql.
> >
> >
> > Vladimir wrote:
> >
> >>>Set the initialization file parameter audit_trail=db; the aud$
> >
> > table,
> >
> >>>in which the audit rows are stored, is owned by SYS and is in the
> >>>system tablespace by default.
> >>
> >>It's not my case: SYSDBA activity doesn't reflects into aud$.
> >
> >
>
> See original post -- running under Windows, audit_file_dest won't
write
> a file, so no external table unless you have a utility for
automatically
> dumping the Windows Event log.
>
> -Mark Bole
Received on Tue Feb 15 2005 - 07:20:10 CST