Oracle Database Auditing

How will you enable database auditing? In How many ways can you implement database auditing?

Questions by krishnaprasad.sola   answers by krishnaprasad.sola

Showing Answers 1 - 2 of 2 Answers

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.

  Was this answer useful?  Yes


  • 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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions