Step 2: Create User Accounts for This Tutorial

Matthew and Winston both are sample employees in the HR.EMPLOYEES schema, which provides columns for the manager ID and e-mail address of the employees, among other information. You must create user accounts for these two employees so that they can later test the secure application role.

To create the user accounts:  

1. In Database Control, select the Database Instance link to display the Database Home page.

   If you are not logged in to Database Control, see Accessing the Database Home Page for instructions about how to start Database Control. In the Login page, enter an administrator user name (for example, SYSTEM) and password, and then click Login.

2. Click Server to display the Server subpage.

3. Under Security, select Users.

   The Users page appears.

4. Click Create.

   The Create User page appears.

5. Enter the following information:

   • Name: mweiss (to create the user account for Matthew Weiss)

   • 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

6. Click System Privileges to display the System Privileges subpage.

7. Click Edit List.

   The Modify System Privileges page appears.

8. In the Available System Privileges lists, select the CREATE SESSION privilege, and then click Move to move it to the Selected System Privileges list.

9. Click OK.

   The Create User page appears, with CREATE SESSION listed as the system privilege for user mweiss.

10. Ensure that the Admin Option for CREATE SESSION is not selected, and then click OK.

    The Users page appears.

11. Select MWEISS from the list of users, and then from the Actions list, select Create Like. Then, click Go.

12. In the Create User page, enter the following information to create the user account for Winston, which will be almost identical to the user account for Matthew:

    • Name: wtaylor

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

13. Click OK.

    You do not need to grant wtaylor the CREATE SESSION privilege, because the Create Like action has done of this for you.

14. Exit Database Control.

Now both Matthew Weiss and Winston Taylor have user accounts that have identical privileges.