4. The Roles page would display up as shown in figure 5 below. Click on the CREATE button to create a role.

Figure 5. Create Role tab

5. The Create Role window would display the window as shown in figure 6 below.

Figure 6. Create Role Window

After entering the relevant fields in the window you can check the sql query by clicking on the button "Show SQL" which will be executed by em to create the role.

Figure 7. Show Sql Window

Return back to previous window by clicking back button and click OK Button to create the role and following window will appear .

Figure 8. Role Created Window

This shows that role ‘DBA_ROLE’ has been created in the database.

First Page: Oracle 10g Free Training - Creating Roles and Granting Privileges