OUR VISION

To be the premier Information and Communications Technology (ICT) training and consulting services provider in the caribbean.

OUR MISSION

To improve the quality of knowledge and skills base of ICT professionals within the caribbean through the provision of competitive world-class ICT training and consulting services on current and emerging platforms.

Oracle Database 10g: Security Release 2

Duration: 4 Days

In this course, the students learn how they can use Oracle database features to meet the security and compliance requirements of their organization. The current regulatory environment of the Sarbanes-Oxley Act, HIPPA, the UK Data Protection Act, and others requires better security at the database level. Students learn how to secure their database and how to use the database features that enhance security. The course provides suggested architectures for common problems.

This course explains the security features of the database like auditing, column and file encryption, virtual private database, label security and enterprise user security. Some of the Oracle Network security topics like securing the listener and restricting connections by IP address are also covered.

Target Audience
• Database Administrators
• Support Engineer
• Technical Consultant
• System Analysts

Prerequisites
Oracle Database 10g: Administration Workshop I
Oracle Database 10g: Administration Workshop I Release 2

Course Objectives

  • Use basic database security features
  • Choose a user authentication model
  • Secure the database and its listener
  • Use the Enterprise Security Manager tool
  • Manage users using proxy authentication
  • Implement Enterprise User Security
  • Describe the benefits and requirements associated with the Advanced Security Option
  • Manage secure application roles
  • Implement fine-grain access control
  • Manage the Virtual Private Database (VPD)
  • Implement fine-grain auditing
  • Use Transparent Data Encryption
  • Use file encryption
  • Encrypting and Decrypt table columns
  • Setup a simple Label Security policy

Course Outline

  • Security Requirements
  • Security Solutions
  • Internal Database Security
  • Database Auditing
  • Fine-Grained Auditing
  • Basic User Authentication
  • Strong Authentication
  • Enterprise User Security
  • Proxy Authentication
  • Authorization Methods
  • Using Application Context
  • Fine-Grained Access Control
  • Installing Label Security
  • Implementing Label Security
  • Encrypting Data: Concepts
  • Use Application Based Encryption
  • Use Transparent Data Encryption
  • Use File Encryption
  • Oracle Net Services Security Checklist
  • Securing the Listener
  • Using Connection Manager as a Firewall
  • Securing SQL*Plus and iSQL*Plus