Oracle8 Database Administration - Manage Security

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.

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 8 hours Training Presented in: English

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 61110 61111 61112 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.

Objective

• 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.

Topics Include

Unit 1: Managing Users

• 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

• 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

• 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

• 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

• 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.

Duration

8

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).

• 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

CDROM

• Oracle8 Database Administration - Create Database
• Oracle8 Database Administration - Manage an Instance
• Oracle8 Database Administration - Manage Data Storage
• Oracle8 Database Administration - Manage Data Storage Structures