Skip to Main Content

SQL & PL/SQL

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!

SYSMAN user status EXPIRED(GRACE)

malhiNov 8 2012 — edited Nov 8 2012
Some of my users show status EXPIRED(GRACE), i give the following command:
Alter profile default limit password_life_time unlimited;
All of such user become open but SYSMAN user still show;
SQL> select username,expiry_date,account_status from dba_users where account_status='EXPIRED(GRACE)';

USERNAME		       EXPIRY_DA ACCOUNT_STATUS
------------------------------ --------- --------------------------------
SYSMAN					 EXPIRED(GRACE)
What should i do.

Edited by: malhi on Nov 8, 2012 2:12 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 6 2012
Added on Nov 8 2012
1 comment
609 views