Example: Creating a Role

Suppose you want to create a role called APPDEV for application developers. Because application developers must be able to create, modify, and delete the schema objects that their applications use, you want the APPDEV role to include the system privileges shown in the following table.

To create the APPDEV role: 

1. Go to the Roles page, as described in "Viewing Roles".

2. Click Create.

   The Create Role page appears.

3. In the Name field, enter APPDEV.

4. Click System Privileges to go to the System Privileges subpage.

   The table of system privileges for this role contains no rows yet.

5. Click Edit List.

   The Modify System Privileges page appears.

6. In the Available System Privileges list, double-click privileges to add them to the Selected System Privileges list.

   The privileges to add are listed in Table: System Privileges Granted to the APPDEV Role.

   Note: Double-clicking a privilege is a shortcut. You can also select a privilege and then click the Move button. To select multiple privileges, hold down the Shift key while selecting a range of privileges, or press the Ctrl key and select individual privileges, then click Move after you have selected the privileges.

7. Click OK.

   The System Privileges subpage returns, showing the system privileges that you selected. At this point, you could click Roles to assign other roles to the APPDEV role, or click Object Privileges to assign object privileges to the APPDEV role.

8. Click OK to return to the Roles page.

   The APPDEV role now appears in the table of database roles.