8 Replies Latest reply: May 9, 2011 1:24 AM by user13372647 RSS

    How to lock oracle user accounts which are not connecting to the DB


      I have the following requirements to be implemented in my oracle DB(

      1. Lock any db user if not has accessed the database for a period of two months
      2. Remove the locked users according to the criteria in 1 from the db, after four months

      Following is already enabled:
      a. session auditing (SQL>audit connect) where last login details of a given account is available in the sys.aud$ table.
      b. password life time and grace time is enabled where the dba_users ACCOUNT_STATUS is changed into EXPIRE at the end of password grace period.

      Please let me know, what is the way to implement 1 and 2 with minimum manual intervention ?

      Charles Ranaweera