johnjohn1976

 Profile Answers by johnjohn1976 

• May 25th, 2009

 

Auditing is a functionality which keep track of all the activity happening to DB

There are two type of auditing in Oracle

1, Standard Auditing
2. Fine grained Auditing

The standard Auditing is again divided by Statement, Privilege and Object.

Statement - Tracks all action on any type of objects
Privilege - Tracks action on system level
Object - Track action on all the objects (table update, delete etc)

Enabling Audit  Audit_Trail = True in int.ora file

Audit can be of os, db, db & extended etc.

Dba_audit_trail table is data dictionary table gives information on audit.

yossin

 Profile Answers by yossin 

• Oct 15th, 2009

 

There's another option.
There is a product called OraPlayer, that is tracking all actions performed by all the end-users of Oracle Forms.
It tracks all the data sent from the forms user to the server and from the server.