Home » RDBMS Server » Security » Password expiry (Oracle 11.2.0.3.0,Windows)
Password expiry [message #579932] Sun, 17 March 2013 23:45 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

I see the following in dba_users.

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
Re: Password expiry [message #579934 is a reply to message #579932] Sun, 17 March 2013 23:52 Go to previous messageGo to next message
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?
Re: Password expiry [message #579940 is a reply to message #579932] Mon, 18 March 2013 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Password expiry [message #592793 is a reply to message #579940] Mon, 12 August 2013 07:04 Go to previous messageGo to next message
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...
Re: Password expiry [message #592802 is a reply to message #592793] Mon, 12 August 2013 07:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is this not what I said... several months ago?

Regards
Michel
Re: Password expiry [message #603431 is a reply to message #592802] Mon, 16 December 2013 05:35 Go to previous messageGo to next message
ratneshraman
Messages: 1
Registered: October 2012
Location: Hyderabad
Junior Member
You can set the password at any time.
Re: Password expiry [message #603432 is a reply to message #603431] Mon, 16 December 2013 05:47 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

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


Current Time: Fri Mar 29 10:21:29 CDT 2024