Oracle Full Secutiry Database Audit
The script will collect data regarding security issues and user access to database. Must be run as admin user. The script can be spooled to a file as well.
You can download the script by clicking on the following link
audit_oracle.sql