Post reply

finding last login time of a user

  • March 31, 2009 at 10:35 am

    #132318

    Hi all,

    We've been rolling out a LOT of in-house and 3rd party software which uses sql logins all over the place for reporting and what not.. unfortunately, logins and users have been created which are not being used.

    I was wondering if someone had a script or could point me in the right direction of a script that I could run in say a months time which would show the last login time for each of the users in each database. I'd then swing a big stick and say if you aint used it in a month.. im gonna disable it. Then if noone whines inside another month, then I'll delete the users/logins.

    Thanks 🙂

    --------------------------

    I long for a job where my databases dont have any pesky users accessing them 🙂

  • March 31, 2009 at 11:01 am

    #969289

    Hi

    You may have a look for server triggers. There you can specify a LOGON trigger which fires whenever a user connects to server.

    So you can simply insert the logon information to a table and analyze at the end of the month.

    Greets

    Flo

  • March 31, 2009 at 11:04 am

    #969291

    ah nuts.. i was hoping that there'd be something saved in one of the system tables

    thanks

    --------------------------

    I long for a job where my databases dont have any pesky users accessing them 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply