"I have read
your book and much like it." - Moses Hadas (1900-1966) |
Read
first then play the video:
OEM-VIDEO -Managing
Roles
Managing Roles using OEM
Introduction
As a DBA, you are
responsible for managing Oracle roles. The following is a summary of
your task:
Covers:
Selecting a target database
Creating a role
Granting a role to a role
Granting a system privilege
to a role
Removing a role
Hands-on
Expand the Database item.
Expand the DBS4RMAN database.
Expand the Security item.
Expand the Roles item.
Highlight the "Roles" item, right click and select
"Create."
On the Create Role window, enter a new Role name for dba.
Associate a password to the new role. And then enter password and then
confirm it.
On the "Role" tab, grant the "CONNECT" and
"Resource" roles to the user with an admin option.
On the "System Privilege" tab, grant the "ALTER ANY
INDEX" and "CREATE ANY INDEX" system privilege to the
user.
Click on the "Show SQL" icon to show the SQL statement to
generate a role.
Then, click the Create icon to create a role. The user was created
successfully.
Here is the Role. Browse its Roles and System Privileges.
Right click and remove it.
Verify the remove request. The role was removed.
Suppress the items on the OEM navigation window.
|