RE: lock unused oracle user account
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <jifjif@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 Mar 2009 14:48:14 -0400
Regrettably this doesn't work as a locked account never gets that far.
Best thing would be to create a on login trigger that fills in the
username and date into a table defined by yourself.
Dick Goulet
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of ~Jeff~
Sent: Wednesday, March 25, 2009 12:25 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: lock unused oracle user account
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:
