How to track structural changes in db

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • LC
    #1

    How to track structural changes in db

    hi,
    i worry about people doing something they shouldn't to my db and I
    would like to track any structural changes (who and which)to my db. I
    am using oracle 8.0.6.0.0 and 9.2.0.2.0.

    regards,
    Lee Cho
    Tags: None
    • Jim Kennedy
      #2
      Re: How to track structural changes in db


      "LC" <leecholim@hotm ail.comwrote in message
      news:d15e389.04 06240044.65c6e9 cd@posting.goog le.com...
      hi,
      i worry about people doing something they shouldn't to my db and I
      would like to track any structural changes (who and which)to my db. I
      am using oracle 8.0.6.0.0 and 9.2.0.2.0.
      >
      regards,
      Lee Cho
      Best way is to not give them the rights to do any. If you have to then
      create a trigger on ddl changes and track the user and when in a table. See
      SQL Reference documentation.
      Jim


        Comment

        • abhay
          #3
          Re: How to track structural changes in db

          leecholim@hotma il.com (LC) wrote in message news:<d15e389.0 406240044.65c6e 9cd@posting.goo gle.com>...
          hi,
          i worry about people doing something they shouldn't to my db and I
          would like to track any structural changes (who and which)to my db. I
          am using oracle 8.0.6.0.0 and 9.2.0.2.0.
          >
          regards,
          Lee Cho
          At least in case of 9.2.0.2.0 database, you can use APPLICATION_DDL trigger.

            Comment

            Previous template Next
            Working...