Re: ORACLE (10 and XE): audit_trail on windows event

From: Michele \ <mike_at_job.giob>
Date: Wed, 23 Sep 2009 12:39:23 +0200
Message-ID: <wVmum.40913$Tq6.36096_at_tornado.fastwebnet.it>

Hi all,
  ok, i solved 50% of the proble, isntalling the 11x version. Now the login are logged on the event viewer:

Log Name:      Application
Source:        Oracle.orcl
Date:          23/09/2009 12.04.36
Event ID:      34
Task Category: None
Level:         Information
Keywords:      Classic
User:          N/A
Computer:      w2008mike

Description:
The description for Event ID 34 from source Oracle.orcl cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

ACTION : 'CONNECT' DATABASE USER: 'SYS' PRIVILEGE : SYSDBA CLIENT USER:   CLIENT TERMINAL: unknown STATUS: 0

Also the failed LOGIN are logged:

Log Name:      Application
Source:        Oracle.orcl
Date:          23/09/2009 12.03.45
Event ID:      34
Task Category: None
Level:         Information
Keywords:      Classic
User:          N/A
Computer:      w2008mike

Description:
The description for Event ID 34 from source Oracle.orcl cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

ACTION : 'CONNECT' DATABASE USER: 'SYS' PRIVILEGE : NONE CLIENT USER: CLIENT TERMINAL: unknown STATUS: 1017

...

But for to have also the LOGOFF, it is possible without special triggers, or not?

Thankyou Received on Wed Sep 23 2009 - 05:39:23 CDT