Database 10g R2: Security

Course Overview

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.

• Explain the fundamental security requirements
• Manage Wallet manager
• Protect sensitive data
• Install Label Security
• Describe group Policies

Audience

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

Prerequisites

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

Skills Gained

• 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 encryptionEncrypting and Decrypt table columns
• Setup a simple Label Security policy