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

Database administrators, security administrators, security compliance auditors, security compliance professionals

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

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.


Using Oracle Connection Manager as a Firewall

  • recognize how firewalls are used
  • configure Oracle Connection Manager
  • set up a firewall using CMAN

SQL*Plus Security

  • recognize how the PUP table is used in SQL *Plus
  • configure security using SQL *Plus





Multi-license discounts available for Annual and Monthly subscriptions.