Yep, if you activate user trace, it will create the audit tables.
The Auditor product has some nice canned reports that run against these tables, but nothing you couldn’t develop yourself.
Start with this universe/reports
Chris Pohl 
(BOB member since 2002-06-18)