This content has been marked as final. Show 4 replies
alter user <username> identified by <new_password>;1 person found this helpful
to make password unexpired:
in the profile of the user--> alter profile <profile_name> LIMIT password_life_time UNLIMITED;
Hi,1 person found this helpful
Did you created users with default profile?
When you create a user account, a default password policy is assigned to that user account. The default password policy for a newly installed database includes these directives:
1. The password for the user account expires automatically in 180 days.
2. The user account is locked 7 days after password expiration.
3. The user account is locked for 1 day after 10 failed login attempts.
The default password policy is assigned to user accounts through a database object called a profile.
Mahir M. Quluzade
my fault, i didn't read it at all.1 person found this helpful
When your user password expired, he could be connect some days. Depends the value of PASSWORD_GRACE_TIME. This value is the days that your user still can connect, if the grace time is set to unlimited you can login without problem
Check Ed Stevens blog's:
*edited link, i posted another....
Edited by: Fran on 12-dic-2012 6:00
Please read below link where Ed has explained very well in detail :1 person found this helpful
Thank you so much for such a nice explanation.