How to find AUDIT infromation ?

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
LVL 3
KeyurkumarAsked:
Who is Participating?
 
Daniel StanleyConnect With a Mentor Database engineerCommented:
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
 
Daniel StanleyDatabase engineerCommented:
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
 
KeyurkumarAuthor Commented:
how we can start this kind of audit
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Daniel StanleyDatabase engineerCommented:
0
 
KeyurkumarAuthor Commented:
what is meaning of -/- value in dba_obj_audit_opts tables.

Thanks
0
 
Daniel StanleyDatabase engineerCommented:
select table_name, column_name, substr(comments,1,60)
from dict_columns where table_name = 'DBA_OBJ_AUDIT_OPTS';



0
 
KeyurkumarAuthor Commented:
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
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.