Oracle Database 11g: Firewalls, Oracle Connection Manager, and SQL*Plus Security


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
There is no single best architecture for accommodating Internet requests requiring access to corporate intranets. Instead, trade-offs must be made between two competing goals – security of the intranet against an Internet attack and ease of access to services by both Internet and intranet clients. This course describes how firewalls are used to restrict network access and the guidelines for positioning servers within firewalls. It also explores how to configure Oracle Connection Manager to accept or reject connection requests and log connection events, and how to read connection events from the Oracle Connection Manager log. How the PRODUCT_USER_PROFILE (PUP) table is used in SQL*Plus and how to use this table to disable commands or roles in SQL*Plus is also covered.

Target Audience
Database administrators, security administrators, security compliance auditors, security compliance professionals

Prerequisites
The learner is assumed to have working experience with Oracle Database 11g or have taken the Oracle Database 11g: Administration I and Oracle Database 11g: Administration Workshop II courses. The Oracle Database 11g: Implementing Database Vault and Oracle 10g: Implementing Audit Vault courses are also recommended.

Expected Duration (hours)
1.5

Lesson Objectives

Oracle Database 11g: Firewalls, Oracle Connection Manager, and SQL*Plus Security

  • recognize how firewalls are used
  • configure Oracle Connection Manager
  • set up a firewall using CMAN
  • recognize how the PUP table is used in SQL *Plus
  • configure security using SQL *Plus
  • Course Number:
    od_odsc_a12_it_enus