Oracle8i Database Administration: Manage Security

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.

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

Objective

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

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

• 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

• 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

• 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 Oracle8i.
• Revoke system privileges by using Oracle Security Manager.
• Identify the implication of revoking a system privilege that is granted with 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.

Unit 5: 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 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 information on active roles using 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 commands to audit statements by using Oracle SQL*Plus Worksheet.
• Specify the command to audit a privilege by using 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 using Oracle SQL*Plus Worksheet.
• Match the audit option views with the information they display.
• Identify the auditing guidelines.
• Move the AUD$ table to a non-system tablespace by using Oracle SQL*Plus 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

• Oracle8i Database Administration: Create a Database
• Oracle8i Database Administration: Manage an Instance
• Oracle8i Database Administration: Manage Data Storage
• Oracle8i Database Administration: Manage Storage Structures