OraFAQ Forum: Security

Home » RDBMS Server » Security » ORA-28001

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: ORA-28001 [message #124246 is a reply to message #122184]

Fri, 17 June 2005 01:59

Frank Naude
Messages: 4596
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!

Code: [Select all] [Show/ hide]

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 04:06:19 CDT 2025