Step 3: Test the Audit Settings

At this stage, auditing is enabled and any SELECT statements performed on the OE.CUSTOMERS table are written to the to DBA_AUDIT_TRAIL view. Now, you are ready to test the audit settings.

To test the audit settings:  

1. Start SQL*Plus, and connect as user sec_admin.

   SQLPLUS sec_admin
   Enter password: password
   

2. Enter the following SELECT statement to create an alert in the audit trail:

   SELECT COUNT(*) FROM oe.customers;
   

3. Enter the following statement to view the DBA_AUDIT_TRAIL view:

   SELECT USERNAME, TIMESTAMP FROM DBA_AUDIT_TRAIL;
   

   Output similar to the following appears:

   USERNAME          TIMESTAMP
   ---------------------------
   SEC_ADMIN         07-MAY-09
   

4. Exit SQL*Plus:

   EXIT