Auditing In Oracle Of Sys and Other Users

- 

- 

-  

SQL> SHOW PARAMETER AUDIT

NAME                 TYPE        VALUE
----------------------------------------------------
audit_file_dest      string      C:\ORACLE\PRODUCT\10.2.0\
                                 ADMIN\DB10G\ADUMP
audit_sys_operations boolean     FALSE
audit_trail          string      NONE
SQL>

Audit is disable by default, but can be enabled by audit_trail 

static parameter which can have following possible values.

Audit_Trail = 'Following_Option'