auditing

[murugappan]

Hi everyone,

I want to know a particular user's information say 'A" as follows:-

Login time, Logout time and how many hrs he is connected to database.

The thing is that some 'n' number of users will be connected thru client using the same user name 'A" , say some 10 users are connecting using the username 'A".

I wish to know the info for a particular osuser say 'mum_gic'
who connects using 'A' and the above said information.

How to do this using auditing...?

Thanx

[marist89]

If you are using version 8.1.x, you can create a Logon Trigger and capture this information to a table you have setup.

http://technet.oracle.com/docs/produ...6d.htm#2064180