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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hi all thanks a lot for the replies.. looks like i will write one trigger now atleast to track this down from now
ASKER
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.