Tutorial: Creating a Standard Audit Trail

Suppose you wanted to audit SELECT statements on the OE.CUSTOMERS table. In this tutorial, you enable standard auditing, enable auditing for the SELECT SQL statement, run the SELECT SQL statement on the OE.CUSTOMERS table, and then check its audit file.

In this tutorial:

• Step 1: Log In and Enable Standard Auditing

• Step 2: Enable Auditing for SELECT Statements on the OE.CUSTOMERS Table

• Step 3: Test the Audit Settings

• Step 4: Optionally, Remove the Components for This Tutorial

• Step 5: Remove the SEC_ADMIN Security Administrator Account