Username/ Password for Oracle

To Connect to Oracle, provide :

1. username

2. password

3. host string ( optional )

By Default oracle creates the following list of users:

SYSTEM            (identified  by  MANAGER)                                     DBA

SYS                       (identified  by  CHANGE_ON_INSTALL)        DBA

SCOTT                (identified  by  TIGER)                                               Developer

and Many More. (~ 38 users).  Click here if you want to create one.

You can connect in any of the following ways:

1.       Username/password

2.      Username/password@hostString

3.       Username

Password

Host name ( provide them separately when asked by oracle )

Q) Where can I find all the users in oracle ?

=>           SELECT * FROM   ALL_USERS;