Home » RDBMS Server » Security » Password Expire problem
Password Expire problem [message #538684] Mon, 09 January 2012 00:10 Go to next message
TOFARHAN
Messages: 19
Registered: June 2011
Location: farisalabad
Junior Member
Sir,
I create a profile that limit the user password life time 7 days.
But when user logon to database through sqlplus .Its show user password will be expired 24855 days.
I check the profile setting with
select * from dba_profiles and
select * from dba_users;

Regards,

Farhan.
Re: Password Expire problem [message #538685 is a reply to message #538684] Mon, 09 January 2012 00:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Password Expire problem [message #538690 is a reply to message #538685] Mon, 09 January 2012 01:21 Go to previous messageGo to next message
TOFARHAN
Messages: 19
Registered: June 2011
Location: farisalabad
Junior Member
sir,

connect system user account
create profile my_profile limit
password life_time 7
password_grace time 5;
alter user scott profile my_profile;

Regards,

Farhan.
Re: Password Expire problem [message #538693 is a reply to message #538690] Mon, 09 January 2012 01:32 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Farhan, you need to show what you actually did. This is what happens when I run your code above:
orcl> create profile my_profile limit
  2  password life_time 7
  3  password_grace time 5;
password life_time 7
*
ERROR at line 2:
ORA-02376: invalid or redundant resource


orcl>

Your code is syntactically wrong, that is why it didn't work.
Re: Password Expire problem [message #538695 is a reply to message #538684] Mon, 09 January 2012 01:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SQL*Plus and copy and paste your session, the WHOLE session.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Re: Password Expire problem [message #538720 is a reply to message #538695] Mon, 09 January 2012 03:48 Go to previous messageGo to next message
TOFARHAN
Messages: 19
Registered: June 2011
Location: farisalabad
Junior Member
Sir,
I attach the session.

  • Attachment: password.JPG
    (Size: 60.12KB, Downloaded 1402 times)
Re: Password Expire problem [message #538724 is a reply to message #538720] Mon, 09 January 2012 03:52 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Don't attach screen shots, many people can't/won't open attachments.
Copy and paste the text here in code tags, as described in the link Michel posted above.
Re: Password Expire problem [message #538725 is a reply to message #538720] Mon, 09 January 2012 03:53 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Copy and paste your session in TEXT mode INSIDE the post (not attached file), with code tags and appropriate format.
2/ Post ALL what we ask (see what is in bold)

Regards
Michel
Previous Topic: Creating table in other schema
Next Topic: Can only log onto db via server.
Goto Forum:
  


Current Time: Thu Mar 28 09:08:17 CDT 2024