DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: last logging date

  1. 03-07-2007, 12:05 PM #1
    steeve123
    steeve123 is offline Senior Member
    Join Date
    Nov 2000
    Posts
    440

    last logging date

    We are upgrading are oracle licenses.
    And We need to expire accounts that are not used anymore.

    I need to lock users that did not logging since 2 months.
    But there is no last logging date in dba_users.
    How can i have this info?


    What would be a good approch to identify each users that are active?
    Reply With Quote Reply With Quote
  2. 03-07-2007, 12:26 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    look at your audit records - else you dont know
    Reply With Quote Reply With Quote
  3. 03-07-2007, 12:27 PM #3
    tamilselvan
    tamilselvan is offline Senior Advisor
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    First Lock all users.

    Eventually, the users will send you email to unlock their account.
    Tamil
    http://www.oracleact.com
    Reply With Quote Reply With Quote
  4. 03-07-2007, 12:39 PM #4
    jhmartin
    jhmartin is offline Member
    Join Date
    Jun 2001
    Posts
    242
    Oddly enough, Oracle does not automatically track this. You can write a logon trigger that does it for you or enable auditing in the future, but that doesn't help track historical logins.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width