Step 1: Create a Security Administrator Account

For greater security, you should apply separation of duty concepts when you assign responsibilities to the system administrators on your staff. For the tutorials used in this guide, you will create and use a security administrator account called sec_admin.

To create the sec_admin security administrator account:  

1. Start Database Control.

   See Accessing the Database Home Page for instructions about how to start Database Control.

2. Enter an administrator user name (for example, SYSTEM) and password, and then click Login.

   The Database Home page appears.

3. Click Server to display the Server subpage.

4. Under Security, select Users.

   The Users page appears.

5. Click Create.

   The Create User page appears.

6. Enter the following information:

   • Name: sec_admin

   • Profile: Default

   • Authentication: Password

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

   • Default Tablespace: SYSTEM

   • Temporary Tablespace: TEMP

   • Status: UNLOCKED

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

8. Click Edit List.

   The Modify System Privileges page appears.

9. In the Available System Privileges list, select the following privileges and then click Move to move each one to the Selected System Privileges list. (Hold down the Control key to select multiple privileges.)

   • CREATE PROCEDURE

   • CREATE ROLE

   • CREATE SESSION

   • SELECT ANY DICTIONARY

10. Click OK.

11. Under Admin Option, do not select the boxes.

12. Click OK.