Re: [?] SYSDBA audit

From: Mark Bole <makbo_at_pacbell.net>
Date: Mon, 14 Feb 2005 21:11:55 GMT
Message-ID: <vu8Qd.4891$aW6.953@newssvr22.news.prodigy.net>

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 Mon Feb 14 2005 - 15:11:55 CST