I have a problem. I need to change account_status to open for one user whose account_status was set to EXPIRED by mistake (by assigning a profile with verify_function). If I knew the password I could chnage the password to the same password and be done with. But I don't know the password. Is there a way to manually update account_status column in dba_users to show it OPEN and not EXPIRED?
Another user has account_status showing EXPIRED(GRACE). I need that user to show OPEN. Fortunaltely I know the password. I am guessing I can reset the password to the same password like alter user test identified by summer;