How to lock oracle user accounts which are not connecting to the DB
Hello,
I have the following requirements to be implemented in my oracle DB(10.2.0.4).
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 ?
Thanks
Charles Ranaweera