Oracle audit logon trigger - auditing user activity. Starting with Oracle8i, Oracle introduced special triggers that are not associated with specific DML events (e.g., INSERT, UPDATE, and DELETE).
These system-level triggers included database startup triggers, DDL triggers, and end-user login/logoff triggers. While Oracle provided the functionality for these new triggers, it was not clear how they could be used in order to track system-wide usage. Auditing Database Use. This chapter describes how to use the Oracle database server's auditing facilities, and contains these topics: Guidelines for Auditing This section describes guidelines for auditing and contains the following topics: Decide Whether to Use the Database or Operating System Audit Trail.
