Oracle Database 10g: Security

Seminarziel

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.

Learn To: o Explain the fundamental security requirements o Manage Wallet manager o Protect sensitive data o Install Label Security o Describe group Policies

Zielgruppe

Datenbankadministratoren, Systemanalytiker, Technischer Berater

Seminarinhalte

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

Voraussetzungen

- "Oracle Database 10g: Administration Workshop I''"- "Oracle Database 10g: Administration Workshop I Release 2"