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.