> 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
© William Yuan 2000
Email William