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