Session Login Times

> hi there,
> is there any SQL command which will tell me when the current session
> started, ie. when the user logged into ingres.
> im using ingres 6.4/04 on a alpha vms box
> or do i have to work backwards with dbmsinfo('_et_sec').
> tia
> _____________________________________________________
> Natarajan V Nellicherry
> Mayo Foundation
> nellicherry.natarajan@mayo.edu (E-mail)
> _____________________________________________________

Hi Natarajan,
    In sql, you could try either of:

    select _date(int4(dbmsinfo('_bintim'))-int4(dbmsinfo('_et_sec')))\g

        Output format of date is "dd-mmm-yy"

or, select _time(int4(dbmsinfo('_bintim'))-int4(dbmsinfo('_et_sec')))\g

        Output format is "hh:mm"

    Neither of these really thrill me. What we do is place our users in a
    captive menu system and then as they access various databases record the
    access time in a system log file "/var/adm/log/syslog". This information
    is retrieved later to be fed into our audit database. This is also a
    little bit of kludge!

    Martin Bowes
Ingres Q & A
Back to William's Home Page
Email William