Hands-On 03 (Managing Roles using OEM)

As a DBA, you are responsible for managing Oracle roles. The following is a summary of your task:

1. Selecting a target database

2. Creating a role

3. Granting a role to a role

4. Granting a system privilege to a role

5. Removing a role

Hands-On 03 (Managing Roles using OEM)

Description:

In this exercise you will learn how to create a role,
grant a role and system privileges to a role, and remove a role, 
using the Oracle Enterprise Management tool (OEM).

==Start.
Expand the Database item.

==
Expand the DBS4RMAN database.

==
Expand the Security item.

==
Expand the Roles item.

==
Highlight the "Roles" item, right click and select "Create."

==
On the Create Role window, enter a new Role name for dba.

==
Associate a password to the new role. And then enter password and
then confirm it.

==
On the "Role" tab, grant the "CONNECT" and "Resource" roles to the user
with an admin option.

==
On the "System Privilege" tab, grant the "ALTER ANY INDEX" 
and "CREATE ANY INDEX" system privilege to the user.

==
Click on the "Show SQL" icon to show the SQL statement to generate 
a role.

==
Then, click the Create icon to create a role.
The user was created successfully.

==
Here is the Role.
Browse its Roles and System Privileges.

==
Right click and remove it.

==
Verify the remove request.
The role was removed.

==
Suppress the items on the OEM navigation window.

==
For more information about the subject, you are encouraged
to read from a wide selection of available books.

Good Luck!