Connecting to Oracle Database as User HR from SQL Developer

This section shows how to connect to Oracle Database as the user HR from SQL Developer, if the HR account is unlocked.

If the HR account is locked, see Unlocking the HR Account.

To connect to Oracle Database as user HR from SQL Developer:

• Follow the directions in "Connecting to Oracle Database from SQL Developer", entering the following values at steps 7 and 9.

  At step 7:

  • For Connection Name, enter hr_conn.

    (You can enter a different name, but the tutorials in this document assume that you named the connection hr_conn.)

  • For Username, enter HR.

  • For Password, enter the password for the HR account.

  At step 9:

  • For Role, accept the default.

  • For Connection Type, accept the default (Basic).

  • For Hostname, enter localhost.

  • For Port, enter 1521.

  • For SID, enter orcl.

  At step 11, the name of the connection, hr_conn, appears in the Connections pane of the Oracle SQL Developer window.

You are now connected to Oracle Database as the user HR.