This image shows the Success status for the myuser_conn connection.

In the New / Select Database Connection window, this example uses the following values:

1. Connection Name: myuser_conn
2. User Name: myuser
3. Password: password
4. Hostname: localhost
5. SID: orcl
6. Role: default

Replace 'password' with the password of your user.