Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...


. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |


Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.



Lesson 01 | Lesson 02 | Lesson 03 | Lesson 04 | Lesson 05 | Lesson 06 | Lesson 07 | Lesson 08 | Lesson 09 | Lesson 10 | Lesson 11 | Lesson 12 | Lesson 13 | Lesson 14 | Lesson 15 | Lesson 16 |


Lesson 03

"I have read your book and much like it." - Moses Hadas (1900-1966)


Read first then play the video:

   OEM-VIDEO -Managing Roles


Managing Roles using OEM



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



Selecting a target database

Creating a role

Granting a role to a role

Granting a system privilege to a role

Removing a role



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.