Re: Looking for suggestions...

From: Lon White <lon_dba_at_cox.net>
Date: Fri, 11 Jun 2004 23:35:39 -0700
Message-ID: <007601c45047$7a695500$6401a8c0@lonlaptop>

Hi Mary,

If this is Oracle Apps you can use the FNDCPASS utility to rest the password after 30 minutes...

Regards,
Lon

Original Message ----- From: "Mary Benson" <mary.benson_at_tufts.edu> To: <Oracle-L_at_freelists.org> Sent: Friday, June 11, 2004 6:16 AM Subject: Looking for suggestions...

> 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
> -----------------------------------------------------------------

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
-----------------------------------------------------------------

Received on Sat Jun 12 2004 - 01:33:19 CDT