iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

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

DBAs - OEM

 

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

 

Introduction

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

 

Covers:

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

 

Hands-on

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.