In an Oracle Database we can mention following auditing types:
  • Mandatory Auditing
  • Standard Auditing
  • Fine-Grained Auditing
  • SYS Auditing
Mandatory Auditing causes database start-up/shut-down and SYSDBA-SYSOPER login logout information to be written into AUDIT_FILE_DEST. This auditing cannot be turned off and it's always written into operating system directory specified with AUDIT_FILE_DEST.

Standard Auditing is controlled with AUDIT_TRAIL parameter. (NONE,OS,DB,DB_EXTENDED,XML,XML_EXTENDED)
When DB or DB_EXTENDED is used, audit records are written into database (aud$ table). (Not the mandatory auditing records, they're always on OS)
XML options write to operating system in XML format.
When *EXTENDED is used SQLBIND and SQLTEXT information is included in the audit trail. If not used, not included.
By default, Standard Auditing audits SQL statements which use following privileges:
ALTER ANY PROCEDURE | CREATE ANY LIBRARY | DROP ANY TABLE | ALTER ANY TABLE | CREATE ANY PROCEDURE | DROP PROFILE | ALTER DATABASE | CREATE ANY TABLE | DROP USER | ALTER PROFILE | CREATE EXTERNAL JOB | EXEMPT ACCESS POLICY | ALTER SYSTEM | CREATE PUBLIC DATABASE LINK | GRANT ANY OBJECT PRIVILEGE | ALTER USER | CREATE SESSION | GRANT ANY PRIVILEGE | AUDIT SYSTEM | CREATE USER | GRANT ANY ROLE | CREATE ANY JOB | DROP ANY PROCEDURE
It's possible to audit Statements, Privileges and Objects with Standard Auditing. For example:
  • Privilege auditing: audit select any table; 
  • Statement auditing: audit select table; 
  • Object auditing: audit select on SCOTT.SALARY;
Following views give information about current Standard Auditing configuration in the database:
  • DBA_STMT_AUDIT_OPTS; ==> describes current statements being audited across the system
  • DBA_PRIV_AUDIT_OPTS; ==> describes current system privileges being audited across the system
  • DBA_OBJ_AUDIT_OPTS;   ==> describes auditing options for all objects 
You can use the SQL "AUDIT" statement to set auditing options regardless of the setting of AUDIT_TRAIL parameter. However, Oracle Database does not generate audit records until you enable Standard Auditing using AUDIT_TRAIL parameter.
Auditing to OS offers higher performance when compared with DB. 

Fine-Grained Auditing is used to audit operations like: 
  • Accessing a table outside of normal working hours 
  • Logging in from a particular IP address 
  • Selecting or updating a particular table column
DBMS_FGA package is used to manage Fine-Grained Auditing. DBA_AUDIT_POLICIES view describes all fine-grained auditing policies in the database.
It's not mandatory to enable Standard Auditing in order to use Fine-Grained Auditing or SYS Auditing.
SYS AuditingAUDIT_SYS_OPERATIONS parameter (TRUE/FALSE) enables or disables the auditing of SQL statements that directly issued by users connected with SYSDBA or SYSOPER privileges (SQL statements run from within PL/SQL procedures or functions are not audited). These audit records are written into OS.
It's not mandatory to enable Standard Auditing in order to use SYS Auditing.




53 Responses so far.

  1. MSBI remains for Microsoft Business Intelligence. This apparatus utilizes Visual studio alongside SQL server.
    do you want to learn a high level language ?then you get job opportunity for all over world. || https://www.gangboard.com/app-programming-scripting-training/php-training
    https://www.gangboard.com/cloud-computing-training/vmware-training
    https://www.gangboard.com/business-intelligence-training/msbi-training
    https://www.gangboard.com/app-programming-scripting-training/chef-training
    https://www.gangboard.com/cloud-computing-training/openstack-training


  2. All are saying the same thing repeatedly, but in your blog I had a chance to get some useful and unique information, I love your writing style very much, I would like to suggest your blog in my dude circle, so keep on updates.


    Digital Marketing Training in Chennai

  3. Sathya G says:


    the blog is very useful, interesting and informative. thank you for sharing the blog with us. keep on updating.
    Email Marketing Chennai

  4. priya says:

    I simply couldn’t depart your site before suggesting that I really enjoyed the usual information an individual supply in your visitors? Is going to be again steadily to check out new posts.

    Online Training in Chennai

  5. Priya says:

    Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
    oracle training in chennai | oracle training institutes in chennai

  6. Priya says:

    Excellent post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
    salesforce training in chennai | salesforce training institute in chennai

  7. kalai says:

    very interesting to read,thanks for sharing that wonderful useful information,given programming coding was very excellent and easily observe all provided information.


    Dot Net training

  8. Good post. I learn something totally new and challenging on blogs I stumble upon on a daily basis. It will always be interesting to read articles from other authors and practice something from their websites...


    Dental Hospital In Chennai

  9. Thanks for great topic such a very nice post. about the oracle fusion financials great topics and really best points were started in the blog for more details can below visit .

  10. You have shared very useful details with me. Thanks for your great effort.

    DBA course | Oracle dba course

  11. Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here"Oracle Training in Chennai".

  12. Nikitha says:

    I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

    Oracle Fusion Financials Online Training

  13. shekar says:

    Awesome post……. your article is really informative and helpful for me and other bloggers too

    oracle fusion scm online training

  14. Anonymous says:

    Tirupati Tour Packages from Chennai in Srinivasatravels. Chennai Tirupati one day tour Packages. We provide different Tirupati Packages. Book Tirupati Package from Chennai through srinivasatravels.

    Tirupati Package from Chennai
    Chennai Tirupati one day tour Packages
    Tirupati tour packages from Chennai

  15. Sravani says:

    Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.

    Oracle Fusion HCM Online Training

  16. sushma says:

    Hey Really Thanks for sharing the best information regarding category,hope you will write more great blogs.
    Oracle Fusion Financial Online Training

  17. raju says:

    Thank you for sharing such a nice and interesting blog.
    Oracle Fusion Financials Online Training

  18. I simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site.



    Best Java Training Institute Chennai

  19. Oracle says:

    Really excellent information and thank you for giving your valuable information

    Oracle Fusion SCM Online Training

  20. Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.
    Hadoop Training Institute In chennai

  21. Naga says:

    Very interesting blog, keep posting such an informative post.

    Oracle Fusion Financials Online Training

  22. tirupathi says:

    Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.

  23. My rather long internet look up has at the end of the day been compensated with pleasant insight to talk about with my family and friends.


    Digital Marketing Training in chennai


  24. leela says:

    Really very helpful article, Thank you for sharing interesting blogs.

    Oracle Fusion Technical Online Training

  25. ais a says:

    Appreciation for really being thoughtful and also for deciding on certain marvelous guides most people really want to be aware of.
    Best selenium training Institute in chennai

  26. Very helpful tutorial thank you so much
    MSBI Training in Hyderabad

  27. nivatha says:

    Appreciation for really being thoughtful and also for deciding on certain marvelous guides most people really want to be aware of.
    Best selenium training Institute in chennai

  28. Manoj says:

    Beproject centre provides mca mini projects in chennai and give summer course for java, dotnet,matlab, embedded, iot, php&mysql courses are available. matlab projects in chennai courses for ECE/EEE students.

  29. That is really good post, thank you for sharing the video as well, it isn't easy to make but I will definitely try to make one by myself
    Salesforce Training in Hyderabad

  30. Thank you for sharing such a nice and interesting blog and very useful details with me. Thanks for your great effort.

    oracle fusion financials online training

  31. Really very helpful article Thank you for sharing such a nice and interesting blog

    Oracle Fusion SCM Online Training

  32. Nice article and explanation is good, Thank you for sharing your experience on oracle.you have clearly explained about the process thus it is very much interesting and I got more information from your blog.For more details about Best Oracle HRMS Training in Hyderabad

  33. simbu says:

    Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.

    java training in chennai | java training in bangalore

    java online training | java training in pune

    java training in chennai | java training in bangalore

  34. Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.
    Devops training in tambaram
    Devops training in velachery
    Devops training in annanagar

    DevOps online Training




  35. Inspiring writings and I greatly admired what you have to say , I hope you continue to provide new ideas for us all and greetings success always for you..Keep update more information..

    rpa training in Chennai

    rpa training in anna nagar | rpa training in marathahalli

    rpa training in btm | rpa training in kalyan nagar

    rpa training in electronic city | rpa training in chennai

    rpa online training | selenium training in training

  36. nivatha says:

    Thanks for splitting your comprehension with us. It’s really useful to me & I hope it helps the people who in need of this vital information. 

    Data Science Training in Chennai
    Data science training in bangalore
    Data science online training
    Data science training in pune
    Data science training in kalyan nagar
    selenium training in chennai

  37. I prefer to study this kind of material. Nicely written information in this post, the quality of content is fine and the conclusion is lovely. Things are very open and intensely clear explanation of issues
    python training institute in chennai
    python training in Bangalore
    python training in pune
    python online training

  38. This is beyond doubt a blog significant to follow. You’ve dig up a great deal to say about this topic, and so much awareness. I believe that you recognize how to construct people pay attention to what you have to pronounce, particularly with a concern that’s so vital. I am pleased to suggest this blog.
    python training institute in chennai
    python training in Bangalore
    python training in pune
    python online training

  39. vishnu says:

    It is a great post. Thank you for sharing this wonderful information

    Oracle Training in Chennai | Oracle Certification in Chennai

  40. ragini k says:

    The site was so nice, I found out about a lot of great things. I like the way you make your blog posts. Keep up the good work and may you gain success in the long run.
    Blueprism training in tambaram

    Blueprism training in annanagar

    Blueprism training in velachery

  41. Nila shri says:

    The knowledge of technology you have been sharing through this post is very much helpful to develop a new idea. hereby I also want to share this.
    Data Science training in kalyan nagar | Data Science training in OMR
    Data Science training in chennai | Data science training in velachery
    Data science online training

  42. A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article. I am learning a lot from you.
    python training in tambaram
    python training in annanagar
    python training in jayanagar

  43. gowsalya says:

    Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.
    DevOps online Training

  44. Sugi Bala says:

    I love the blog. Great post. It is very true, people must learn how to learn before they can learn. lol i know it sounds funny but its very true. . .
    java training in omr | oracle training in chennai

    java training in annanagar | java training in chennai

  45. Anonymous says:

    Your very own commitment to getting the message throughout came to be rather powerful and have consistently enabled employees just like me to arrive at their desired goals.

    angularjs Training in chennai
    angularjs Training in chennai

    angularjs-Training in tambaram

    angularjs-Training in sholinganallur

    angularjs-Training in velachery

  46. Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time. Please keep updating.
    Web Design Training

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -