Skip to main content

Whitepaper

Oracle Data Definition Language (DDL) Auditing

Download PDF (124 KB)

Whitepaper on auditing and logging data definition language (DDL) changes in Oracle Database, comparing standard auditing, system triggers, the Database Lifecycle Management Pack and third-party tools.

Relational databases use DDL statements to define structures such as tables to store data and functions to store code. Monitoring, auditing and logging changes to DDL are key components of a database security program, especially when supporting Enterprise Resource Planning (ERP) solutions such as SAP, PeopleSoft, and the Oracle E-Business Suite.

The options for DDL auditing include:

  • Standard auditing
  • System Triggers
  • Oracle Database Lifecycle Management Pack
  • Third party tools such as Imperva and Guardium