|
Provided by: 123-CBT Computer Based Training Oracle8 Database Administration - Manage Security |
 |
Training
Provided by 123-CBT Computer Based Training
Course Overview
This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle8. 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.
- Manage system and object privileges.
- Control the administration of privileges in a database.
- Keep track of the events occurring in a database.
Content Emphasis
Skills-Based
Audience
Database administrators, system administrators, network administrators, and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112, 60113, and 60114. In addition, participants should have taken the first four parts of the Oracle8 Database Administration series, courses 61311, 61312, 61313, and 61314.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Managing Users
Duration: 1.5 - 2 Hour(s)- Match the components of a security domain with their functions.
- Sequence the steps for creating a user.
- Create a user by using Oracle Security Manager.
- Given a value for the OS_AUTHENT_PREFIX parameter, identify the security feature available to the operating system user with a given user name.
- 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 Worksheet.
- Display the account status of users from the data dictionary by using Oracle SQL Worksheet.
Unit 2: Managing Profiles
Duration: 1.5 - 2 Hour(s)- Identify the uses of profiles.
- Identify the implications of exceeding each type of profile limit.
- Identify the level at which the limit of a given resource is enforced.
- Create a profile by using Oracle Security Manager.
- Assign a profile to a user by using Oracle Security Manager.
- Enable the enforcement of resource limits when the database cannot be shut down.
- Alter a profile by using Oracle Security Manager.
- Drop a profile by using Oracle Security Manager.
- Display the resource limits for users from the data dictionary by using Oracle SQL Worksheet.
- Match the features of password management available with profiles with their description.
- Create a 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 Worksheet.
Unit 3: Managing Privileges
Duration: 1 - 2 Hour(s)- Distinguish between system and object privileges.
- Match the given system privileges with their features.
- Grant system privileges by using Oracle Security Manager.
- Distinguish between SYSDBA and SYSOPER privileges.
- Sequence the steps to set up password file authentication.
- Control the dictionary protection mechanism of Oracle8 by using Server Manager.
- Revoke system privileges by using Oracle Security Manager.
- Given a scenario in which a system privilege granted with ADMIN OPTION is revoked, identify the pictoral representation of the result.
- Grant object privileges by using Oracle Security Manager.
- Revoke object privileges by using Oracle Security Manager.
- Given a scenario in which an object privilege granted with GRANT OPTION is revoked, identify the pictorial representation of the result.
- Display the system privileges granted at the database level by using Oracle SQL Worksheet.
- Display the object privileges granted to users by using Oracle SQL Worksheet.
Unit 4: Managing Roles
Duration: 1 Hour(s)- Identify the characteristics of a role.
- 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 the Oracle Security Manager.
- Limit the default role of a user by using the Oracle Security Manager.
- Set role for a session by using the Oracle SQL Worksheet.
- Revoke a role from a user by using Oracle Security Manager.
- Drop a role from the database by using the Oracle Security Manager.
- Identify the guidelines for administering roles.
- Display the database role information by using Oracle SQL Worksheet.
- Display the information on active roles and privileges by using Oracle SQL Worksheet.
Unit 5: Auditing
Duration: 1 Hour(s)- Match the categories of auditing with their functions.
- Sequence the steps involved in database auditing.
- Match the values of the AUDIT_TRAIL parameter with their descriptions.
- Specify the commands to audit statements by using an Oracle SQL Worksheet.
- Specify the command to audit a privilege by using an Oracle SQL Worksheet.
- Specify the command to audit a schema object by using Oracle SQL 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 Worksheet.
- Identify the auditing guidelines.
- Move the audit trail to a non-system tablespace by using Oracle SQL Worksheet.
|
|
||||||||||
Oracle8 Database Administration - Manage Security
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
