Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I still have got ORA-28002

HuaMin ChenJul 11 2010 — edited Jul 11 2010
Hi,

why do I still have the expiry date?

10:04:27 SQL> CREATE PROFILE prof LIMIT
10:08:25 2 FAILED_LOGIN_ATTEMPTS 4
10:08:25 3 PASSWORD_LOCK_TIME 30
10:08:26 4 PASSWORD_LIFE_TIME 500;

Profile created.

10:08:29 SQL> alter user mylogin profile prof;

User altered.

10:08:54 SQL> conn mylogin/mylogin@comp11gd
ERROR:
ORA-28002: the password will expire within 4 days


Connected.
10:09:18 SQL>

Regards,
huamin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 8 2010
Added on Jul 11 2010
9 comments
1,324 views