Privileges and Roles in Oracle9i

Overview/Description
To describe how to manage privileges and roles in an Oracle9i database

Target Audience


Anyone wanting to learn about Oracle9i database administration

Prerequisites


An understanding of database concepts and technologies

Expected Duration


140 Minutes

Objectives :

Privileges and Roles in Oracle9i

  • describe the system and object privileges in an Oracle9i database.
  • describe how to manage system and object privileges in an Oracle9i database.
  • use the Oracle Enterprise Manager to grant a system privilege to a user in an Oracle9i database.
  • describe the Oracle9i database roles.
  • describe how to create and enable roles in an Oracle9i database.
  • describe how to manage roles in an Oracle9i database.
  • use the Enterprise Manager to create a role and assign privileges to it in an Oracle9i database.


    • Course Number: 61608_eng