Oracle9i Database Fundamentals 1Z1-031: Managing Privileges and Roles

Products

Resources

Specials

Summary:

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

Objectives:

After completing this training 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 training course concepts in an interactive questioning environment
A glossary
A Skill Assessment

Applicability:

This training 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 systemstraining course s 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