Using SQL*Plus to Unlock Accounts and Reset Passwords
Use this SQL*Plus procedure to unlock and reset user account passwords.
$ $ORACLE_HOME/bin/sqlplus
SQL> CONNECT SYS as SYSDBA
Enter password: sys_password
4. To unlock an account:
ALTER USER account ACCOUNT UNLOCK;
5. To reset the password:
ALTER USER user_name IDENTIFIED BY new_password;
Note:
If you unlock an account but do not reset the password, then the password remains expired. The first time someone connects as that user, they must change the user's password.
No comments:
Post a Comment