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

Thread: Database Audit Reports

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    Database Audit Reports

    We have enabled database auditing in our UAT environment (version 8.1.7
    and 9.02).

    We want to create some shell scripts to query those tables on a daily
    basis and produce some type of reports

    - any users that tried to log in more than three times unsuccessfully
    - statements being executed by certain ids


    Does any one currently have any SQL's they use against the audit tables?

    Any reports that they produce?

    Your help would be greatly appreciated.

  2. #2
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191

    Talking

    Here is some SQL I use. Use whatever is relevant.
    Attached Files Attached Files
    Able was I ere I saw Elba

  3. #3
    Join Date
    Jan 2001
    Posts
    515

    Thank you


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