Results 1 to 3 of 3

Thread: Viewing logs

  1. #1
    Join Date
    Sep 2006
    Posts
    19

    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?

    Thanks

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    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.

    Alan

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    You can also use logminer to see what has been done. See the following link.

    http://www.oracle.com/technology/pro...ily/oct25.html
    Bill
    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
  •