Training Classes | Learning and Development Resources | Training Directory | New Training Seminars | New Training Providers | Site Map | Promote Training Seminars | Training Keywords | Training Seminars | Training Providers | Regions | Training Search | Advertise Training Seminars | Login
Provided by: Serebra Learning Corporation

Oracle9i Database Administration: Manage Security

Click here for more information or to take this course 		Serebra Learning Corporation
  home  : Computer  : Oracle  : Oracle9i
Get More Information
Search for Training
Find Your Genius!
What do you want to learn about?

Training Provided by Serebra Learning Corporation

This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course you will learn the concepts and methods associated with implementing security and resource consumption in an Oracle9i database.

Training Avaliability and Delivery

This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Serebra Learning Corporation for more information
Schedule:8 hours
Training Presented in:English
Related Keywords:  oracle9i database administration 

Training Program Details

Audience

The intended audience for this course include Database Administrators System Administrators Network Administrators and Technical Support Professionals. Additionally learners should have taken the first four parts of this series (64311-64314). Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110) Oracle SQL: Data Retrieval Techniques (61111) Oracle SQL: DML and DDL (61112) Oracle PL/SQL: PL/SQL Basics (61113) Oracle PL/SQL: Procedures Functions and Packages (61114) Oracle PL/SQL: Database Programming (61115).

Objective

  • Define and maintain the five components of the security domain of a user in a given environment.
  • Define and maintain a named set of resource and password limits.
  • Demonstrate the use of resource limits and how to set them.
  • Manage system and object privileges.
  • Control the administration of privileges in a database.
  • Demonstrate the use of concepts and skills to keep track of the various events occurring in an Oracle9i database.

Topics Include

Unit 1: Managing Users

  • Match the components of a security domain with their functions.
  • Identify the steps for creating a user.
  • Create a user by using Oracle Security Manager.
  • Identify the security feature available to an operating system user when a value for the OS_AUTHENT_PREFIX parameter is given.
  • Identify the guidelines for creating a user.
  • Maintain passwords by using Oracle Security Manager.
  • Maintain account locks by using Oracle Security Manager.
  • Change the user quota on a tablespace by using Oracle Security Manager.
  • Drop a user by using Oracle Security Manager.
  • Display the tablespace quotas for users from the data dictionary using Oracle SQL*Plus Worksheet.
  • Display the account status of users from the data dictionary by using Oracle SQL*Plus Worksheet.

Unit 2: Managing Resources and Password Security

  • Identify the uses of profiles.
  • Create a user profile.
  • Assign a profile to an existing user by using Oracle Security Manager.
  • Alter a user profile to modify resource limits using Oracle Security Manager.
  • Drop a user profile using Oracle Security Manager.
  • Display the resource limits for a user by using Oracle SQL*Plus Worksheet.
  • Match the features of password management offered by profiles with their descriptions.
  • Create a new profile with password settings by using Oracle Security Manager.
  • Identify the restrictions that are to be considered while adding a user-defined password function
  • Display the password and locking information from the data dictionary using Oracle SQL*Plus Worksheet.

Unit 3: User Resource Consumption

  • Identify the implications of exceeding the profile limits.
  • Enable the enforcement of resource limits by using Oracle Instance Manager.
  • Display the resource limits for users from the data dictionary by using Oracle SQL*Plus Worksheet.
  • Identify the resources whose limits are enforced at the session level.
  • Match the main components of the Resource Manager to their description.
  • Identify the process necessary to manage Resource Manager components.
  • Identify Resource plan directives with their uses.

Unit 4: Managing Privileges

  • Identify the two types of privileges.
  • Match the given system privileges with their features.
  • Grant system privileges by using Oracle Security Manager.
  • Distinguish between the SYSDBA and SYSOPER privileges.
  • Sequence the steps to set up password file authentication.
  • Control the dictionary protection mechanism of Oracle9i.
  • Revoke system privileges by using Oracle Security Manager.
  • Identify the implication of revoking a system privilege that is granted using the WITH ADMIN OPTION clause.
  • Grant object privileges by using Oracle Security Manager.
  • Revoke object privileges by using Oracle Security Manager.
  • Identify the implication of revoking an object privilege that is granted using the WITH GRANT OPTION.
  • Display the system privileges that are granted at the database level by using Oracle SQL*Plus Worksheet.
  • Display the object privileges granted to users by using Oracle SQL*Plus Worksheet.
  • Identify features of Oracle Enterprise Security.
  • Identify the features of the single sign-on functionality.

Unit 5: Managing Roles

  • Identify the characteristics of roles.
  • Identify the benefits of roles.
  • Create a role by using Oracle Security Manager.
  • Match the predefined roles with their descriptions.
  • Modify a role by using Oracle Security Manager.
  • Assign a role to a user by using Oracle Security Manager.
  • Specify a role as a non-default role for a user by using Oracle Security Manager.
  • Set a role for a session by using Oracle SQL*Plus Worksheet.
  • Revoke a role from a user by using Oracle Security Manager.
  • Drop a role from the database by using Oracle Security Manager.
  • Identify the guidelines for creating roles.
  • Display the role information from the data dictionary by using Oracle SQL*Plus Worksheet.
  • Display the information on active roles and privileges by using Oracle SQL*Plus Worksheet.

Unit 6: Auditing

  • Match the categories of auditing with their functions.
  • Sequence the phases involved in database auditing.
  • Match the values of the AUDIT_TRAIL parameter with their descriptions.
  • Specify the command to audit statements by using an Oracle SQL*Plus Worksheet.
  • Specify the command to audit a privilege by using an Oracle SQL*Plus Worksheet.
  • Specify the command to audit a schema object by using Oracle SQL*Plus Worksheet.
  • Specify the command to disable an audit option by using Oracle SQL Worksheet.
  • Match the audit option views with the information they display.
  • Display the audit results by using Oracle SQL*Plus Worksheet.
  • Identify the auditing guidelines.
  • Move the AUD$ table to a non-SYSTEM tablespace by using Oracle SQL*Plus Worksheet.

Duration

6

Minimum Requirements

The CDROM version of this course requires:

  • At least a 486DX 33Mhz CPU.
  • Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
  • At least 8MB RAM.
  • At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
  • At least a double speed CDROM drive.
  • An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).
The network version of this course requires:
  • At least a 486DX 33Mhz CPU.
  • Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
  • At least 8MB RAM and 22MB available hard disk space or file server space.
  • At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC    V3W 1K5 Canada

About Serebra Learning Corporation - Training Provider

Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
More Oracle9i Database Administration Training from Serebra Learning Corporation
Click here for more information or to take this course
Training Directory | New Training Seminars | New Training Providers | Search | Site Map | Promote Training | Login | Links
Training-Classes.com by Skillbox® 07/18/08
Copyright 1998-2008 skillbox, inc. All rights reserved		 Connecting people who want to learn with people who love to teach
 Are you an Oracle9i database administration training provider?
You could be on this page today - for FREE!
This page was last updated on sb5 - 07/18/08 at 04:28:09 - 05:05:23