Database Auditing
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Database Auditing

  1. #1
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    Is it possible to turn Auditing for the current session and whenthe user logsoff from SQL*PLUS it should be turned off.

    Any help will be appreciated.

    Thanks.
    Vijay.
    Say No To Plastics

  2. #2
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    For auditing purpose , you can use sql_trace which can be turned on/off by session wise
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  3. #3
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Hi Vijay,

    You could create a trigger logon that enable audit for this user and a trigger looff for disable auditing.

    Cheers

    Angel

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