Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...


. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |


Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.



Lesson 01 | Lesson 02 | Lesson 03 | Lesson 04 | Lesson 05 | Lesson 06 | Lesson 07 | Lesson 08 | Lesson 09 | Lesson 10 | Lesson 11 | Lesson 12 | Lesson 13 | Lesson 14 | Lesson 15 | Lesson 16 |


Lesson 02

"Sometimes a scream is better than a thesis." - Ralph Waldo Emerson (1803-1882)


Read first then play the video:

   OEM-VIDEO -Managing Users

Managing Users using OEM



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



Selecting a target database

Creating an Oracle user

Granting a role to a user

Granting system privileges to a user

Locking a user

Removing a user



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.