AUDIT_TRAIL

Property Description
Parameter type String
Syntax AUDIT_TRAIL = { none | os | db [, extended] | xml [, extended] }
Default value none
Modifiable No
Basic No

AUDIT_TRAIL enables or disables database auditing.

Values:

  • none

    Disables database auditing.

  • os

    Enables database auditing and directs all audit records to the operating system's audit trail.

  • db

    Enables database auditing and directs all audit records to the database audit trail (the SYS.AUD$ table).

  • db, extended

    Enables database auditing and directs all audit records to the database audit trail (the SYS.AUD$ table). In addition, populates the SQLBIND and SQLTEXT CLOB columns of the SYS.AUD$ table.

  • xml

    Enables database auditing and writes all audit records to XML format OS files.

  • xml, extended

    Enables database auditing and prints all columns of the audit trail, including SqlText and SqlBind values.

You can use the SQL AUDIT statement to set auditing options regardless of the setting of this parameter.