Solved

Oracle Audit

Posted on 2011-02-24
4
876 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
  • 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 76

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

How can you create a game plan that lets you focus on special projects instead of running from cubicle to cubicle every day and feeling like you’ve accomplished nothing? Try these strategies for prioritizing your tasks, offloading what you can, and …
Email signature management is something that is often overlooked in many organizations or is simply not implemented effectively. Let's take a look at what methods are available for managing this important piece of corporate branding.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

910 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now