Re: lock unused oracle user account
Date: Wed, 25 Mar 2009 17:25:17 +1300
how about approaching it backwards - locking all the candidate accounts, and using a logon trigger to unlock them?
2009/2/20 Xu, Roger <Roger.Xu_at_dpsg.com>
> Hi List,
> Without audit being turn on, how do we automate locking all users who
> haven't logged on for 60 days and deleting them after 90 days unused?
> I have tried profile settings.
> Roger Xu