Home » RDBMS Server » Security » ORA-28001
ORA-28001 [message #122184] Fri, 03 June 2005 10:51 Go to next message
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 Go to previous message
Frank Naude
Messages: 4565
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
Previous Topic: Finding database ....
Next Topic: Dont want user to connect to connet through SQL plus?
Goto Forum:
  


Current Time: Mon Aug 03 16:23:36 CDT 2020