Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How to find AUDIT infromation ?

Posted on 2006-10-26
9
Medium Priority
?
1,455 Views
Last Modified: 2012-05-05
I have one database someone created and setup. I want to know what kind of AUDIT is on. I have seen to couple DBA view according to documentation.

 select * from DBA_STMT_AUDIT_OPTS
====== OUTPUT ======
USER_NAME      PROXY_NAME      AUDIT_OPTION      SUCCESS      FAILURE

            ALTER SYSTEM      NOT SET      BY ACCESS
            SYSTEM AUDIT      NOT SET      BY ACCESS
            CREATE SESSION      BY ACCESS      BY ACCESS
            TABLE      NOT SET      BY ACCESS
            CLUSTER      NOT SET      BY ACCESS
            TABLESPACE      NOT SET      BY ACCESS
            USER      NOT SET      BY ACCESS
            ROLLBACK SEGMENT      NOT SET      BY ACCESS
            TYPE      NOT SET      BY ACCESS
            INDEX      NOT SET      BY ACCESS
            SYNONYM      NOT SET      BY ACCESS
            PUBLIC SYNONYM      NOT SET      BY ACCESS
            VIEW      NOT SET      BY ACCESS
            SEQUENCE      NOT SET      BY ACCESS
            DATABASE LINK      NOT SET      BY ACCESS
            PUBLIC DATABASE LINK      NOT SET      BY ACCESS
            ROLE      NOT SET      BY ACCESS
            DIMENSION      NOT SET      BY ACCESS
            PROCEDURE      NOT SET      BY ACCESS
            TRIGGER      NOT SET      BY ACCESS
            PROFILE      NOT SET      BY ACCESS
            DIRECTORY      NOT SET      BY ACCESS
            SYSTEM GRANT      NOT SET      BY ACCESS
            NOT EXISTS      NOT SET      BY ACCESS
            CONTEXT      NOT SET      BY ACCESS
=============== OUTPUT END ==============

I have also look at select * from  DBA_PRIV_AUDIT_OPTS
USER_NAME      PROXY_NAME      PRIVILEGE      SUCCESS      FAILURE

            ALTER SYSTEM      NOT SET      BY ACCESS
            AUDIT SYSTEM      NOT SET      BY ACCESS
            CREATE SESSION      BY ACCESS      BY ACCESS
====================================================

Can anybody know how to interpret this  tables, so I can understand excatly what kind of AUDIT was installed.

Thanks
~Keyur
0
Comment
Question by:Keyurkumar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
9 Comments
 
LVL 7

Accepted Solution

by:
Daniel Stanley earned 1000 total points
ID: 17814322
ACCESS auditing has been enabled for your database. This is a fundamental check to find out who accesses the database, from where and when. it can be turned off and on with the audit_trail init param.

hope this helps,
daniels
0
 
LVL 7

Expert Comment

by:Daniel Stanley
ID: 17814356
other types of AUDIT methods are:

select table, update table, insert table, delete table, execute procedure, etc...

example:  sql> audit execute procedure by scott by access;


good luck,
daniels
0
 
LVL 3

Author Comment

by:Keyurkumar
ID: 17814400
how we can start this kind of audit
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 7

Expert Comment

by:Daniel Stanley
ID: 17814441
0
 
LVL 3

Author Comment

by:Keyurkumar
ID: 17814878
what is meaning of -/- value in dba_obj_audit_opts tables.

Thanks
0
 
LVL 7

Expert Comment

by:Daniel Stanley
ID: 17814966
select table_name, column_name, substr(comments,1,60)
from dict_columns where table_name = 'DBA_OBJ_AUDIT_OPTS';



0
 
LVL 3

Author Comment

by:Keyurkumar
ID: 17815177
Hey drs66,
Thanks for you help.
It says something like that, which is almost same as documentation.
Auditing ALTER WHENEVER SUCCESSFUL / UNSUCCESSFUL

But I dont understand that what's meaning of -/-, Is it mean null/null, or is it mean auditing whenever successfull or unsuccessfull.

Thanks

~Keyur
0
 
LVL 1

Expert Comment

by:Computer101
ID: 20296176
Forced accept.

Computer101
EE Admin
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
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.

636 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