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

Thread: Audit options can not be turned off

  1. #1

    Audit options can not be turned off

    In Oracle 9.2.0.6, I turned on many audit options and turned them off with NOAUDIT command. Eventually, some of the audit options cannot be turned off:
    USER_NAME PROXY_NAME AUDIT_OPTION SUCCESS FAILURE
    ---------------- ------------------------------ ---------------------------------------- ---------- ----------
    ANY CLIENT SELECT ANY TABLE BY ACCESS BY ACCESS
    ANY CLIENT INSERT ANY TABLE BY ACCESS BY ACCESS
    ANY CLIENT DELETE ANY TABLE BY ACCESS BY ACCESS

    What does "ANY CLIENT" mean? How to turn these audit options off?
    Queyon Zeng

  2. #2
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Unset the AUDIT_TRAIL in the init file.
    "What is past is PROLOGUE"

  3. #3
    Quote Originally Posted by dbasan
    Unset the AUDIT_TRAIL in the init file.
    So what if I need to turn them on again?
    Nobody likes restarting the database all the time.
    Queyon Zeng

  4. #4
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    You should READ this.
    "What is past is PROLOGUE"

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