The Highlighted message above shows that Create Any Procedure System Privilege has been granted to DBA_ROLE.

Similarly you can click on object privileges link in figure 12.4 to grant any object privileges to DBA_ROLE.

Following window will appear in front of you when you click on object privileges link.

Figure 14Manage Role Object Privileges Window

Please select the object type (Highlighted in Figure14 above) for the object on which you want to grant privilege to DBA_ROLE. Click on Add Button beside the object Type. Following window will appear in front of you.

Figure 14.2Manage Role Object Privileges select Window

Click on icon beside the select function objects text area to choose the object on which you want to grant the privileges.

Figure 14.3Manage Role Object Privileges select Object Window

Select the appropriate Schema and search for your function name(test_function in this example). Press GO.

Figure 14.4Manage Role Object Privileges Object selected Window

If the object exists in the database it will displayed in the window (as in Figure 14.4). Check the checkbox beside the object name and click on select button.

Object name will appear in figure 14.2 and will be displayed as below. You can also directly enter the schema.object_name.

Figure 14.5Manage Role Object Privileges Object selected Window

Choose the appropriate privilege to be granted and move it from available privilege area to selected privilege area.

Figure 14.6Manage Role Object Privileges Object selected Window

In this example, we are giving execute privilege on test_function to DBA_ROLE. Click on ok button and following window will appear in front of you.

Figure 14.7Manage Role Object Privileges Window

Click on Apply button to grant the selected privileges to DBA_ROLE. If you check the Admin Option Checkbox, then the privilege would be granted with ADMIN OPTION so users with DBA_ROLE can grant this privilege to other users.

You can also click Show Sql button to actually see the sql query which EM will run to grant these privileges.

Figure 14.8Manage Role Object Privileges SQL Window

Click Apply to commit the changes.

Figure 14.9Manage Role Object Privileges SQL Window

Next Page: Oracle 10g Free Training - Managing Roles and Privileges - Page 3