Oracle Database 11g: Database Auditing

Overview/Description
Monitoring or auditing should be an integral part of your security procedures. Oracle Database 11g includes auditing tools for database, user, and fine-grained auditing. This course explores how to implement basic database auditing, privileged user auditing, DML and DDL auditing, and how to send audit records to the operating system files. Implementing fine-grained auditing (FGA), maintaining FGA policies, implementing an FGA audit event handler, and reading FGA audit events from the FGA audit trail are 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: Database Auditing

recognize how to implement basic database auditing

recognize how to implement auditing of users and objects

recognize how FGA is implemented

alter the DEFAULT profile

perform auditing of privileged users

implement fine-grained auditing