OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » password expired

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

password expired [message #121753]

Tue, 31 May 2005 16:55

Hina
Messages: 51
Registered: April 2004

Member

create user <username> identified by <password> password expire;

Its working fine in SQLPLUS, I have an application (WEB) where
all new user will be created.

How can I force them to reset or change their password when
they logs in first time.

Any clue ?

Thanks

Report message to a moderator

Re: password expired [message #121792 is a reply to message #121753]

Wed, 01 June 2005 00:58

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

ALTER USER <username> PASSWORD EXPIRE;

This Force user to choose a new password when he logs in.

Report message to a moderator

Re: password expired [message #121867 is a reply to message #121792]

Wed, 01 June 2005 09:27

Hina
Messages: 51
Registered: April 2004

Member

As I said, its working fine in SQLPLUS.

But, how to handle in JAVA, because oracle is sending an exception to JAVA.

Thanks

Report message to a moderator

Previous Topic:	Error while initializing database configuration assitant tool.
Next Topic:	ora-01555

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 01 05:13:00 CDT 2026