Solved

Oracle Audit

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Note: This is the second blog post in a series on email clearinghouses (https://www.xmatters.com/alert-management/blog-email-has-failed-us?utm_campaign=70138000000ydLoAAI&utm_source=exex&utm_medium=article&utm_content=blog-post).   Every month t…
There's a better way to communicate time sensitive or critical info.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

776 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