|
"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
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.
|