What is AUDIT_TRAIL ?

What is AUDIT_TRAIL ?

Rating:

AUDIT_TRAIL is a parameter of STRING type with a default value of none. AUDIT_TRAIL enables or disables database auditing. If the initialization parameter AUDIT_TRAIL is set to OS, then it enables database auditing and directs all audit records to the operating system's audit trail, or alternatively, if the initialization parameter is set to DB then it enables database auditing and directs all audit records to the database audit trail (the SYS.AUD$ table), or alternatively, if the initialization parameter AUDIT_TRAIL is set to DB_EXTENDED then it enables database auditing, directs all audit records to the database audit trail (the SYS.AUD$ table) and additionally also populates the SQLBIND and SQL TEXT CLOB columns of the SYS.AUD$ table.

The SQL statement AUDIT can be used to set the auditing options regardless of the setting of the AUDIT_TRAIL parameter.

Rating: