Oracle 10g Free Training - Managing Roles and Privileges

The Highlighted message above shows that Execute Privilege has been granted to DBA_ROLE.

Similarly you can click on Consumer Groups link in figure 14.9 to associate any role to the consumer group.

You can use Oracle Enterprise Manager to manage groups of users, or sessions, that are grouped together based on their processing needs. Resource Consumer groups can be managed using Database Resource Manager. Before you enable the Database Resource Manager, you must assign resource consumer groups to users/roles.

Following window will appear in front of you when you click on Consumer group link.

Figure 15Manage Role Consumer Group Window

Click on Modify button

Figure 15.1Manage Role Consumer Group Window

Move the consumer groups to which you want to associate the role from available consumer groups to selected consumer groups.

Figure 15.2Manage Role Consumer Group Select Window

Click on OK Button after selecting Consumer group.

Figure 15.3Manage Role Consumer Group Selected Window

Click on Apply button to associate DBA_ROLE to the consumer group.

You can also click Show Sql button to actually see the sql query which EM will run to associate the user to the consumer group.

Figure 15.4Manage Role Consumer Group SQL Window

Figure 15.5Manage Role Consumer Group Window

The Highlighted message above shows that DBA_ROLE has been associated with AUTO_TASK_CONSUMER_GROUP.

Frequently Asked Questions

Why do we create roles?
How do I grant a privilege to role?
Can I grant a role to a role?
What is the significance of attaching a password to a role?
What is the significance of consumer group for role?
When will you get an error “Failed to commit: ORA-01934: circular role grant detected”?