Solved

Oracle Audit

Posted on 2011-02-24
4
871 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to recover a database from a user managed backup
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

760 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

18 Experts available now in Live!

Get 1:1 Help Now