auditing

Auditing

• Auditing is the monitoring of selected user database actions,and is used to:
  • Investigate suspicious database activity
  • Gather information about specific database activities
• Auditing can be performed by session or access

by session:用户登陆上来后，发出同类型的SQL语句，oracle只会记录一条.

bu access:发出一条sql语句，Oracle就会记录一条.

SQL> audit select on scott.t;

Audit succeeded.

 

SQL> noaudit select on scott.t;

Noaudit succeeded.

SQL>audit select on scott.t;