Users and Profiles in Oracle9i

Overview/Description
To describe how to use manage users, passwords, and resources in an Oracle9i database

Target Audience


Anyone wanting to learn about Oracle9i database administration

Prerequisites


An understanding of database concepts and technologies

Expected Duration


180 Minutes

Objectives :

Users and Profiles in Oracle9i

  • describe Oracle9i database users, how to authenticate them, and their relationship to schemas.
  • explain how to create and manage users in an Oracle9i database.
  • use the Oracle Enterprise Manager to create a user in an Oracle9i database.
  • describe profiles and explain how to use profiles to manage passwords in an Oracle9i database.
  • describe how to create and manage password profiles in an Oracle9i database.
  • use the Oracle Enterprise Manager to create a password profile and assign it to a number of users in an Oracle9i database.
  • describe how to use password profiles to manage Oracle9i database resources.
  • describe the Oracle9i Database Resource Manager and explain how to use it to manage database resources.
  • explain how to create a resource plan in an Oracle9i database.


    • Course Number: 61604_eng