Re: grab logon time

Depending on the Oracle version. 8 or 8i? there is now a logon trigger which could be used to populate a table.....Logoff? Oracle can now track queries as well.

In Oracle 7 the application used to login (C/S, Web app...) could populate the table. The app would also have to catch the logoff to note the time and update the table...

For anything meaningful what they did when logged should say more to mgmt. This gets back to auditing periodically based on usage...

hth,
Dave Fowler
Oracle DBA/Developer

Naushi Hussain <Naushi.Hussain_at_Alliedsignal.com> wrote in message news:381E2462.B75EDA65_at_Alliedsignal.com...
> Our Management is trying to keep track of who was logged on for how long
> in the system. I am using v$session to get a report like this. I thought
> I could take the min logon-time and subtract it from max logon-time for
> a particular user - this will give the number of hours/min he was logged
> on. The problem with that is that if the person logs off for two hours
> and logs back on then the above method will still show him as logged on
> all the time - since we will still subtract the min from max.
>
> How do we get a real picture of how long was some one logged on today.
>
> Any suggestins will be appreciated
>

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Mon Nov 01 1999 - 21:34:09 CST