Lock database accounts if not accessed for last 30 days
I am using Oracle 10.2.0.4 on HP UNIX. I have to lock database accounts, which have
not been accessed in last 30 days. I cannot find anyway to get information from data dictionary when was the last time a user connected to that account unless I turn database
auditing on. I do not want to turn auditing on just to get this information.
Oracle’s profile mechanism will expire a password after PASSWORD_LIFETIME but there is no provision in PROFILE to lock account if it was not accessed for x days.
Is there any other way to get the account. Logon time?