ORA-28001 [message #122184] |
Fri, 03 June 2005 10:51 |
Hina
Messages: 51 Registered: April 2004
|
Member |
|
|
I have a WEB based application where user will be created, or
connected from WEB using Oracle.
Why Oracle return same exception ORA-28001 for both cases.
1. If existing user gets expired after certain time of period
2. If we use PASSWORD EXPIRE clause at a time of CREATE USER (NEW)
I have to perform two different functionality with respect
to each exception.
Or, Is there any alternate of 'EXPIRE PASSWORD' clause ?
Regards
|
|
|
Re: ORA-28001 [message #124246 is a reply to message #122184] |
Fri, 17 June 2005 01:59 |
Frank Naude
Messages: 4587 Registered: April 1998
|
Senior Member |
|
|
Hi,
Passwords or web/ application users should never expire. When they do, users will not be able to work anymore and the app will be down!
// *Cause: The user's account has expired and the password needs to be
// changed
// *Action: change the password or contact the DBA
//
Best regards.
Frank
|
|
|