Hands-On 02 (Managing Users using OEM)

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

1. Selecting a target database

2. Creating an Oracle user

3. Granting a role to a user

4. Granting system privileges to a user

5. Locking a user

6. Removing a user

Hands-On 02 (Managing Users using OEM)

Description:

In this exercise you will learn how to create an Oracle user ID,
grant roles and system privileges to a user, lock the user, and 
remove the user using the Oracle Enterprise Management tool (OEM).

==Start.
Expand the Database item.

==
Expand the DBS4RMAN database.

==
Expand the Security item.

==
Expand the Users item.

==
Highlight the "Users" item and click on the "Create" icon.

==
On the Create window, be sure the "User" is selected and 
then click "Create."

==
Enter the user ID or the user name.

==
Select the security type.

== 
Enter password and then confirm it.

==
change the Default or Temporary tablespaces if needed.

==
On the "Role" tab, grant the "Resource" role to the user.

==
On the "System Privilege" tab, grant the "ALTER ANY TABLE" system
privilege to the user.

==
Click on the "Show SQL" icon to show the SQL statement to generate 
a user name. Browse into it.

==
Then, click the Create icon.
The user was created successfully.

==
Here is the user.
Browse through its Roles and System Privileges.

==
Lock the user.

== 
Verify that you want to lock the user.
Notice the lock icon next to user.

==
Click "Right Mouse" and remove the user.

==
Verify the remove request.
The user was gone.

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

Good Luck!