Step 3: Create User Accounts for This Tutorial

You are ready to create accounts for the employees who must access the OE.ORDERS table.

To create the employee user accounts:  

1. In Database Control, click Users in the Database Instance link to return to the Users page.

   The Users page appears.

2. Click Create.

   The Create User page appears.

3. Enter the following information:

   • Name: LDORAN (to create the user account Louise Doran)

   • Profile: DEFAULT

   • Authentication: Password

   • Enter Password and Confirm Password: Enter a password that meets the requirements in "Requirements for Creating Passwords".

   • Default Tablespace: USERS

   • Temporary Tablespace: TEMP

   • Status: Unlocked

4. Select the Object Privileges tab.

5. From the Select Object Type list, select Table, and then click Add.

   The Add Table Object Privileges page appears.

6. In the Select Table Objects field, enter the following text:

   OE.ORDERS
   

   Do not include spaces in this text.

7. In the Available Privileges list, select SELECT, and then click Move to move it to the Selected Privileges list. Click OK.

   The Create User page appears, with SELECT privileges for OE.ORDERS listed.

8. Click OK.

   The Users page appears, with user ldoran is listed in the UserName column.

9. Select the selection button for user LDORAN, and from the Actions list, select Create Like. Then, click Go.

   The Create User page appears.

10. Enter the following information:

    • Name: LPOPP (to create the user account for Finance Manager Luis Popp.)

    • Enter Password and Confirm Password: Enter a password that meets the requirements in "Requirements for Creating Passwords".

11. Click OK.

Both employee accounts have been created, and they have identical privileges. If you check the privileges for user LPOPP, you will see that they are identical to those of user LDORAN's. At this stage, if either of these users performs a SELECT statement on the OE.ORDERS table, he or she will be able to see all of its data.