iSelfSchooling.com - Since 1999  References  |  Job Openings
    Home  | Search more  | Oracle Syntax  | Computer Institute   | (Login or Register to access to VIDEOS)
 

Copyright & User Agreement

   Suggestions Email2aFriendHomepage us! |  Bookmark

Services

  Vision/Mission

  Services

  Biography

  Contact Us

 FREE Training

  Start...

  SQL

  PL/SQL

  Forms 

  Reports

  DBA Fundamentals

  Performance

  Prepare for OCP

  ShareUrNotes

...

  Acknowledgement

  Who is who

  University Directory

  Links...

 

 

 

Topics: Managing Roles using OEM

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

More Resources by Google:

Manuscript

 

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!

 

 
 
Google
 
Web web site