• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1456
  • Last Modified:

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
0
Keyurkumar
Asked:
Keyurkumar
  • 4
  • 3
1 Solution
 
Daniel StanleyCommented:
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 StanleyCommented:
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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

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

Thanks
0
 
Daniel StanleyCommented:
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

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now