Re: lock unused oracle user account

From: ~Jeff~ <jifjif_at_gmail.com>
Date: Wed, 25 Mar 2009 17:25:17 +1300
Message-ID: <363634910903242125n797f8988k259eb913335951fe_at_mail.gmail.com>

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_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.
>
> Thanks,
>
> Roger Xu
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 24 2009 - 23:25:17 CDT