Unlocking the HR Account

This section shows how to unlock the HR account and reset its password.

By default, when the HR schema is installed, the HR account is locked and its password is expired. You can connect to Oracle Database as the user HR only if the HR account is unlocked.

Note: For the following procedure, you need the name and password of a user who has the ALTER USER system privilege (for example, SYSTEM).

To unlock the HR account and reset its password:

Using SQL*Plus, connect to Oracle Database as a user with the ALTER USER system privilege.

For instructions, see "Connecting to Oracle Database from SQL*Plus".
At the SQL> prompt, unlock the HR account and reset its password:

Caution: Choose a secure password. For guidelines for securing passwords, see Oracle Database Security Guide.
```
ALTER USER HR ACCOUNT UNLOCK IDENTIFIED BY password;
```
The system responds:
```
User altered
```
The HR account is unlocked and its password is password.

Now you can connect to Oracle Database as user HR with the password password. For instructions, see either "Connecting to Oracle Database from SQL*Plus" or "Connecting to Oracle Database from SQL Developer".

Unlocking the HR Account

Related Topics