Implementing Oracle Database Auditing

Introduction

The Implementing Oracle Database Auditing module explores the concepts of how to audit database usage.

• Auditing Database Activity
• Purging the Audit Trail
• Managing Fine Grained Auditing
• Implementing Unified Auditing

Exercise 1 - Auditing Database Activity

In this exercise, you will learn the following about auditing database activity:

• Establishing connection to the database
• Managing Statement Auditing
• Managing Privilege Auditing
• Managing Object Auditing

Exercise 2 - Purging the Audit Trail

In this exercise, you will learn the following about purging the audit trail:

• Moving SYS.AUD$ to Another Tablespace
• Using the Audit Management Framework

Exercise 3 - Managing Fine Grained Auditing

In this exercise, you will learn the following about managing fine grained auditing:

• Creating an FGA Policy
• Enabling an FGA Policy
• Disabling an FGA Policy
• Dropping an FGA Policy
• Identifying FGA Policies in the Database
• Reporting on the FGA Audit Trail Entries

Exercise 4 - Implementing Unified Auditing

In this exercise, you will learn the following about implementing unified auditing:

• Creating a Unified Audit Policy
• Using Component Auditing
• Enabling and Disabling Audit Policy
• Querying Audit Information and Audit Policies
• Purging Unified Audit Records
• Unified Auditing Internals