DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Hybrid View

  1. #1
    Join Date
    Jun 2007

    Noaudit Session By User


    I Enable session auditing by running audit session. All work Ok.

    Now I want to disable session auditing just for DBSNMP user.

    I enter
    SQL> noaudit session by DBSNMP;

    Noaudit succeeded.

    but it does not work auditing still continues
    Orcale 10g

    Any ideas ?!!

    Oracle Database 10g Enterprise Edition Release - 64bi
    PL/SQL Release - Production
    CORE Production
    TNS for Solaris: Version - Production
    NLSRTL Version - Production

    Thanks in advance

  2. #2
    Join Date
    Aug 2007
    Cyberjaya,kuala lumpur
    i have a doubt, we need to disable the parameter "audit_trail".
    what is the value for that parameter ?

  3. #3
    Join Date
    Jun 2007
    But I can't do it. I need auditing for the rest of the system I just want to exclude one I don't want to audit

  4. #4
    Join Date
    Mar 2007
    Ft. Lauderdale, FL
    mmhh, not sure if you have a real grip of how AUDIT/NOAUDIT works... are you aware NOAUDIT only stops auditing operations previously enabled by the AUDIT statement? meaning a NOAUDIT statement will cancel something you set using a matching AUDIT one?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.