inactive users after certain period
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: inactive users after certain period

  1. #1
    Join Date
    Oct 2003
    Posts
    312

    inactive users after certain period

    Hi all,

    How can inactive or lock the users if let's say if he is not login the database for 365 days???

    please advise and thanks

  2. #2
    Join Date
    Jan 2003
    Location
    india
    Posts
    175
    you can have a trigger that fires every time an user logs in
    that updates a table with last login time.

    may be another schedule to lock the user based on this table.

    this may not be the optimal. because you will have to
    wait another 365 days.

    is there any view to get the last login time? anybody?

    -Raja

  3. #3
    Join Date
    Oct 2003
    Posts
    312
    ANY OTHER ADVISES ?????

    THANKS

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    go and read about profiles

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width