Solved

Oracle auditing question

Posted on 2013-01-15
2
260 Views
Last Modified: 2013-01-17
How to check what is being audited for a particular user?
0
Comment
Question by:YZlat
2 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 150 total points
ID: 38780265
Check: DBA_STMT_AUDIT_OPTS
http://docs.oracle.com/cd/E11882_01/server.112/e25513/statviews_4292.htm#REFRN23255



Also take a look at:
Using Data Dictionary Views to Find Information About the Audit Trail

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

Author Closing Comment

by:YZlat
ID: 38787811
Thank you!
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

Suggested Solutions

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
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 shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

895 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

13 Experts available now in Live!

Get 1:1 Help Now