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: [?] SYSDBA audit

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

Original text of this message

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