ALOMOHORA

To create your application, you need to log in as a database user. Oracle Database XE comes with a sample database user called HR. This user owns a number of database tables in a sample schema that can be used to create applications for a fictional Human Resources department. However, for security reasons, this user’s account is locked. You need to unlock this account before you can build a sample application.

To unlock the sample user account:

• Make sure you are logged on as the database administrator. As described in the previous section.

• Click the Administration icon, and then click Database Users.

• Click the HR schema icon to display the user information for HR.

• Under Manage Database User, enter the following settings:

Password : Enter hr for the password.

Confirm Password : Enter hr for the password again.

Account Status : Select Unlocked.

Roles : Ensure that both CONNECT and RESOURCE is enabled.

• Click Alter User.

Now you are ready to create your first application.

Incoming search terms for the article:

how to unlock sample schema, unlocking the sample user account