Hi,
Oracle Corporation by default will provide the SCOTT user with tiger as password. Scott is the best user for beginners in Oracle. SCOTT User is providing the tables like EMP, DEPT which are having complex logic. As a Oracle beginners we can practice more on the Scott user table improve our knowledge in Oracle. So here I wanna show you how to unlock the SCOTT user, if it is locked by default.
When you are logging into the SCOTT user you may get errors like
ERROR:
ORA-28000: the account is locked.
To unlock this account, you should have the SYSTEM user privileges
Now log in to the SYSTEM user with password ( Which is provided at the time of Oracle Installation ) and run the following command
ALTER USER SCOTT ACCOUNT UNLOCK
Now you can logout from SYSTEM and then try to login SCOTT user with tiger as password.
If you want to lock SCOTT user again.
Log in to the SYSTEM user and type following command
ALTER USER SCOTT ACCOUNT LOCK
Oracle Corporation by default will provide the SCOTT user with tiger as password. Scott is the best user for beginners in Oracle. SCOTT User is providing the tables like EMP, DEPT which are having complex logic. As a Oracle beginners we can practice more on the Scott user table improve our knowledge in Oracle. So here I wanna show you how to unlock the SCOTT user, if it is locked by default.
When you are logging into the SCOTT user you may get errors like
ERROR:
ORA-28000: the account is locked.
To unlock this account, you should have the SYSTEM user privileges
Now log in to the SYSTEM user with password ( Which is provided at the time of Oracle Installation ) and run the following command
ALTER USER SCOTT ACCOUNT UNLOCK
Now you can logout from SYSTEM and then try to login SCOTT user with tiger as password.
If you want to lock SCOTT user again.
Log in to the SYSTEM user and type following command
ALTER USER SCOTT ACCOUNT LOCK
No comments:
Post a Comment