Overview of HR account

HR Account

What is the content in HR Account

HR account contains the database of employees, departments, locations, regions, countries, job history, jobs distributed over seven tables named as mentioned above.

These tables contain data about their respective field all related to employee’s information.

How to unlock HR Account

We have to unlock the HR Account and reset its password.

We have to use ALTER USER SYSTEM PRIVILEGE once you are logged in as sys user.

Using the following command, HR Account is unlocked and a new password is set at the same time:-

Alter user hr account unlock identified by password;

The system will respond to the command by replying

User altered.

So now, HR account is unlocked with the password password that you entered. Then get conn. to hr account giving the command:-

Conn hr

Password:                                            (your entered password will be invisible while typing)

HR TABLES