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 the Users page, click Create.

   The Create User page appears.

2. 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

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

4. Click Edit List.

   The Modify System Privileges page appears.

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

6. Click OK.

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

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

   The Users page appears.

8. Select the option for user MWEISS from the list of users, and then from the Actions list, select Create Like. Then, click Go.

9. 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".

   You do not need to specify the default and temporary tablespaces, or the CREATE SESSION system privilege, for user wtaylor because thes are already specified.

10. Click OK.

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

11. Log out of Database Control.

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