OraFAQ Forum: Security » Password expiry

Home » RDBMS Server » Security » Password expiry (Oracle 11.2.0.3.0,Windows)

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

Password expiry [message #579932]

Sun, 17 March 2013 23:45

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

I see the following in dba_users.

Code: [Select all] [Show/ hide]

select username,account_status,EXPIRY_DATE from dba_users;

USERNAME   ACCOUNT_STATUS  EXPIRY_DATE
-------------------------------------------------
DEMO       EXPIRED(GRACE)  2013-03-20 10:52:48

My question here is what if we dont reset the password by 20th of March.Will we not be able to reset the password once the password is expired ?

Thank you

Report message to a moderator

Re: Password expiry [message #579934 is a reply to message #579932]

Sun, 17 March 2013 23:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>My question here is what if we dont reset the password by 20th of March.Will we not be able to reset the password once the password is expired ?
does "we" include me?

Report message to a moderator

Re: Password expiry [message #579940 is a reply to message #579932]

Mon, 18 March 2013 01:29

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

When the password is expired you will enter in grace at the next connection.
AS always for your questions, this is explained in the documentation.

Regards
Michel

Report message to a moderator

Re: Password expiry [message #592793 is a reply to message #579940]

Mon, 12 August 2013 07:04

8939513598$
Messages: 103
Registered: July 2013
Location: chennai

Senior Member

It depends upon the parameter 'PASSWORD_GRACE_TIME' the value how much you were initializing...

Report message to a moderator

Re: Password expiry [message #592802 is a reply to message #592793]

Mon, 12 August 2013 07:52

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Is this not what I said... several months ago?

Regards
Michel

Report message to a moderator

Re: Password expiry [message #603431 is a reply to message #592802]

Mon, 16 December 2013 05:35

ratneshraman
Messages: 1
Registered: October 2012
Location: Hyderabad

Junior Member

You can set the password at any time.

Report message to a moderator

Re: Password expiry [message #603432 is a reply to message #603431]

Mon, 16 December 2013 05:47

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No, you cannot if your password is expired and your grace period exhausted.

Report message to a moderator

Previous Topic:	AUDIT ALTER ANY TRIGGER
Next Topic:	Default Oracle Users

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 10 20:11:43 CDT 2025