Results 1 to 3 of 3

Thread: Viewing logs

  1. #1
    Join Date
    Sep 2006

    Unanswered: Viewing logs

    Is there any way to view the things that certain users have done in the database? Like creating, deleting objects, etc..

    Also is it possible to see any kind of logs on enterprise manager?


  2. #2
    Join Date
    Mar 2002
    Reading, UK
    Well you have two choices as far as I know

    1) Switch on auditing. EM can look at the audit trail though I wouldnt say the interface was particularly sophisticated.

    2) Create a system ddl trigger to log the DDL to a table.

    I have gone for the second approach where we log to a table all DDL statements. I have also created a DBA report which gets emailed to me every morning which includes all DDL statements in the last 24 hours on all of our databases. Another handy trigger is one to capture errors which also gets emailed to the developers.


  3. #3
    Join Date
    Jun 2004
    Liverpool, NY USA
    You can also use logminer to see what has been done. See the following link.
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts