Overview

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

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.