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 04

"Every day I get up and look through the Forbes list of the richest people in America. If I'm not there, I go to work." - Robert Orben


Read first then play the video:

   OEM-VIDEO -Managing Profiles


Managing Profiles using OEM



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


Selecting a target database

Creating a profile

Limiting a user resources

Removing a profile



Expand the Database item.

Expand the DBS4RMAN database.

Expand the Security item.

Expand the Profiles item.

Highlight the "Profile" item, right click on it and select "Create."

On the Create Profile window, enter a new profile name, such as NEWDEVELOPER.

Change the CPU per Session unit to 10 seconds.

Change the Idle time unit to one hour.

Change the Concurrent Sessions number to 1.

Click on the "Show SQL" icon to show the SQL statement generating the NEWDEVELOPER role.

Then, hide the SQL statement and click "Create." The profile was created successfully.

Click on the NEWDEVELOPER profile. Browse its profile.

Then, right click and remove it.
Verify the remove request. The newdeveloper profile was now completely removed.

Suppress the items in the navigation window.