| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
| Property | Description |
|---|---|
| Parameter type | String |
| Syntax | AUDIT_TRAIL = { db | os | none | true | false | db_extended } |
| Default value | none |
| Modifiable | No |
| Basic | No |
AUDIT_TRAIL enables or disables database auditing.
Values:
none or false
Disables database auditing.
os
Enables database auditing and directs all audit records to the operating system's audit trail.
db or true
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.
You can use the SQL statement AUDIT to set auditing options regardless of the setting of this parameter.