Home » RDBMS Server » Security » Password Exp Warning (10.2.0.3)
Password Exp Warning [message #348091] Mon, 15 September 2008 10:45 Go to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Hello Folks,

Application development team is using TOAD/SQLPLUS and SQLNavigator. I have a strange issue here that AD team are not seeing a warning during the grace period before password expiration. The only way they know their passwords have expired is when their accounts are locked after the grace period expires.



Has anyone else had this experience? If so, how is it handled--other than to get one's account unlocked and password reset?

Re: Password Exp Warning [message #348096 is a reply to message #348091] Mon, 15 September 2008 10:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle grace period starts AFTER expiration.
During grace period they still can connect but get a warning (ORA-28002 or 28011).

Regards
Michel


Re: Password Exp Warning [message #348099 is a reply to message #348096] Mon, 15 September 2008 11:00 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Yes Michael, That's idle case, but they are not getting any warning message in grace time... That's the issue. What could be the reason ?
Re: Password Exp Warning [message #348101 is a reply to message #348099] Mon, 15 September 2008 11:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
They use a tool that does not check and return it because THERE IS this return code.

Regards
Michel
Re: Password Exp Warning [message #348102 is a reply to message #348101] Mon, 15 September 2008 11:08 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
in case of SQLPLUS client also ... they are not getting any warning message.??? Is there any other way where we can add return code on those tools ?
Re: Password Exp Warning [message #348109 is a reply to message #348102] Mon, 15 September 2008 12:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You surely missed something.

SQL> create profile prof limit password_life_time 1/1440 password_grace_time 1/144;

Profile created.

SQL> alter user scott profile prof;

User altered.

SQL> select account_status from dba_users where username='SCOTT';
ACCOUNT_STATUS
--------------------------------
EXPIRED(GRACE)

1 row selected.

SQL> connect scott/tiger
ERROR:
ORA-28002: the password will expire within 0 days


Connected.


Regards
Michel
icon10.gif  Re: Password Exp Warning [message #349050 is a reply to message #348091] Thu, 18 September 2008 12:55 Go to previous messageGo to next message
ajda_duenas
Messages: 3
Registered: September 2008
Location: Honduras
Junior Member

Hello.

I have a question?.

How can configured the ORA-28001 and ORA-28011 in a trigger ON-ERROR en Oracle Forms 9.04, and configure the days against the expire date.

Thanks. Smile
Re: Password Exp Warning [message #349055 is a reply to message #349050] Thu, 18 September 2008 13:35 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry, don't know Forms.
Maybe you should repost this question in Forms forum.

Regards
Michel
Previous Topic: TDE - Hiding a column in select
Next Topic: Audit inside trigger activity
Goto Forum:
  


Current Time: Thu Mar 28 18:41:46 CDT 2024