Solved

AUDITING TOOLS

Posted on 2011-03-03
5
553 Views
Last Modified: 2012-05-11
can any one help me out regarding AUDITING TOOLS.i am enabling the auditing in database level audit_trail=db, i want to see all users actions like login and logoff(all DDL and DML),which tool is better ?
0
Comment
Question by:Cha1tu
5 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35029066
Are you looking for tools to 'report' or review audit records or tools to help you set up and configure auditing, or both?

0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35029095
I guess I also need to ask how your applications work?  

Many applications today do not allows users of the application to log directly into the database and perform work.  You log into the 'app' and the application does all the database work for you.

So if you are looking to audit those types of apps, you will need to work the the app provider.
0
 
LVL 2

Author Comment

by:Cha1tu
ID: 35029880
@slightwv:   i need tools for  'report'  & review audit records .

and also can you tell me which tools we can use to help us set up and configure auditing

Acutally the application replated to healthcare and we have reporting toolos like cognos
0
 
LVL 4

Expert Comment

by:pinkuray
ID: 35078007
you can check TOAD (Quest Software’s Toad for Oracle) which can provide you the desired report for audit in oracle DB or check Deloitte’s OASIS Tool.
0
 
LVL 23

Accepted Solution

by:
OP_Zaharin earned 500 total points
ID: 35078266
1-to setup audit and configure audit to log DDL (create, alter, drop objects..), DML (insert, update..) and System Events (logon, logoff..)

c:\sqlplus sys/password AS SYSDBA

sql> AUDIT ALL BY <user> BY ACCESS;
sql> AUDIT SELECT TABLE, UPDATE TABLE, INSERT TABLE, DELETE TABLE BY <user> BY ACCESS;
sql> AUDIT EXECUTE PROCEDURE BY <user> BY ACCESS;



2-to view the audit
SELECT username,
       extended_timestamp,
       owner,
       obj_name,
       action_name
FROM   dba_audit_trail
WHERE  owner = '<user>'
ORDER BY timestamp;

you can run the sql statement on any sql editor tools and output it into csv/text/html provided by that tools (such as Toad, SQL Navigator, Tora and etc). And massaging the data in any reporting tool you have.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
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.

746 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