ORACLE DATABASE AUDITING

 

DATABASE AUDITING

 

Database auditing is the monitoring and recording a activities within a database

 

audit_sys_operations True  Enable for sys

 

audit_file_dest /u01/app/oracle/admin/oracledb/adump

audit_trail  True/DB or NONE Enable for normal user

 

Standard Auditing

 

Schema object level Auditing -> specify Schema object to be audited

 

Statement level Auditing   -> Sql Statement to be audited

 

Privilege level Auditing   -> Particular system Privilege to be audited

 

Scope of Auditing

 

by USER/ALL

by session/access

by successful/unsuccessful

 

Statement level auditing

 

dba_audit_session

dba_audit_trail

dba_stmt_audit_opts

 

 

 

 

Disable auditing

 

 

 

 

 

Object level auditing

 

 

 

 

     

 

 

 

 

 

 

Privilege level