Home » RDBMS Server » Security » ORA-28001
ORA-28001 [message #122184] Fri, 03 June 2005 10:51 Go to next message
Messages: 51
Registered: April 2004

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 ?


Re: ORA-28001 [message #124246 is a reply to message #122184] Fri, 17 June 2005 01:59 Go to previous message
Frank Naude
Messages: 4575
Registered: April 1998
Senior Member

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.

Previous Topic: Finding database ....
Next Topic: Dont want user to connect to connet through SQL plus?
Goto Forum:

Current Time: Mon Sep 25 19:14:39 CDT 2023