DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2001

    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
    Pretoria, Rep of South Africa


    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

    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

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