| Password Expire problem [message #538684] |
Mon, 09 January 2012 00:10  |
 |
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 #538693 is a reply to message #538690] |
Mon, 09 January 2012 01:32  |
John Watson
Messages: 8960
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 #538724 is a reply to message #538720] |
Mon, 09 January 2012 03:52 |
cookiemonster
Messages: 13958
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 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
