Property | Description |
---|---|
Parameter type | String |
Syntax | AUDIT_TRAIL = { none | os | db | db,extended | xml | 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 statement AUDIT
to set auditing options regardless of the setting of this parameter.