Database Audit Reports

[lesstjm]

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.

[robertbalmer]

Here is some SQL I use. Use whatever is relevant.

[lesstjm]