Hands-On 04 (Managing Profiles using OEM)

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

1. Selecting a target database

2. Creating a profile

3. Limiting a user resources

4. Removing a profile

Hands-On 04 (Managing Profiles using OEM)

Description:

In this exercise you will learn how to create a user profile,
limit user resources, and remove a profile using the Oracle 
Enterprise Management tool (OEM).

==Start.
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.

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

Good Luck!