Oracle9i Database Fundamentals 1Z1-031: Managing Privileges and Roles
Product Code: OR3109 Time: 3 Hour(s) CEUs: .30

Summary:

This course introduces users to system and object priviledges and user roles.

Objectives:

After completing this course, students will be able to:
  • Identify system and object privileges
  • Grant and revoke privileges
  • Identify auditing capabilities
  • Create and modify roles
  • Control availability of roles
  • Remove roles
  • Use predefined roles
  • Display role information from the data dictionary

Outline:

  • System Privileges
  • Special and Object Privileges
  • Granting and Revoking Privileges
  • Granting Administrative Abilities
  • Identifying Audit Capablitities
  • Using the Audit Command
  • Managing Auditing
  • Creating and Modifying Roles
  • Controlling Availability of Roles
  • Using Predefined Roles
  • Displaying Role Information

Features:

  • Exercises that allow users to practice the application
  • A file containing the text of the exercises
  • Activities that allow users to apply course concepts in an interactive questioning environment
  • A glossary
  • A Skill Assessment

Applicability:

This course is for anyone preparing for the Oracle 1Z1-031: Oracle9i DBA Fundamentals I exam, or anyone who wants an introduction to Oracle database fundamentals.

Prerequisites:

Experience working with relational database systemsCourses on SQL or equivalent experienceGeneral knowledge of networkingOracle9i Database Fundamentals 1Z1-031: Oracle Architecture and ToolsOracle9i Database Fundamentals 1Z1-031:Managing Instances and Creating DatabasesOracle9i Database Fundamentals 1Z1-031: Managing the Database StructureOracle9i Database Fundamentals 1Z1-031: Managing Tablespaces and DatafilesOracle9i Database Fundamentals 1Z1-031: Managing Storage Structures and Undo DataOracle9i Database Fundamentals 1Z1-031: Managing TablesOracle9i Database Fundamentals 1Z1-031: Managing Indexes and Data IntegrityOracle9i Database Fundamentals 1Z1-031: Managing Users and Profiles

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

  • Oracle® and Oracle9i™ are trademarks of Oracle Corporation.

Terms of Use:

None

Copyright © 2004 eLearningDepot.com. All rights reserved.