How to unlock the user
How to unlock the user in oracle, or how to solve ORA-28000
SQL> conn sqlplus AS sysdba
Enter password:
Connected.
example:
SQL> conn sqlplus as sysdba
Enter password:
Connected.
SQL> alter user scott
2 account unlock;
User altered.
SQL> conn scott/tiger
ERROR:
ORA-28001: the password has expired
Changing password for scott
New password:
Retype new password:
Password changed
Connected.
Looking forward for your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav
How to unlock the user in oracle, or how to solve ORA-28000
SQL> conn sqlplus AS sysdba
Enter password:
Connected.
SQL> ALTER USER username 2 ACCOUNT UNLOCK;
example:
SQL> conn sqlplus as sysdba
Enter password:
Connected.
SQL> alter user scott
2 account unlock;
User altered.
SQL> conn scott/tiger
ERROR:
ORA-28001: the password has expired
Changing password for scott
New password:
Retype new password:
Password changed
Connected.
Looking forward for your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav
No comments:
Post a Comment