You can modify a role using Oracle Enterprise Manager Database Express (EM Express). For example, suppose your applications make use of Oracle Streams Advanced Queuing, and you determine that developers must be granted the roles AQ_ADMINISTRATOR_ROLE
and AQ_USER_ROLE
to develop and test their applications. You can edit the APPDEV
role to grant it these two Advanced Queuing roles.
To modify the APPDEV role:
In EM Express, go to the Roles page, as described in "Viewing Roles".
Select the APPDEV
role, and from the Actions menu, choose Alter Privileges.
The Alter Privileges page appears.
Move the AQ_ADMINISTRATOR_ROLE
and AQ_USER_ROLE
roles from the available system privileges and roles table on the left to the selected system privileges and roles table on the right to grant these two roles to the APPDEV
role.
Click OK.
A confirmation statement appears.