Link to home
Start Free TrialLog in
Avatar of arundintyala
arundintyala

asked on

How to track the last time user accessed database

Hi All,

Just a small doubt,. Could you please let me know if there is any way to find out the last time a user has entered (logged)  into the database? I am working on sybase 12.5 ASE
I checked syslogins and few other tables but couldn't get any relevant information from there. Our database is not tracking this date currently.
SOLUTION
Avatar of bret
bret
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of arundintyala
arundintyala

ASKER

Hi  Bret,

thanks for the reply
This login trigger would update the records from now if I write one. but is there any way to track the existing user logins.

ASKER CERTIFIED SOLUTION
Avatar of Joe Woodhouse
Joe Woodhouse

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
hi all thanks a lot for the replies.. looks like i will write one trigger now atleast to track this down from now