|
Provided by: 123-CBT Computer Based Training Oracle8i Database Admin Manage Security |
 |
Course Overview
This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and tasks associated with managing security.
Learn To:
- Define and maintain the security domains for users in a given environment.
- Define and maintain a named set of resources and password limits.
- Understand the concept of resource limits and how to set them.
- Manage system and object privileges.
- Control the administration of privileges in a database.
- Use database auditing.
Content Emphasis
Skills-Based
Audience
Database Administrators, System Administrators, Network Administrators, Technical Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312). This course will help candidates prepare for the Oracle8i Certified DBA Architecture and Administration exam 1Z0-023.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Managing Users
Duration: 1 Hour(s)- 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 by 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
Duration: 1 Hour(s)- Identify the uses of profiles.
- Create a user profile by using Oracle Security Manager.
- Assign a user profile to an existing user by using Oracle Security Manager.
- Alter a user profile by using Oracle Security Manager.
- Drop a user profile by 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 password and locking information from the data dictionary by using Oracle SQL*Plus Worksheet.
Unit 3: User Resource Consumption
Duration: 1 Hour(s)- 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.
Unit 4: Managing Privileges
Duration: 1 Hour(s)- Identify the two types of privileges.
- Match the given system priv
This is primarily online training 
This is an online eLearning or CBT training program 
This program may be available on CD 
Contact 123-CBT Computer Based Training for more information Training Presented in: English
