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.
arundintyalaAsked:
Who is Participating?
 
Joe WoodhouseConnect With a Mentor Principal ConsultantCommented:
I'm pretty sure there is no way to get this retroactively if nothing was set up in advance to capture it.

It's exactly the same as setting up a video camera outside your front door - it can't tell you anything about what happened before you installed it.

We should also be clear on the difference between logging it to Sybase (connecting to the ASE) and using a database. They aren't the same thing, and you would need very different solutions to be able to see one set of data vs the other. (They may actually effectively be the same thing when a login has had a default database defined, but even so internally the process of connecting to the Sybase server is still not the same thing as connecting to a database within a Sybase server.)
0
 
bretConnect With a Mentor Commented:
There are a couple of ways to do it, but nothing automatically track this.

You can set up auditing and audit logins.  That was the traditional solution, but is a bit much if that is all you want to audit.

You can also create a login trigger that updates a table every time someone logs in.

0
 
arundintyalaAuthor Commented:
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.

0
 
arundintyalaAuthor Commented:
hi all thanks a lot for the replies.. looks like i will write one trigger now atleast to track this down from now
0
All Courses

From novice to tech pro — start learning today.