This content has been marked as final. Show 1 reply
Updating the profile after a password has expired is like closing the barn door after all the cows have left.
Sure, the new cows won't be able to leave, new users created with the unlimited profile won't get the expired password problem but the 'escaped' cows still need to be fixed. Use a system or /as sysdba connection and set a new value for the user password.
As soon as system (or sysdba) or any user with the DBA role fixes the user account <username> should be good to go. And can set his/her own password as well. Its your database, you get to be the DBA.
sqlplus /nolog conn /as sysdba ... connected ... alter user <username> identified by <new password> account unlock; conn <username> ... password ... ... connected ... alter user <username> identified by <a different password>;
Edited by: clcarter on Dec 3, 2012 12:57 PM
fix code tag typos