Solved

Oracle Audit

Posted on 2011-02-24
4
884 Views
Last Modified: 2013-12-07
How can I know which audit option is currently enabled in Oracle database?

e.g.
If I type
AUDIT DATABASE LINK BY SESSION WHENEVER SUCCESSFUL;

the Oracle database will start auditing this right?

But how can I know all the audit rules and setting that are enabled in Oracle?

Is it just query the DBA_AUDIT_TRAIL table?

I don't think so....
Which table can I find out Oracle is curerntly auditing the above statement?
0
Comment
Question by:mawingho
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 28

Accepted Solution

by:
Naveen Kumar earned 334 total points
ID: 34976976
check these views :

DBA_PRIV_AUDIT_OPTS
DBA_STMT_AUDIT_OPTS
DBA_OBJ_AUDIT_OPTS

Related to FGA ( fine grained auditing )
DBA_AUDIT_POLICIES
DBA_AUDIT_POLICY_COLUMNS
0
 
LVL 28

Assisted Solution

by:Naveen Kumar
Naveen Kumar earned 334 total points
ID: 34976985
i think these 3 should have what you are looking for. ( add where clauses accordingly ) :

select * from DBA_PRIV_AUDIT_OPTS

select * from DBA_STMT_AUDIT_OPTS

select * from DBA_OBJ_AUDIT_OPTS
0
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 166 total points
ID: 34979098
nav_kum_v is correct.  

Just wanted to add:  Always start in the docs.

Using Data Dictionary Views to Find Information About the Audit Trail

http://download.oracle.com/docs/cd/E11882_01/network.112/e16543/auditing.htm#DBSEG485
0
 

Author Closing Comment

by:mawingho
ID: 35121451
thanks
0

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Why pager replacement is still an issue OnPage has what some might call a “hate/hate” relationship with pagers. Not much room for love. As we see it, pagers are an antiquated bit of technology. Pagers are dinosaurs which, like most dinosaurs, sho…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question