iSelfSchooling.com - Copyright © 1999-2009 iSelfSchooling.com ||  References  |  Job Openings  || Login (Staff | Members)
    Home  | Search more...  |  FREE Online VIDEO Oracle Training 

    Oracle Syntax  | Suggestions  | Private Tutoring  | Group Collaboration

  Copyright & User Agreement

Email2aFriend  | Homepage us! |  Bookmark

Services

 Vision/Mission

 Services

 Biography

 Contact Us

 FREE Training

 SQL

 PL/SQL

 Forms 

 Reports

 Other TOOLS

 Fundamentals

 Performance

 OEM

 Application Server

 Grid Control

 Articles

 Prepare for OCP

More Training

 Q & Answers

 SQL-PL/SQL

 DBA

 Developer

 Important Notes

 Case Studies

 9i New Features

 10g New Features

 10g Qs/As

 Grid Control

 OracleAS # I

 OracleAS # II

  LDAP and OID

  HTTP Server

 Instructor-Led

  Virtual Hosts

More to know...

Acknowledgement**

 Who is who

 University Directory

 Links...

 

 

Topics: Managing Users using OEM

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

More Resources by Google:

Manuscript

 

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!

 

 
 
Google
 
Web web site