I still have got ORA-28002
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