Creating Database Users

You must create a database user for each database.

To create a user for the musicdb database instance, complete the following steps.

1. Log in as the Oracle user.

2. In a terminal window, type the following command:

   setenv ORACLE_SID musicdb

3. In a terminal window, type the following command:

   sqlplus / as sysdba

   After some messages are displayed, the SQL prompt is displayed.

4. Type the following command to create musicdbuser:

   SQL> create user musicdbuser identified by musicdbpass;

5. Type the following command to grant privileges to musicdbuser:

   SQL> grant connect, resource to musicdbuser;

6. Type the following command to log out of sqlplus:

   SQL> quit

To create a user for the gwdb database instance, complete the following steps.

1. In a terminal window, type the following command:

   setenv ORACLE_SID gwdb

2. In a terminal window, type the following command:

   sqlplus / as sysdba

   After some messages are displayed, the SQL prompt is displayed.

3. Type the following command to create gwdbuser:

   SQL> create user gwdbuser identified by gwdbpass;

4. Type the following command to grant privileges to settingsdbuser:

   SQL> grant connect, resource to gwdbuser;

5. Type the following command to log out of sqlplus:

   SQL> quit