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.