Oracle Database Discussions

Hi all,

I have a little problem.

I am getting familiar with Oracle Auditing but I have a problem I can't seem to be able to solve:

I have Oracle 10.2.0.3 DB on Windows 2003 R2 Server. I need to audit Logon, Logoff and Failed Logon of every user and put the info on either a file or a DB table or the windows event logs.

I managed to activate auditing on the windows log but I get logs about a bit of everything and when I find the log of logon or logon fail (can't seem to find any logoff log) all of the info is stored on the message field. This is quite useless. I need to have the log that states clearly the username (both oracle and user if possible), the action (logon/off/fail), the machine from where the log was made and the time. I don't need any other info, code or anything! Is it possible to set Oracle Auditing to write these info on the windows log?

If it is not possible I need to write this same info either on a file (a single file I can open and store and view and search. I already have the audit on xml but it creates way too many files to keep track of what is happening. I only need one file and new info appended to the file) or on a DB table easy to view.

Can anyone help me? Possibly I would need an answer on all three case scenarios (Winlog, File, Table).

Let me know if you need any other info.

Thank you!