|
Provided by: Serebra Learning Corporation Oracle 8i DBA - Managing Oracle Database SecurityOracle8i |
 |
This course is aimed to familiarize the learner with the basic concepts of Oracle 8i administration of security user roles and resources. The course also provides a list of data dictionary views that help in performing administrative tasks. The course initiates the learner into hands-on learning by helping the learner to type-in the commands to perform administrative tasks. Related Exam: Oracle Exam #1Z0-023: Oracle 8i: Architecture and Administration.
|
|
||||||||||
Audience
This course is designed for database administrators application developers business and systems analysts MIS managers and technical support professionals and ordinary Oracle users. It will prepare students for the Oracle8i: Architecture and Administration Exam.
Prerequisites
The audience should be familiar with RDBMS concepts Graphical User Interfaces (GUIs) SQL and basics of PL/SQL.
Objective
Upon completion of this course the student will be able to:
Topics Include
Unit 1: Managing Password Security
- A Profile Overview
- Implementing Password Security
- Creating Profiles and Setting Passwords
Unit 2: Managing Resources
- Using Profiles to Control Resource Use
- Managing Profiles
- Obtaining Profile Information
Unit 3: Managing Users
- Creating Users
- Altering Users
- User Information
Unit 4: Managing Privileges
- System Privileges
- Controlling Authentication
- Revoking System Privileges
- Object Privileges
- Revoking Object Privileges
Unit 5: Auditing
- An Auditing Overview
- Enabling Auditing
Unit 6: Managing Roles
- Introduction to Roles
- Creating Roles
- Controlling Roles Availability
- Role Guidelines
Duration
5 Hours
Minimum Requirements
IBM-compatible PC with 166 MHz or higher processor 32 MB RAM (64 MB RAM recommended); 800x600 SVGA color monitor with 16-bit high color display; Internet Explorer 4 or Netscape Navigator 4 or later with Shockwave 7.0.1; Windows 95 Windows 98 Windows NT; 3.5 diskette (for tracking); 28.8 kbps connection or higher for on-line use.
Media
CDROM
Web Based Training
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
