How to unlock hr schema in oracle express edition


Unlocking HR Schema in Oracle 10g

For working with oracle database tables you need to install oracle database and unlock
the sample HR schema from your installed version of oracle database.

Here I am going to describe steps and screenshots to unlock the HR schema.

step 1 : After installing oracle database go to the database homepage and login with system  and password.

                            



step 2: After login you can see screenshot page in this page you have to go Administrator link.





step 3: Click on Administrator select Database Users.


step 4: After that go to Manage Users and select manage users.

step 5: Here you can see inside the Manage Users there is HR which is locked click on HR.


step 6:  By default HR user Account status is locked just type the password and select unlocked in account status.


step 7: After that click on Alter User  and you can also set user privileges by selecting Roles.




And you have unlocked the HR schema and now you can connect HR with SQL*Plus or from sql developer.

No comments:

Post a Comment