Re: lock unused oracle user account
- From: "~Jeff~" <jifjif@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- 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?
-Jeff Wong
2009/2/20 Xu, Roger <Roger.Xu@xxxxxxxx>
> 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.
>
> Thanks,
>
> Roger Xu
>
Other related posts:
