| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Looking for suggestions...
Mary,
Unless I'm misunderstanding something, I think you should be able to do this via dbms_job. When the user has made his 5th unsuccessful attempt to login, and as a result you set ACCTLOCK = 1 for that user, at the same time you could also submit a dbms_job that will kick off in 30 minutes (i.e. SYSDATE + 30/1440) and execute a procedure to set ACCTLOCK = 0 for that user.
Michael T.
Mary Benson wrote:
> We got the following request from our HR technical team. Has anyone
> done anything similar or have any reccomendations?
>
> REQUEST:
> "As part of the security review of the Self Service application, we need
> to institute an account lock-out after 5 unsuccessful attempts when
> requesting a new password. Additionally, the requirement calls for us
> to reset the lock-out after 30 minutes. We can set the lock-out, but we
> have no way to reset the lock-out after 30 minutes through the
> application, but thought there could be a way to do this at the Oracle
> level, like a database agent.
>
> To do this, the agent would need to run against the PSOPRDEFN table, and
> check the value of LASTUPDDTTM (date/time stamp). If 30 minutes have
> elapsed and the value of ACCTLOCK = 1, then reset the ACCTLOCK to 0."
>
> Thanks.
> Mary Benson
> Database Admin.
> Tufts University
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Jun 11 2004 - 09:12:46 CDT
 |
 |