Oracle Database Developer Question:

How you Unlock the Sample User Account in Oracle?

Tweet Share WhatsApp

Answer:

Your 10g XE server comes with a sample database user account called HR. But this account is locked. You must unlock it before you can use it:

* Log into the server home page as SYSTEM.
* Click the Administration icon, and then click Database Users.
* Click the HR schema icon to display the user information for HR.
* Enter a new password (hr) for HR, and change the status to Unlocked.
* Click Alter User to save the changes.

Now user account HR is ready to use.

Download Oracle Database Developer PDF Read All 57 Oracle Database Developer Questions
Previous QuestionNext Question
How you Shutdown your 10g XE Server from Command Line?How you can Change System Global Area (SGA) in Oracle?