Wednesday, 25 May 2016

Unlock HR Schema of the Oracle Database

Requirement: Unlock HR Schema of the Oracle Database
Solution: For solution of the above requirement follow the steps a shown below:
Step 1: Run SQL Command Line.
Step 2: Connect to the User "SYSTEM" with the corresponding password. Thus the command is
connect system/system;
Step 3: Execute the below command to alter password and to unlock the HR schema.
 ALTER USER HR IDENTIFIED BY HR ACCOUNT UNLOCK;
Here, HR is the password that we want to set for your HR user.
Step 4: Connect to the user HR by providing the user-name and password. To do so execute the below command:
CONNECT HR/HR;
Here, the user-name is HR and password is HR.
After the connection is established we can use all the tables, sequences, etc. that are in the HR Schema.

Hence, the solution to our requirement.
If you like the posts, please comment, share and like me on Facebook.

Thanks & Regards,
Susanto Paul