everythingOracle.bizhat.com

 

'Everything you wanted
to know about Oracle'

Training References Syntax Tell A Friend Contact Us

 

 

OEM

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17
<< Previous

Chapter # 04

Next >>


 

Managing Profiles using OEM

Introduction

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

Covers:

Selecting a target database

Creating a profile

Limiting a user resources

Removing a profile

 

Hands-on

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.
 

 

     Reviews and Templates for FrontPage
     

Copyright � everythingOracle.bizhat.com 2006 All Rights Reserved.