OraFAQ Forum: Security » Password Exp Warning

Home » RDBMS Server » Security » Password Exp Warning (10.2.0.3)

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

Password Exp Warning [message #348091]

Mon, 15 September 2008 10:45

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?

Report message to a moderator

Re: Password Exp Warning [message #348096 is a reply to message #348091]

Mon, 15 September 2008 10:54

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

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

Report message to a moderator

Re: Password Exp Warning [message #348099 is a reply to message #348096]

Mon, 15 September 2008 11:00

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 ?

Report message to a moderator

Re: Password Exp Warning [message #348101 is a reply to message #348099]

Mon, 15 September 2008 11:04

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

Senior Member
Account Moderator

They use a tool that does not check and return it because THERE IS this return code.

Regards
Michel

Report message to a moderator

Re: Password Exp Warning [message #348102 is a reply to message #348101]

Mon, 15 September 2008 11:08

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 ?

Report message to a moderator

Re: Password Exp Warning [message #348109 is a reply to message #348102]

Mon, 15 September 2008 12:01

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

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

Report message to a moderator

Re: Password Exp Warning [message #349050 is a reply to message #348091]

Thu, 18 September 2008 12:55

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

Report message to a moderator

Re: Password Exp Warning [message #349055 is a reply to message #349050]

Thu, 18 September 2008 13:35

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

Senior Member
Account Moderator

Sorry, don't know Forms.
Maybe you should repost this question in Forms forum.

Regards
Michel

Report message to a moderator

Previous Topic:	TDE - Hiding a column in select
Next Topic:	Audit inside trigger activity

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 21:40:14 CST 2024