GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle  >  Database security

 Print  |  
Question:  Oracle Database Auditing

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


May 05, 2009 12:42:28 #1
 johnjohn1976   Member Since: May 2009    Total Comments: 1 

RE: Oracle Database Auditing
 

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.

     

 

Back To Question